Exam 6: Database Administration

Which of the following is true about a shared lock?

What are the four transaction isolation levels?

Distinguish between statement-level consistency and transaction-level consistency.

In terms of database security,a user can be assigned many roles,and a role can be assigned to many users.

What is the least restrictive isolation level that will prevent dirty reads?

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

What database administration functions help bring order to the potential chaos of the database processing environment?

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

An ACID transaction is one that is all but ________.

Explain the concept of an "atomic transaction."

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

Additional DBA responsibilities do not include ________.

What is the difference between authentication and authorization?

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

Explain the process of using optimistic locking.

Which of the following is not true of database recovery through reprocessing?

Discuss Microsoft Access 2016 security administration.

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

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

Transactions should be written to the log before they are applied to the database itself.