Data and Database Administration Questions

• Which of the following could cause data to be unavailable?
• Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
• Which of the following is part of an administrative policy to secure a database?
• Performance analysis and tuning is which of the following?
• Concurrency control is important for which of the following reasons?
• Which of the following is the preferred way to recover a database after a system failure?
• Which of the following is true concerning open-source DBMS?
• A shared lock allows which of the following types of transactions to occur?
• If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
• Locking may cause which of the following problems?
• A data warehouse administrator is concerned with which of the following?
• A traditional data administrator performs which of the following roles?
• Poor data administration can lead to which of the following?
• The transaction log includes which of the following?
• Backward recovery is which of the following?
• Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.
• Incorrect data is easy to detect.
• Databases are not the property of a single function or individual within the organization.
• With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.
• Information repositories are replacing data dictionaries in many organizations.