Question 1

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Accepted Answer

A)  Administrators 
B)  Developers 
C)  Users 
D)  Designers

Question 2

In an entity-relationship (E-R) diagram, an entity is represented by a triangle, and the relationships between entities are represented by dotted lines.

Accepted Answer

A) True 
 B)False

Question 3

Relational databases represent relationships using ________.

Accepted Answer

A)  foreign keys 
B)  file systems 
C)  metadata 
D)  primary keys

Question 4

A group of similar rows or records in a table is called a field.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is a nonrelational data store developed by Google?

Accepted Answer

A)  Cassandra 
B)  Dynamo 
C)  SharePoint 
D)  Bigtable

Question 6

Database applications must present data to the users in the same format as the database table.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A DBMS and database are synonymous terms that can be used interchangeably.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  Minimum candidate keys 
B)  Primary keys 
C)  Foreign keys 
D)  Minimum cardinalities

Question 10

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 11

Define primary key, foreign key, and metadata.

Accepted Answer

The answer of Define primary key, foreign key, and metadata....

Question 12

________ is the process of converting a poorly-structured table into two or more well-structured tables.

Accepted Answer

A)  Optimization 
B)  Normalization 
C)  Refactoring 
D)  Standardization

Question 13

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Accepted Answer

A) True 
 B)False

Question 14

Browser-based applications are more dynamic and better suited in today's world than older database applications.

Accepted Answer

A) True 
 B)False

Question 15

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

Accepted Answer

A)  report 
B)  data model 
C)  database administrative function 
D)  query

Question 16

The format of metadata depends on the software product that processes the database.

Accepted Answer

A) True 
 B)False

Question 17

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

Accepted Answer

A)  primary key 
B)  key attribute 
C)  foreign key 
D)  functionally dependent record

Question 18

What is a database application?

Accepted Answer

The answer of What is a database application?...

Question 19

Which of the following notations in an E-R diagram means that the entity is optional and a relationship need not have an entity of that type?

Accepted Answer

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

Question 20

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

Accepted Answer

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

Exam 5: Database Processing

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

In an entity-relationship (E-R) diagram, an entity is represented by a triangle, and the relationships between entities are represented by dotted lines.

Relational databases represent relationships using ________.

A group of similar rows or records in a table is called a field.

Which of the following is a nonrelational data store developed by Google?

Database applications must present data to the users in the same format as the database table.

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

A DBMS and database are synonymous terms that can be used interchangeably.

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

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

Define primary key, foreign key, and metadata.

________ is the process of converting a poorly-structured table into two or more well-structured tables.

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Browser-based applications are more dynamic and better suited in today's world than older database applications.

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

The format of metadata depends on the software product that processes the database.

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

What is a database application?

Which of the following notations in an E-R diagram means that the entity is optional and a relationship need not have an entity of that type?

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