Discussion
Home ‣ Database ‣ Data and Database Administration Comments
- Question
If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
Options- A. Data modeling
- B. Database design
- C. Metadata
- D. All of the above.
- Correct Answer
- Database design
- 1. A shared lock allows which of the following types of transactions to occur?
Options- A. Delete
- B. Insert
- C. Read
- D. Update Discuss
- 2. Which of the following is true concerning open-source DBMS?
Options- A. Is free or nearly free database software whose source code is publicly available
- B. Is free or nearly free database software whose source code is not publicly available
- C. Is not competitive against PC-oriented packages and is fully SQL compliant
- D. Is competitive against PC-oriented packages and is not fully SQL compliant Discuss
- 3. Which of the following is the preferred way to recover a database after a system failure?
Options- A. Rollback
- B. Rollforward
- C. Switch to duplicate database
- D. Reprocess transactions Discuss
- 4. Concurrency control is important for which of the following reasons?
Options- A. To ensure data integrity when updates occur to the database in a multiuser environment
- B. To ensure data integrity when updates occur to the database in a single-user environment
- C. To ensure data integrity while reading data occurs to the database in a multiuser environment
- D. To ensure data integrity while reading data occurs to the database in a single-user environment Discuss
- 5. Performance analysis and tuning is which of the following?
Options- A. Undertaken one time at the time of a DBMS installation
- B. Undertaken one time at the time of the implementation of a new application
- C. Undertaken as an ongoing part of the backup of a database
- D. Undertaken as an ongoing part of managing a database Discuss
- 6. Locking may cause which of the following problems?
Options- A. Erroneous updates
- B. Deadlock
- C. Versioning
- D. All of the above. Discuss
- 7. 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
- 8. 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
- 9. 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
- 10. 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
Data and Database Administration problems
Search Results
Correct Answer: Read
Correct Answer: Is free or nearly free database software whose source code is publicly available
Correct Answer: Switch to duplicate database
Correct Answer: To ensure data integrity when updates occur to the database in a multiuser environment
Correct Answer: Undertaken as an ongoing part of managing a database
Correct Answer: Deadlock
Correct Answer: The time to make a decision and the typical roles of a database administrator
Correct Answer: Resolve data ownership issues
Correct Answer: Missing data elements
Correct Answer: The essential data of the record
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.