Data and Database Administration problems
- 1. A data warehouse administrator is concerned with which of the following?
Options- A. The time to make a decision but not the typical roles of a database administrator
- B. The time to make a decision and the typical roles of a database administrator
- C. The typical roles of a data administrator and redesigning existing applications
- D. The typical roles of a database administrator and redesigning existing applications Discuss
Correct Answer: The time to make a decision and the typical roles of a database administrator
- 2. A traditional data administrator performs which of the following roles?
Options- A. Tune database performance
- B. Establish backup and recovery procedures
- C. Resolve data ownership issues
- D. Protect the security of the database. Discuss
Correct Answer: Resolve data ownership issues
- 3. Poor data administration can lead to which of the following?
Options- A. A single definition of the same data entity
- B. Familiarity with existing data
- C. Missing data elements
- D. All of the above. Discuss
Correct Answer: Missing data elements
- 4. The transaction log includes which of the following?
Options- A. The before-image of a record
- B. The after-image of a record
- C. The before and after-image of a record
- D. The essential data of the record Discuss
Correct Answer: The essential data of the record
- 5. Backward recovery is which of the following?
Options- A. Where the before-images are applied to the database
- B. Where the after-images are applied to the database
- C. Where the after-images and before-images are applied to the database
- D. Switching to an existing copy of the database Discuss
Correct Answer: Where the before-images are applied to the database
- 6. Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.
Options- A. True
- B. False Discuss
Correct Answer: True
- 7. Incorrect data is easy to detect.
Options- A. True
- B. False Discuss
Correct Answer: False
- 8. Databases are not the property of a single function or individual within the organization.
Options- A. True
- B. False Discuss
Correct Answer: True
- 9. With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.
Options- A. True
- B. False Discuss
Correct Answer: False
- 10. Information repositories are replacing data dictionaries in many organizations.
Options- A. True
- B. False Discuss
Correct Answer: True
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.