Question 1

In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

Accepted Answer

A) True 
 B)False

Question 2

The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.

Accepted Answer

A) True 
 B)False

Question 3

________ in an E-R diagram refer to the least number of entities required in a relationship.

Accepted Answer

A)  One-to-one relationships 
B)  Primary keys 
C)  Foreign keys 
D)  Minimum cardinalities

Question 4

In the case of single-user databases, the application, the DBMS, and the database all reside on the user's computer.

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

Metadata refers to entities of a database that users want to process.

Accepted Answer

A) True 
 B)False

Question 7

Identify the first step in transforming a data model into a relational database design.

Accepted Answer

A)  representing the data relationships 
B)  normalizing the data and files 
C)  creating foreign keys 
D)  creating a table for each entity

Question 8

In a database, when data items disagree with one another, it leads to a(n) ________.

Accepted Answer

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

Question 9

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

Accepted Answer

A)  database application 
B)  database design 
C)  data field 
D)  data model

Question 10

Each table in a database must have two or more primary keys.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is the smallest data element in a database?

Accepted Answer

A)  field 
B)  record 
C)  byte 
D)  file

Question 12

Each entity in a database has a unique attribute called a(n) ________.

Accepted Answer

A)  public key 
B)  identifier 
C)  foreign key 
D)  index field

Question 13

Entities in a data model have ________ that describe the characteristics of the entity.

Accepted Answer

A)  characters 
B)  primary keys 
C)  codes 
D)  attributes

Question 14

A database management system (DBMS) is a program used to create, process, and administer a database.

Accepted Answer

A) True 
 B)False

Question 15

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

Accepted Answer

A)  vertical bar 
B)  arrow 
C)  double line 
D)  small oval

Question 17

Which of the following is an example of a database management system?

Accepted Answer

A)  MS Excel 
B)  BigData 
C)  NoSQL 
D)  Access

Question 18

Constraints on the number of entities in a relationship are called ________ cardinalities.

Accepted Answer

A)  specific 
B)  minimum 
C)  primary 
D)  critical

Question 19

Which of the following is a developmental task of database administration?

Accepted Answer

A)  creating and staffing the DBA function 
B)  monitoring backup procedures 
C)  conducting training for users 
D)  managing configuration changes in systems

Question 20

A database is a self-describing collection of integrated records.

Accepted Answer

A) True 
 B)False

Exam 5: Database Processing

In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.

________ in an E-R diagram refer to the least number of entities required in a relationship.

In the case of single-user databases, the application, the DBMS, and the database all reside on the user's computer.

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

Metadata refers to entities of a database that users want to process.

Identify the first step in transforming a data model into a relational database design.

In a database, when data items disagree with one another, it leads to a(n) ________.

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

Each table in a database must have two or more primary keys.

Which of the following is the smallest data element in a database?

Each entity in a database has a unique attribute called a(n) ________.

Entities in a data model have ________ that describe the characteristics of the entity.

A database management system (DBMS) is a program used to create, process, and administer a database.

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type?

Which of the following is an example of a database management system?

Constraints on the number of entities in a relationship are called ________ cardinalities.

Which of the following is a developmental task of database administration?

A database is a self-describing collection of integrated records.