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

Q. Backward recovery is which of the following?

View solution

Q. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

View solution

Q. In database management system, the executing process or executing program which considers the updating or reading of records stored in database is called

View solution

Q. The application of database management system in air flight seat booking in a way that one seat is accessed by only one clerk for customer reservation is classified as

View solution