logo

CuriousTab

CuriousTab

Discussion


Home Database Data and Database Administration Comments

  • Question
  • 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.

  • Correct Answer
  • Resolve data ownership issues 


  • Data and Database Administration problems


    Search Results


    • 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
    • 2. Locking may cause which of the following problems?

    • Options
    • A. Erroneous updates
    • B. Deadlock
    • C. Versioning
    • D. All of the above.
    • Discuss
    • 3. 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
    • 4. A shared lock allows which of the following types of transactions to occur?

    • Options
    • A. Delete
    • B. Insert
    • C. Read
    • D. Update
    • Discuss
    • 5. 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
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. Multiplicity is the same as what concept for an ERD?

    • Options
    • A. Relationship
    • B. Attribute
    • C. Entity
    • D. Cardinality
    • Discuss


    Comments

    There are no comments.

Enter a new Comment