Q. Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

View solution

Q. A transaction for which all committed changes are permanent is called:

View solution

Q. In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

View solution

Q. Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

View solution

Q. A transaction may not always complete its execution successfully. Such a transaction is termed

View solution

Q. Transaction processing is associated with everything below except

View solution

Q. Transaction management ensures ____________ and __________ properties.

View solution

Q. ____________ is an interface between low level database and application program.

View solution

Q. Which of the following are functions of Database Manager ?

1. Interacting with File Manager
2. Creating Queries to Access data
3. Security Enforcement
4. Database Definition and Schema Generation

View solution

Q. Who detects the failure of the system and restore the database to consistent state ?

View solution

Q. A traditional data administrator performs which of the following roles?

View solution

Q. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

View solution

Q. Which of the following is the preferred way to recover a database after a system failure?

View solution

Q. Concurrency control is important for which of the following reasons?

View solution

Q. A shared lock allows which of the following types of transactions to occur?

View solution

Q. Locking may cause which of the following problems?

View solution

Q. Performance analysis and tuning is which of the following?

View solution

Q. Which of the following could cause data to be unavailable?

View solution

Q. The transaction log includes which of the following?

View solution

Q. Which of the following is part of an administrative policy to secure a database?

View solution