Exam 6: Database Administration

All actions in an atomic transaction are completed successfully or none of the actions are completed at all.

Ensuring that each SQL statement independently processes consistent rows is known as:

________ is an important business function whose purpose is to manage the database to maximize its value to the organization.

Which of the following is not a means of processing databases?

When Microsoft Access 2013 secures a database just by storing the database in a trusted location,the database file will be a(n):

Microsoft Access 2013 can secure database files by storing them in a(n)________.

Serializable transactions are created by having a(n)________ phase,in which locks are obtained,and a(n)________ phase,in which locks are released.

In comparison to reprocessing,rollforward does not involve the application programs.

The acronym DBA refers to either the office or the manager.

Microsoft Access 2013 can secure databases by deploying databases packaged with a(n)________.

What is the difference between authentication and authorization?

Two-phase locking can be used to ensure that transactions are serializable.

Whether a lock applies to data at the record level,page level,table level,or database level is referred to as:

The purpose of concurrency control is to ensure that one user's work does not inappropriately influence another user's work.

When a transaction functions in such a way that either all of the transaction actions are completed or none of them will be,the transaction is said to be:

Database administrators must make sure that ________ measures are in place and enforced so that only authorized users can take authorized actions at appropriate times.

The recovery method in which we undo the changes that erroneous or partially processed transactions have made in the database is called ________ recovery.

Why do computers fail?

When Microsoft Access 2013 compiles VBA code in a database,the resulting file is stored using a(n)________ file extension.

Standard SQL defines four ________,which specify which of the concurrency control problems are allowed to occur.