Question 1

Which of the following is 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)  All of the above 
A)  Data timing problems 
B)  Multiple entity definitions 
C)  Unknown meanings of stored data 
D)  All of the above

Question 2

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

Accepted Answer

Some of the core roles for a data admini

Question 3

The ________ allows the DBMS to restore the database to a correct condition and restart processing transactions.

Accepted Answer

The answer of The ________ allows the DBMS to restore...

Question 4

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

Accepted Answer

A)  backup facility 
B)  recovery manager 
C)  restart facility 
D)  transaction logger 
A)  backup facility 
B)  recovery manager 
C)  restart facility 
D)  transaction logger

Question 5

A discrete unit of work that must be processed completely or not at all within a computer system is called a:

Accepted Answer

A)  change control device. 
B)  transaction. 
C)  before image. 
D)  journalizing facility. 
A)  change control device. 
B)  transaction. 
C)  before image. 
D)  journalizing facility.

Question 6

Which of the following functions develop integrity controls?

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A deadlock results when two transactions try to read the same record.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is a principal type of authorization table?

Accepted Answer

A)  Subject 
B)  Transaction 
C)  View 
D)  Index 
A)  Subject 
B)  Transaction 
C)  View 
D)  Index

Question 10

The role of database administration is typically a more hands-on,physical involvement with the management of databases.

Accepted Answer

A) True 
 B)False

Question 11

An information repository supplies information to:

Accepted Answer

A)  users. 
B)  automated CASE tools. 
C)  database management systems. 
D)  all of the above. 
A)  users. 
B)  automated CASE tools. 
C)  database management systems. 
D)  all of the above.

Question 12

The phases of the two-phase locking protocol are referred to as the ________ phase and the ________ phase.

Accepted Answer

The answer of The phases of the two-phase locking protocol...

Question 13

What is the difference between shared locks and exclusive locks?

Accepted Answer

Shared locks allow other transactions to

Question 14

Open-source software always comes with complete documentation.

Accepted Answer

A) True 
 B)False

Question 15

A transaction that terminates abnormally is called a(n)________ transaction.

Accepted Answer

The answer of A transaction that terminates abnormally is called...

Question 16

The ________ technique involves reprocessing the day's transactions against the backup copy of the database.

Accepted Answer

The answer of The ________ technique involves reprocessing the day's...

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

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

The ________ allows the DBMS to restore the database to a correct condition and restart processing transactions.

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

A discrete unit of work that must be processed completely or not at all within a computer system is called a:

Which of the following functions develop integrity controls?

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

A deadlock results when two transactions try to read the same record.

Which of the following is a principal type of authorization table?

The role of database administration is typically a more hands-on,physical involvement with the management of databases.

An information repository supplies information to:

The phases of the two-phase locking protocol are referred to as the phase and the phase.

What is the difference between shared locks and exclusive locks?

Open-source software always comes with complete documentation.

A transaction that terminates abnormally is called a(n)________ transaction.

The ________ technique involves reprocessing the day's transactions against the backup copy of the database.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

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

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 11: Data and Database Administration

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

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

The ________ allows the DBMS to restore the database to a correct condition and restart processing transactions.

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

A discrete unit of work that must be processed completely or not at all within a computer system is called a:

Which of the following functions develop integrity controls?

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

A deadlock results when two transactions try to read the same record.

Which of the following is a principal type of authorization table?

The role of database administration is typically a more hands-on,physical involvement with the management of databases.

An information repository supplies information to:

The phases of the two-phase locking protocol are referred to as the ________ phase and the ________ phase.

What is the difference between shared locks and exclusive locks?

Open-source software always comes with complete documentation.

A transaction that terminates abnormally is called a(n)________ transaction.

The ________ technique involves reprocessing the day's transactions against the backup copy of the database.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

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

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

The phases of the two-phase locking protocol are referred to as the phase and the phase.