Question 1

A spreadsheet is just another type of relational database.

Accepted Answer

A) True 
 B)False  False

Question 2

A relational database refers to

Accepted Answer

A)  databases that have related objects related by similar attributes. 
B)  a set of tables that contains similar content. 
C)  a set of files that have similar names. 
D)  databases that carry data in the form of tables with individual primary keys. 
E)  databases that carry data in the form of tables and that represent relationships using foreign keys. 
A)  databases that have related objects related by similar attributes. 
B)  a set of tables that contains similar content. 
C)  a set of files that have similar names. 
D)  databases that carry data in the form of tables with individual primary keys. 
E)  databases that carry data in the form of tables and that represent relationships using foreign keys. E

Question 3

The name of the field, the data type, and number of characters allowed are examples of

Accepted Answer

A)  attributes. 
B)  characters. 
C)  content. 
D)  overhead. 
E)  metadata. 
A)  attributes. 
B)  characters. 
C)  content. 
D)  overhead. 
E)  metadata. E

Question 4

Modern content management systems

Accepted Answer

A)  seek out documents located across an organization and actively manage access to the content. 
B)  manage only media files. 
C)  archive documents. 
D)  organize content for corporate websites. 
E)  manage all aspects of corporate data. 
A)  seek out documents located across an organization and actively manage access to the content. 
B)  manage only media files. 
C)  archive documents. 
D)  organize content for corporate websites. 
E)  manage all aspects of corporate data.

Question 5

Many users prefer to avoid database applications altogether and simply store their data in a(n)

Accepted Answer

A)  mattress. 
B)  file. 
C)  old can. 
D)  spreadsheet. 
E)  encrypted table. 
A)  mattress. 
B)  file. 
C)  old can. 
D)  spreadsheet. 
E)  encrypted table.

Question 6

________ is an example of an enterprise DBMS.

Accepted Answer

A)  Access 
B)  DB2 
C)  FoxPro 
D)  Quattro Pro 
E)  Paradox 
A)  Access 
B)  DB2 
C)  FoxPro 
D)  Quattro Pro 
E)  Paradox

Question 7

The ________ problem is unique to a multi-user database environment.

Accepted Answer

A)  redundancy 
B)  lost-update 
C)  locked file 
D)  security 
E)  data integrity 
A)  redundancy 
B)  lost-update 
C)  locked file 
D)  security 
E)  data integrity

Question 8

Which of the following techniques is used to resolve the lost-update problem?

Accepted Answer

A)  Preemptive updating 
B)  Sharing 
C)  Task switching 
D)  Locking 
E)  Multitasking 
A)  Preemptive updating 
B)  Sharing 
C)  Task switching 
D)  Locking 
E)  Multitasking

Question 9

If a user stores their data in a spreadsheet, it is unavailable to other users unless it is stored in the company's ________.

Accepted Answer

The answer of If a user stores their data in...

Question 10

Which of the following is a file extension name of an audio file?

Accepted Answer

A)  .pdf 
B)  .wav 
C)  .mov 
D)  .bmp 
E)  .mpg 
A)  .pdf 
B)  .wav 
C)  .mov 
D)  .bmp 
E)  .mpg

Question 11

The company that digitized the Oxford English Dictionary is called

Accepted Answer

A)  IBM. 
B)  Nortel. 
C)  Microsoft. 
D)  OpenText. 
E)  Research In Motion. 
A)  IBM. 
B)  Nortel. 
C)  Microsoft. 
D)  OpenText. 
E)  Research In Motion.

Question 12

In a relational database application, a(n) ________ key is used to link one table with another.

Accepted Answer

A)  primary 
B)  index 
C)  secondary 
D)  foreign 
E)  composite 
A)  primary 
B)  index 
C)  secondary 
D)  foreign 
E)  composite

Question 13

A ________ is a column or group of columns that identifies a unique row in a table.

Accepted Answer

A)  record 
B)  relationship 
C)  row 
D)  key 
E)  field 
A)  record 
B)  relationship 
C)  row 
D)  key 
E)  field

Question 14

A DBMS is software that helps manage the operating system.

Accepted Answer

A) True 
 B)False

Question 15

