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

Q. If both data and database administration exist in an organization, the database administrator is responsible for which of the following?

View solution

Q. Which of the following is true concerning open-source DBMS?

View solution

Q. A data warehouse administrator is concerned with which of the following?

View solution

Q. Poor data administration can lead to which of the following?

View solution