Question 1

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs) ?

Accepted Answer

A)   A voice mail system is an example of a groupware database.
B)   An object is an item that contains data, as well as the actions that read or process the data.
C)   An OODB stores unstructured data more efficiently than a relational database.
D)   OODBs can store more types of data and access it faster than relational databases.E) A) and B)
F) C) and D)

Question 2

The data modeler creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures.

Accepted Answer

A) True 
 B)False

Question 3

What is a data type? List the data types commonly found in a database.

Accepted Answer

Student responses will vary, but should ...

Question 4

COGNITIVE ASSESSMENT What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

Accepted Answer

A)   query
B)   verification
C)   procedure
D)   validationE) B) and C)
F) A) and B)

Question 5

A(n) ____________________ verifies that a required field contains data.

Accepted Answer

The answer of A(n) ____________________ verifies that a required field...

Question 6

Some report generators allow you to create a webpage, which can be interactive.

Accepted Answer

A) True 
 B)False

Question 7

A database eliminates redundant data.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Accepted Answer

A)   back end
B)   RDBMS
C)   SQL
D)   front endE) B) and D)
F) All of the above

Question 9

Which of the following is true in a relational database?

Accepted Answer

A)   Each row and each column has a primary key.
B)   Each row has a unique name and each column has a primary key.
C)   Each row has a primary key and each column has a unique name.
D)   Each row and each column has a unique name.E) B) and C)
F) A) and C)

Question 10

COGNITIVE ASSESSMENT Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

Accepted Answer

A)   data mine
B)   data archive
C)   data market
D)   data warehouseE) None of the above
F) All of the above

Question 11

____________________ information has meaning to the person who receives it.

Accepted Answer

The answer of ____________________ information has meaning to the person...

Question 12

Which of the following is an advantage of a multidimensional database?

Accepted Answer

A)   There is a common query language.
B)   The content of all dimensions is the same regardless of the subject.
C)   It can consolidate data much faster than a relational database.
D)   All multidimensional databases have a dimension of time.E) B) and C)
F) A) and D)

Question 13

Which of the following is a process designed to ensure the data within the relations (tables)  contains the least amount of duplication?

Accepted Answer

A)   concatenation
B)   rasterization
C)   dithering
D)   normalizationE) B) and C)
F) All of the above

Question 14

When a(n) ____________________ no longer is needed, a user deletes it from a file.

Accepted Answer

The answer of When a(n) ____________________ no longer is needed,...

Question 15

Each higher level of data consists of one or more items from the lower level.

Accepted Answer

A) True 
 B)False

Question 16

A user of a database such as that pictured in the accompanying figure refers to a record as what?

Accepted Answer

A)   table
B)   column
C)   row
D)   relationshipE) C) and D)
F) B) and C)

Question 17

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

Accepted Answer

A)   a window on the screen that provides areas for entering or modifying data in a database
B)   a formatted, printable retrieval of specific data
C)   a screen that enables a database user to add or delete tables
D)   the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve dataE) A) and B)
F) A) and C)

Question 18

____________________ is a common data type that consists of lengthy text entries.

Accepted Answer

The answer of ____________________ is a common data type that...

Question 19

Materials Requirements Planning controls production equipment, such as drills, lathes, and milling machines.

Accepted Answer

A) True 
 B)False

Question 20

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

Accepted Answer

A)   The number of dimensions in a multidimensional database varies.
B)   Most multidimensional databases use a standard query language.
C)   Nearly every multidimensional database has a dimension of time.
D)   A multidimensional database can consolidate data much faster than a relational database.E) C) and D)
F) B) and D)

Exam 11: Information and Data Management

COGNITIVE ASSESSMENT Which term describes a huge database that stores and manages data required to analyze historical and current transactions?

Correct AnswerverifiedShow Answer

COGNITIVE ASSESSMENT What is the term for the process of comparing data with a set of rules or values to find out if the data is correct?

Correct AnswerverifiedShow Answer

A database eliminates redundant data.

Correct AnswerverifiedShow Answer

____________________ is a common data type that consists of lengthy text entries.

Correct AnswerverifiedShow Answer

COGNITIVE ASSESSMENT Which of the following statements is not true about object-oriented databases (OODBs) ?

Correct AnswerverifiedShow Answer

The data modeler creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures.

Correct AnswerverifiedShow Answer

Which of the following is a program with which users interact that generally has a more user-friendly interface than a DBMS?

Correct AnswerverifiedShow Answer

COGNITIVE ASSESSMENT Which of the following statements is not true about multidimensional databases?

Correct AnswerverifiedShow Answer

What is a data type? List the data types commonly found in a database.

Correct AnswerverifiedStudent responses will vary, but should ...View AnswerShow Answer

Which of the following is a process designed to ensure the data within the relations (tables) contains the least amount of duplication?

Correct AnswerverifiedShow Answer

Each higher level of data consists of one or more items from the lower level.

Correct AnswerverifiedShow Answer

____________________ information has meaning to the person who receives it.

Correct AnswerverifiedShow Answer

Which of the following is an advantage of a multidimensional database?

Correct AnswerverifiedShow Answer

A(n) ____________________ verifies that a required field contains data.

Correct AnswerverifiedShow Answer

When a(n) ____________________ no longer is needed, a user deletes it from a file.

Correct AnswerverifiedShow Answer

Which of the following is true in a relational database?

Correct AnswerverifiedShow Answer

A user of a database such as that pictured in the accompanying figure refers to a record as what?

Correct AnswerverifiedShow Answer

Some report generators allow you to create a webpage, which can be interactive.

Correct AnswerverifiedShow Answer

Materials Requirements Planning controls production equipment, such as drills, lathes, and milling machines.

Correct AnswerverifiedShow Answer

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Student responses will vary, but should ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified