Question 1

Correct installation of the DBMS product is essential to any environment.

Accepted Answer

A) True 
 B)False  True

Question 2

A repository of information about a database that documents data elements of a database is called a:

Accepted Answer

A)  schema. 
B)  subschema. 
C)  view. 
D)  data dictionary. 
A)  schema. 
B)  subschema. 
C)  view. 
D)  data dictionary. D

Question 3

________ is a technical function responsible for database design, security, and disaster recovery.

Accepted Answer

A)  Data administration 
B)  Database administration 
C)  Tech support 
D)  Operations 
A)  Data administration 
B)  Database administration 
C)  Tech support 
D)  Operations B

Question 4

Examination and modification of the SQL code in an application may lead to performance improvements.

Accepted Answer

A) True 
 B)False

Question 5

Security measures for dynamic Web pages are different from static HTML pages because:

Accepted Answer

A)  dynamic Web pages are built "on the fly." 
B)  static Web pages contain more sensitive data. 
C)  the connection requires full access to the database for dynamic pages. 
D)  HTML is more complex than dynamic Web pages. 
A)  dynamic Web pages are built "on the fly." 
B)  static Web pages contain more sensitive data. 
C)  the connection requires full access to the database for dynamic pages. 
D)  HTML is more complex than dynamic Web pages.

Question 6

A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a:

Accepted Answer

A)  checkpoint facility. 
B)  backup facility. 
C)  recovery manager. 
D)  database change log. 
A)  checkpoint facility. 
B)  backup facility. 
C)  recovery manager. 
D)  database change log.

Question 7

A high-level function that is responsible for the overall management of data resources in an organization is called database administration.

Accepted Answer

A) True 
 B)False

Question 8

In order to perform a restore/rerun, the database must be mirrored.

Accepted Answer

A) True 
 B)False

Question 9

The preferred method of fixing an aborted transaction is:

Accepted Answer

A)  repairing the schema. 
B)  switching. 
C)  duplication of data. 
D)  backing out the transaction. 
A)  repairing the schema. 
B)  switching. 
C)  duplication of data. 
D)  backing out the transaction.

Question 10

What are some of the core roles of the traditional data administrator?

Accepted Answer

Some of the core roles for a data admini

Question 11

Databases are generally the property of a single department within an organization.

Accepted Answer

A) True 
 B)False

Question 12

Concurrent transactions need to be processed in isolation so that they do not interfere with each other.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following functions do cost/benefit models?

Accepted Answer

A)  Database planning 
B)  Database analysis 
C)  Database design 
D)  Operations 
A)  Database planning 
B)  Database analysis 
C)  Database design 
D)  Operations

Question 14

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.

Accepted Answer

A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  shared lock 
A)  record controller 
B)  exclusive lock 
C)  authorization rule 
D)  shared lock

Question 15

Which of the following is NOT true of poor data and/or database administration?

Accepted Answer

A)  Data timing problems 
B)  Multiple entity definitions 
C)  Unknown meanings of stored data 
D)  Maintaining a secure server 
A)  Data timing problems 
B)  Multiple entity definitions 
C)  Unknown meanings of stored data 
D)  Maintaining a secure server

Question 16

The data administrator takes responsibility for the overall management of data resources.

Accepted Answer

A) True 
 B)False

Question 17

What is backward and forward recovery?

Accepted Answer

Backward recovery, often called rollback

Question 18

Exclusive locks allow other transactions to read but not update a record or other resource.

Accepted Answer

A) True 
 B)False

Question 19

The first line of defense for authentication is the use of passwords, which is a one-factor authentication scheme.

Accepted Answer

A) True 
 B)False

Question 20

Controls incorporated into a data management system that restrict access to data are called authentication rules.

Accepted Answer

A) True 
 B)False

Correct installation of the DBMS product is essential to any environment.

A repository of information about a database that documents data elements of a database is called a:

________ is a technical function responsible for database design, security, and disaster recovery.

Examination and modification of the SQL code in an application may lead to performance improvements.

Security measures for dynamic Web pages are different from static HTML pages because:

A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a:

A high-level function that is responsible for the overall management of data resources in an organization is called database administration.

In order to perform a restore/rerun, the database must be mirrored.

The preferred method of fixing an aborted transaction is:

What are some of the core roles of the traditional data administrator?

Databases are generally the property of a single department within an organization.

Concurrent transactions need to be processed in isolation so that they do not interfere with each other.

Which of the following functions do cost/benefit models?

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.

Which of the following is NOT true of poor data and/or database administration?

The data administrator takes responsibility for the overall management of data resources.

What is backward and forward recovery?

Exclusive locks allow other transactions to read but not update a record or other resource.

The first line of defense for authentication is the use of passwords, which is a one-factor authentication scheme.

Controls incorporated into a data management system that restrict access to data are called authentication rules.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 12: Data and Database Administration

Correct installation of the DBMS product is essential to any environment.

A repository of information about a database that documents data elements of a database is called a:

________ is a technical function responsible for database design, security, and disaster recovery.

Examination and modification of the SQL code in an application may lead to performance improvements.

Security measures for dynamic Web pages are different from static HTML pages because:

A DBMS periodically suspends all processing and synchronizes its files and journals through the use of a:

A high-level function that is responsible for the overall management of data resources in an organization is called database administration.

In order to perform a restore/rerun, the database must be mirrored.

The preferred method of fixing an aborted transaction is:

What are some of the core roles of the traditional data administrator?

Databases are generally the property of a single department within an organization.

Concurrent transactions need to be processed in isolation so that they do not interfere with each other.

Which of the following functions do cost/benefit models?

A(n) ________ prevents another transaction from reading and therefore updating a record until it is unlocked.

Which of the following is NOT true of poor data and/or database administration?

The data administrator takes responsibility for the overall management of data resources.

What is backward and forward recovery?

Exclusive locks allow other transactions to read but not update a record or other resource.

The first line of defense for authentication is the use of passwords, which is a one-factor authentication scheme.

Controls incorporated into a data management system that restrict access to data are called authentication rules.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Distributed Databases

Object-Oriented Data Modeling

Filters