Question 1

What factors should one consider when choosing an open source DBMS?

Accepted Answer

There are several factors to consider wh

Question 2

Which of the following characteristics is required of a data administration manager?

Accepted Answer

A)  Good people skills 
B)  Sufficient technical skills 
C)  Ability to sell users on ideas 
D)  All of the above 
A)  Good people skills 
B)  Sufficient technical skills 
C)  Ability to sell users on ideas 
D)  All of the above

Question 3

A trigger can be used for security purposes to prohibit inappropriate actions,such as changing a salary value outside of a business day.

Accepted Answer

A) True 
 B)False

Question 4

An audit trail of transactions and database changes is kept by a ________.

Accepted Answer

journalizi

Question 5

Two-phase locking results in a growing phase where locks are acquired and a shrinking phase where locks are released.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

What are some of the core roles of a database administrator?

Accepted Answer

Some of the core roles of a database adm

Question 8

A database management system needs to provide only three basic facilities for backup and recovery of a database: backup facilities,journalizing facilities,and a recovery manager.

Accepted Answer

A) True 
 B)False

Question 9

The ________ occurs when one user reads data that have been partially updated by another user.

Accepted Answer

inconsiste

Question 10

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

Accepted Answer

The answer of ________ locks allow other transactions to read...

Question 11

An optimistic approach to concurrency control is called:

Accepted Answer

A)  versioning. 
B)  denormalization. 
C)  deadlock resolution. 
D)  none of the above. 
A)  versioning. 
B)  denormalization. 
C)  deadlock resolution. 
D)  none of the above.

Question 12

A typical cause of database destruction is a disk crash.

Accepted Answer

A) True 
 B)False

Question 13

An organization should have one data warehouse administrator for every:

Accepted Answer

A)  100 users. 
B)  100 gigabytes of data in the enterprise data warehouse. 
C)  department. 
D)  processor. 
A)  100 users. 
B)  100 gigabytes of data in the enterprise data warehouse. 
C)  department. 
D)  processor.

Question 14

A ________ measures or detects personal characteristics such as fingerprints.

Accepted Answer

The answer of A ________ measures or detects personal characteristics...

Question 15

The repository information model defines types,which should be easy to extend.

Accepted Answer

A) True 
 B)False

Question 16

________ 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

Question 17

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)  all of the above. 
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)  all of the above.

Question 18

Versioning takes the pessimistic approach to locking.

Accepted Answer

A) True 
 B)False

Question 19

A(n)________ is submitted by a DBA to test the current performance of a database or predict the response time for queries.

Accepted Answer

A)  Elusive query 
B)  Performance test 
C)  Heartbeat query 
D)  None of the above 
A)  Elusive query 
B)  Performance test 
C)  Heartbeat query 
D)  None of the above

Question 20

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.

What factors should one consider when choosing an open source DBMS?

Which of the following characteristics is required of a data administration manager?

A trigger can be used for security purposes to prohibit inappropriate actions,such as changing a salary value outside of a business day.

An audit trail of transactions and database changes is kept by a ________.

Two-phase locking results in a growing phase where locks are acquired and a shrinking phase where locks are released.

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

What are some of the core roles of a database administrator?

A database management system needs to provide only three basic facilities for backup and recovery of a database: backup facilities,journalizing facilities,and a recovery manager.

The ________ occurs when one user reads data that have been partially updated by another user.

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

An optimistic approach to concurrency control is called:

A typical cause of database destruction is a disk crash.

An organization should have one data warehouse administrator for every:

A ________ measures or detects personal characteristics such as fingerprints.

The repository information model defines types,which should be easy to extend.

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

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

Versioning takes the pessimistic approach to locking.

A(n)________ is submitted by a DBA to test the current performance of a database or predict the response time for queries.

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

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

What factors should one consider when choosing an open source DBMS?

Which of the following characteristics is required of a data administration manager?

A trigger can be used for security purposes to prohibit inappropriate actions,such as changing a salary value outside of a business day.

An audit trail of transactions and database changes is kept by a ________.

Two-phase locking results in a growing phase where locks are acquired and a shrinking phase where locks are released.

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

What are some of the core roles of a database administrator?

A database management system needs to provide only three basic facilities for backup and recovery of a database: backup facilities,journalizing facilities,and a recovery manager.

The ________ occurs when one user reads data that have been partially updated by another user.

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

An optimistic approach to concurrency control is called:

A typical cause of database destruction is a disk crash.

An organization should have one data warehouse administrator for every:

A ________ measures or detects personal characteristics such as fingerprints.

The repository information model defines types,which should be easy to extend.

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

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

Versioning takes the pessimistic approach to locking.

A(n)________ is submitted by a DBA to test the current performance of a database or predict the response time for queries.

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

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