Question 1

________ refers to data collections that are characterized by huge volume, rapid velocity, and great variety.

Accepted Answer

A)  BigData 
B)  NoSQL 
C)  Dynamo 
D)  Hadoop

Question 2

Browser-based applications ________.

Accepted Answer

A)  need to be pre installed on the users' computers 
B)  run within a corporate network that is protected from the Internet 
C)  eliminate the need to check for data consistency 
D)  are more vulnerable to security threats than are traditional applications

Question 3

A ________ describes the data and relationships that will be stored in a database.

Accepted Answer

A)  data aggregator 
B)  query model 
C)  data model 
D)  data application

Question 4

A database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

Accepted Answer

A)  development 
B)  recovery 
C)  adaptation 
D)  operational

Question 5

Explain the role of users in the database development process.

Accepted Answer

The answer of Explain the role of users in the...

Question 6

A group of similar rows or records is known as ________.

Accepted Answer

A)  a prototype 
B)  a file 
C)  a field 
D)  an attribute

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

In a database, ________ are grouped into columns.

Accepted Answer

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

Question 10

Browser database application forms, reports, and queries are displayed and processed using html5, css3, and JavaScript.

Accepted Answer

A) True 
 B)False

Question 11

How does normalization resolve the data integrity problem?

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The forked lines on the lines representing relationship between two related entities are referred to as ________.

Accepted Answer

A)  identifiers 
B)  foreign keys 
C)  crow's feet 
D)  entities

Question 14

A database is best described as a collection of unrelated tables.

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

In an E-R diagram, a line between two entities represents a(n) ________.

Accepted Answer

A)  attribute 
B)  identifier 
C)  cardinality 
D)  relationship

Question 17

Columns that are keys to different tables than the ones in which they reside are called ________.

Accepted Answer

A)  attributes 
B)  foreign keys 
C)  primary keys 
D)  internal records

Question 18

Creating a system to record and manage the resolution of problems is the development task of a database administrator.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

Accepted Answer

A)  lost-update problem 
B)  crow's-foot paradigm 
C)  bullwhip effect 
D)  update query problem

Question 20

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

Accepted Answer

A)  evaluating an application design 
B)  monitoring backup procedures 
C)  conducting training for users 
D)  managing configuration changes in systems

Exam 5: Database Processing

________ refers to data collections that are characterized by huge volume, rapid velocity, and great variety.

Browser-based applications ________.

A ________ describes the data and relationships that will be stored in a database.

A database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

Explain the role of users in the database development process.

A group of similar rows or records is known as ________.

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

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

In a database, ________ are grouped into columns.

Browser database application forms, reports, and queries are displayed and processed using html5, css3, and JavaScript.

How does normalization resolve the data integrity problem?

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

The forked lines on the lines representing relationship between two related entities are referred to as ________.

A database is best described as a collection of unrelated tables.

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

In an E-R diagram, a line between two entities represents a(n) ________.

Columns that are keys to different tables than the ones in which they reside are called ________.

Creating a system to record and manage the resolution of problems is the development task of a database administrator.

Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

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