Question 1

Why will DBMS remain the industry standard for the foreseeable future?

Accepted Answer

The answer of Why will DBMS remain the industry standard...

Question 2

Every table in a normalized database has a ________.

Accepted Answer

A)  one-to-one relationship between entities 
B)  single theme 
C)  foreign key 
D)  specialized query format

Question 3

When the database contains inconsistent data,it leads to a(n)________.

Accepted Answer

A)  data integrity problem 
B)  crow's-foot paradigm 
C)  adaptation conflict 
D)  lost-update problem

Question 4

In a database,________ are grouped into columns that represent table attributes.

Accepted Answer

A)  fields 
B)  records 
C)  bytes 
D)  files

Question 5

Columns are also called records.

Accepted Answer

A) True 
 B)False

Question 6

NoSQL products guarantee that updates will be consistent or durable.

Accepted Answer

A) True 
 B)False

Question 7

Self-describing means that a database contains,within itself,a description of its contents.

Accepted Answer

A) True 
 B)False

Question 8

Attributes are used to describe characteristics of entities.

Accepted Answer

A) True 
 B)False

Question 9

What are database application programs?

Accepted Answer

The answer of What are database application programs?...

Question 10

A data integrity problem will occur only if ________.

Accepted Answer

A)  a database has multiple administrators 
B)  data are duplicated in a database 
C)  the database is very large 
D)  there are complex relationships between entities in a database

Question 11

Normalized tables are faster to process than tables that haven't been normalized.

Accepted Answer

A) True 
 B)False

Question 12

Changing a relationship from one-to-many to many-to-many in a functional database is simply a matter of changing the N:N notation to N:M.

Accepted Answer

A) True 
 B)False

Question 13

A(n)________ is a program used to create,process,and administer a database.

Accepted Answer

A)  operating system 
B)  DBMS 
C)  information system 
D)  data mart

Question 14

Which of the following is not true about NoSQL DBMSs?

Accepted Answer

A)  They are an emerging market. 
B)  They are the workhorse of the information systems industry today. 
C)  They require developer patience with sometimes-cumbersome user interfaces. 
D)  They are difficult to use.

Question 15

What is Metadata?
Metadata are data that describe data are always a part of a database.The presence of metadata makes databases much more useful.Because of metadata,no one needs to guess,remember,or even record what is in the database.To find out what a database contains,we just look at the metadata inside the database.

Accepted Answer

The answer of What is Metadata?
Metadata are data that describe...

Question 16

Enterprise DBMS products process large organizational and workgroup databases.

Accepted Answer

A) True 
 B)False

Question 17

Describe entities in the context of data models.

Accepted Answer

The answer of Describe entities in the context of data...

Question 18

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

Accepted Answer

A) True 
 B)False

Question 19

How does normalization resolve the data integrity problem?

Accepted Answer

The answer of How does normalization resolve the data integrity...

Question 20

In an E-R diagram,a(n)________ on a line means that at least one entity of that type is required.

Accepted Answer

A)  small oval 
B)  vertical bar 
C)  arrow 
D)  triangular block

Exam 4: Database Processing

Why will DBMS remain the industry standard for the foreseeable future?

Every table in a normalized database has a ________.

When the database contains inconsistent data,it leads to a(n) ________.

In a database,________ are grouped into columns that represent table attributes.

Columns are also called records.

NoSQL products guarantee that updates will be consistent or durable.

Self-describing means that a database contains,within itself,a description of its contents.

Attributes are used to describe characteristics of entities.

What are database application programs?

A data integrity problem will occur only if ________.

Normalized tables are faster to process than tables that haven't been normalized.

Changing a relationship from one-to-many to many-to-many in a functional database is simply a matter of changing the N:N notation to N:M.

A(n) ________ is a program used to create,process,and administer a database.

Which of the following is not true about NoSQL DBMSs?

Enterprise DBMS products process large organizational and workgroup databases.

Describe entities in the context of data models.

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

How does normalization resolve the data integrity problem?

In an E-R diagram,a(n) ________ on a line means that at least one entity of that type is required.