Poor data administration can lead to which of the following?
Select an option to see the answer and solution.
Database · all questionsData and Database Administration
Data and Database Administration
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
30
Questions
1/2
Page
Pick an option on a question to see the right answer and solution.
A traditional data administrator performs which of the following roles?
Select an option to see the answer and solution.
If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Select an option to see the answer and solution.
Which of the following is part of an administrative policy to secure a database?
Select an option to see the answer and solution.
Backward recovery is which of the following?
Select an option to see the answer and solution.
The transaction log includes which of the following?
Select an option to see the answer and solution.
Which of the following could cause data to be unavailable?
Select an option to see the answer and solution.
A shared lock allows which of the following types of transactions to occur?
Select an option to see the answer and solution.
Locking may cause which of the following problems?
Select an option to see the answer and solution.
Performance analysis and tuning is which of the following?
Select an option to see the answer and solution.
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
Select an option to see the answer and solution.
Which of the following is true concerning open-source DBMS?
Select an option to see the answer and solution.
Concurrency control is important for which of the following reasons?
Select an option to see the answer and solution.
Which of the following is the preferred way to recover a database after a system failure?
Select an option to see the answer and solution.
A data warehouse administrator is concerned with which of the following?
Select an option to see the answer and solution.
To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.
Select an option to see the answer and solution.
Failure to control confidentiality may lead to loss of competitiveness.
Select an option to see the answer and solution.
Authorization tables contain highly sensitive data and should be protected by stringent security rules.
Select an option to see the answer and solution.
A transaction log shows before and after images of records that have been modified by transactions.
Select an option to see the answer and solution.
The greatest threat to business security is often internal rather than external.
Select an option to see the answer and solution.