Question 1

Only large database systems have a need for database administration.

Accepted Answer

A) True 
 B)False

Question 2

Microsoft Access 2013 uses a user-level security system.

Accepted Answer

A) True 
 B)False

Question 3

Explain the concept of an "atomic transaction."

Accepted Answer

An atomic transaction is a transaction i...

Question 4

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

Accepted Answer

Statement-level consistency requires tha...

Question 5

The term DBA refers to the:

Accepted Answer

A)   database accessor.
B)   database auditor.
C)   data business auditor.
D)   database administrator.
E)   data business administrator.

Question 6

Distinguish between reprocessing and rollforward as database recovery techniques.

Accepted Answer

Reprocessing and rollforward both requir...

Question 7

Concurrent processing of a database only poses problems when two or more processes attempt to use the same data.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

First,the actions of concurrent users mu...

Question 9

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

Accepted Answer

A)   Reprocessing makes use of a database save.
B)   Reprocessing takes the same amount of time as did processing in the first place.
C)   Reprocessing will always return the database to its exact previous state.
D)   Reprocessing requires a record of all transactions since the last time the database was saved.
E)   All of the above are true of reprocessing.

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

When Microsoft Access 2013 secures a database with just a password,the database file will be a(n) :

Accepted Answer

A)   *.accdb file.
B)   *.accdc file.
C)   *.accde file.
D)   *.mdb file.
E)   *.mdw file.

Question 12

Which type of lock assumes that no conflicts will occur?

Accepted Answer

A)   Optimistic locks
B)   Granular locks
C)   Explicit locks
D)   Shared locks
E)   Open locks

Question 13

Transaction results are kept in a(n)________,which contains records of the data changes in chronological order.

Accepted Answer

The answer of Transaction results are kept in a(n)________,which contains...

Question 14

Breaking hardware,power outages,and human mistakes are all reasons that ________.

Accepted Answer

The answer of Breaking hardware,power outages,and human mistakes are all...

Question 15

Statement level consistency means that all statements within a transaction will access consistent rows across the lifetime of the entire transaction.

Accepted Answer

A) True 
 B)False

Question 16

What are the four transaction isolation levels?

Accepted Answer

The four levels of isolation are Read Un...

Question 17

A point of synchronization between the database and the transaction log is called a(n) :

Accepted Answer

A)   before-image.
B)   after-image.
C)   recovery.
D)   checkpoint.
E)   None of the above

Question 18

A dirty read is a problem with concurrent processing when a transaction rereads data it has already read and finds modifications or deletions caused by another transaction.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)   Read Committed
B)   Serializable
C)   Read Uncommitted
D)   Atomic Read
E)   Repeatable Read

Question 20

The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as:

Accepted Answer

A)   reprocessing.
B)   rollback.
C)   transaction logging.
D)   rollforward.
E)   checkpointing.

Exam 6: Database Administration

The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The term DBA refers to the:

Correct AnswerverifiedShow Answer

Concurrent processing of a database only poses problems when two or more processes attempt to use the same data.

Correct AnswerverifiedShow Answer

Breaking hardware,power outages,and human mistakes are all reasons that ________.

Correct AnswerverifiedShow Answer

Microsoft Access 2013 uses a user-level security system.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Transaction results are kept in a(n)________,which contains records of the data changes in chronological order.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Distinguish between reprocessing and rollforward as database recovery techniques.

Correct AnswerverifiedReprocessing and rollforward both requir...View AnswerShow Answer

What are the four transaction isolation levels?

Correct AnswerverifiedThe four levels of isolation are Read Un...View AnswerShow Answer

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

Correct AnswerverifiedFirst,the actions of concurrent users mu...View AnswerShow Answer

A point of synchronization between the database and the transaction log is called a(n) :

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedStatement-level consistency requires tha...View AnswerShow Answer

Statement level consistency means that all statements within a transaction will access consistent rows across the lifetime of the entire transaction.

Correct AnswerverifiedShow Answer

When Microsoft Access 2013 secures a database with just a password,the database file will be a(n) :

Correct AnswerverifiedShow Answer

Which type of lock assumes that no conflicts will occur?

Correct AnswerverifiedShow Answer

Explain the concept of an "atomic transaction."

Correct AnswerverifiedAn atomic transaction is a transaction i...View AnswerShow Answer

Only large database systems have a need for database administration.

Correct AnswerverifiedShow Answer

A dirty read is a problem with concurrent processing when a transaction rereads data it has already read and finds modifications or deletions caused by another transaction.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Reprocessing and rollforward both requir...
View Answer

Correct Answer
verified
The four levels of isolation are Read Un...
View Answer

Correct Answer
verified
First,the actions of concurrent users mu...
View Answer

Correct Answer
verified

Correct Answer
verified
Statement-level consistency requires tha...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
An atomic transaction is a transaction i...
View Answer

Correct Answer
verified

Correct Answer
verified