In today's business world, content is just not about collection and distribution. It is also about

Accepted Answer

A)  the accuracy of the content. 
B)  the organization of the content. 
C)  the content management system. 
D)  the relevance of the content. 
E)  presenting the content appropriately for the audience. 
A)  the accuracy of the content. 
B)  the organization of the content. 
C)  the content management system. 
D)  the relevance of the content. 
E)  presenting the content appropriately for the audience.

Question 16

Which of the following is a file extension name of a video file?

Accepted Answer

A)  .wav 
B)  .mpg 
C)  .doc 
D)  .pdf 
E)  .bmp 
A)  .wav 
B)  .mpg 
C)  .doc 
D)  .pdf 
E)  .bmp

Question 17

A collection of records in a relational database can be called a

Accepted Answer

A)  matrix. 
B)  column. 
C)  field. 
D)  row. 
E)  relation. 
A)  matrix. 
B)  column. 
C)  field. 
D)  row. 
E)  relation.

Question 18

Describe the use of a content management system.

Accepted Answer

When an employee wants to place some con

Question 19

Special data called structured data describes the structure of the database.

Accepted Answer

A) True 
 B)False

Question 20

Columns are also called

Accepted Answer

A)  rows. 
B)  databases. 
C)  fields. 
D)  relations. 
E)  tables. 
A)  rows. 
B)  databases. 
C)  fields. 
D)  relations. 
E)  tables.

A spreadsheet is just another type of relational database.

A relational database refers to

The name of the field, the data type, and number of characters allowed are examples of

Modern content management systems

Many users prefer to avoid database applications altogether and simply store their data in a(n)

________ is an example of an enterprise DBMS.

The ________ problem is unique to a multi-user database environment.

Which of the following techniques is used to resolve the lost-update problem?

If a user stores their data in a spreadsheet, it is unavailable to other users unless it is stored in the company's ________.

Which of the following is a file extension name of an audio file?

The company that digitized the Oxford English Dictionary is called

In a relational database application, a(n) ________ key is used to link one table with another.

A ________ is a column or group of columns that identifies a unique row in a table.

A DBMS is software that helps manage the operating system.

In today's business world, content is just not about collection and distribution. It is also about

Which of the following is a file extension name of a video file?

A collection of records in a relational database can be called a

Describe the use of a content management system.

Special data called structured data describes the structure of the database.

Columns are also called

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Extension-Using Microsoft Access 2013

Extension-Database Design

Networks and Collaboration

Competitive Advantage and Business Processes

Decision Making and Business Intelligence

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters

Exam 7: Database and Content Management

A spreadsheet is just another type of relational database.

A relational database refers to

The name of the field, the data type, and number of characters allowed are examples of

Modern content management systems

Many users prefer to avoid database applications altogether and simply store their data in a(n)

________ is an example of an enterprise DBMS.

The ________ problem is unique to a multi-user database environment.

Which of the following techniques is used to resolve the lost-update problem?

If a user stores their data in a spreadsheet, it is unavailable to other users unless it is stored in the company's ________.

Which of the following is a file extension name of an audio file?

The company that digitized the Oxford English Dictionary is called

In a relational database application, a(n) ________ key is used to link one table with another.

A ________ is a column or group of columns that identifies a unique row in a table.

A DBMS is software that helps manage the operating system.

In today's business world, content is just not about collection and distribution. It is also about

Which of the following is a file extension name of a video file?

A collection of records in a relational database can be called a

Describe the use of a content management system.

Special data called structured data describes the structure of the database.

Columns are also called

Information Systems and You

Business Processes and Decision Making

Application Extension-Introduction to Business Process Modeling With Microsoft Visio

Productivity, Innovation, and Strategy

Application Extension-Introduction to Microsoft Excel 2013

Hardware and Software

Extension-Using Microsoft Access 2013

Extension-Database Design

Networks and Collaboration

Competitive Advantage and Business Processes

Decision Making and Business Intelligence

E-commerce, Social Networking, and Web 20

Acquiring Information Systems Through Projects

Application Extension-Introduction to Microsoft Project

Structure, Governance, and Ethics

Managing Information Security and Privacy

Filters