Question 1

Each table in a database must have at least one foreign key.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following data elements is placed higher than records in the database hierarchy?

Accepted Answer

A)  file 
B)  field 
C)  character 
D)  byte 
E)  bit

Question 3

State the purposes of the four elements of a database application.

Accepted Answer

The answer of State the purposes of the four elements...

Question 4

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

Accepted Answer

A) True 
 B)False

Question 5

Describe a database and its elements.

Accepted Answer

The answer of Describe a database and its elements....

Question 6

Ryan, a database administrator, is in the process of designing his company's database. Which of the following would Ryan have had to create before he began designing?

Accepted Answer

A)  data aggregator 
B)  query model 
C)  data model 
D)  data application 
E)  data tunnel outlay

Question 7

A data model is a ________.

Accepted Answer

A)  logical representation of database data 
B)  repository of unprocessed data 
C)  collection of isolated databases 
D)  set of programs used to retrieve data 
E)  array of data variables

Question 8

Which of the following is used to process and display browser database application forms, reports, and queries?

Accepted Answer

A)  C++ 
B)  HTML 
C)  COBOL 
D)  VisualBasic 
E)  DB2

Question 9

For Falcon Security, the primary purpose of creating a database of video information is to ________.

Accepted Answer

A)  keep track of a single theme 
B)  eliminate concern about the lost update problem 
C)  enable querying based on video characteristics 
D)  avoid the use of spreadsheets 
E)  encrypt data streams

Question 10

Browser applications are thin-client applications that ________.

Accepted Answer

A)  use COBOL as the standard language for user-side processing 
B)  are processed using VisualBasic and C++ 
C)  need not be preinstalled on the users' computers 
D)  depend on internal networks and not the Internet to transmit data 
E)  do not need to be encrypted

Question 11

Which of the following is True of traditional database application programs?

Accepted Answer

A)  Application forms, reports, and queries are displayed and processed using a browser application. 
B)  The application logic is contained in a program on the client-side computer. 
C)  They are written in object-oriented languages such as C++ and VisualBasic. 
D)  They are thin-client applications that need not be preinstalled on the users' computers. 
E)  They are cloud-based applications that need not be preinstalled on the users' computers.

Question 12

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 
E)  triangle

Question 13

Define primary key, foreign key, and metadata.

Accepted Answer

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

Question 14

NoSQL DBMS refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

Accepted Answer

A) True 
 B)False

Question 15

Managing the impact of database structural changes on applications and users is an operational task for a database administrator.

Accepted Answer

A) True 
 B)False

Question 16

A user must have user account credentials to access and process a database.

Accepted Answer

A) True 
 B)False

Question 17

A database is used instead of a spreadsheet when ________.

Accepted Answer

A)  lists of data involve a single theme 
B)  structures of data lists are simple 
C)  lists involve data with multiple themes 
D)  users do not want to store all data in one place 
E)  users have a small amount of data to store

Question 18

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 19

What are traditional database applications?

Accepted Answer

The answer of What are traditional database applications?...

Question 20

What are the steps involved in transforming a data model into a relational database design?

Accepted Answer

The answer of What are the steps involved in transforming...

Exam 5: Database Processing

Each table in a database must have at least one foreign key.

Which of the following data elements is placed higher than records in the database hierarchy?

State the purposes of the four elements of a database application.

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

Describe a database and its elements.

Ryan, a database administrator, is in the process of designing his company's database. Which of the following would Ryan have had to create before he began designing?

A data model is a ________.

Which of the following is used to process and display browser database application forms, reports, and queries?

For Falcon Security, the primary purpose of creating a database of video information is to ________.

Browser applications are thin-client applications that ________.

Which of the following is True of traditional database application programs?

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?

Define primary key, foreign key, and metadata.

NoSQL DBMS refer to nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

Managing the impact of database structural changes on applications and users is an operational task for a database administrator.

A user must have user account credentials to access and process a database.

A database is used instead of a spreadsheet when ________.

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

What are traditional database applications?

What are the steps involved in transforming a data model into a relational database design?