Discussion
Home ‣ Database ‣ Data and Database Administration Comments
- Question
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
- Correct Answer
- The essential data of the record
- 1. 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
- 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
- 3. 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
- 4. Locking may cause which of the following problems?
Options- A. Erroneous updates
- B. Deadlock
- C. Versioning
- D. All of the above. Discuss
- 5. 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. Discuss
- 6. 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
- 7. The term Complete for a UML has the same meaning as which of the following for an EER diagram?
Options- A. Overlapping rule
- B. Disjoint rule
- C. Total specialization rule
- D. Partial specialization rule Discuss
- 8. Multiplicity is the same as what concept for an ERD?
Options- A. Relationship
- B. Attribute
- C. Entity
- D. Cardinality Discuss
- 9. The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Options- A. Overlapping rule
- B. Disjoint rule
- C. Total specialization rule
- D. Partial specialization rule Discuss
- 10. The object-oriented development life cycle is which of the following?
Options- A. Analysis, design, and implementation steps in the given order and using multiple iterations.
- B. Analysis, design, and implementation steps in the given order and going through the steps no more than one time.
- C. Analysis, design, and implementation steps in any order and using multiple iterations.
- D. Analysis, design, and implementation steps in any order and going through the steps no more than one time. Discuss
Data and Database Administration problems
Search Results
Correct Answer: Missing data elements
Correct Answer: Resolve data ownership issues
Correct Answer: The time to make a decision and the typical roles of a database administrator
Correct Answer: Deadlock
Correct Answer: Database design
Correct Answer: Where the before-images are applied to the database
Correct Answer: Total specialization rule
Correct Answer: Cardinality
Correct Answer: Partial specialization rule
Correct Answer: Analysis, design, and implementation steps in the given order and using multiple iterations.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.