Data and Database Administration Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q1
Database- Data and Database Administration Poor data administration can lead to which of the following?
  • A A single definition of the same data entity
  • B Familiarity with existing data
  • C Missing data elements
  • D All of the above.
Answer: Option C
Q2
A traditional data administrator performs which of the following roles?
  • A Tune database performance
  • B Establish backup and recovery procedures
  • C Resolve data ownership issues
  • D Protect the security of the database.
Answer: Option C
Q3
If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
  • A Data modeling
  • B Database design
  • C Metadata
  • D All of the above.
Answer: Option B
Q4
Which of the following is part of an administrative policy to secure a database?
  • A Authentication policies
  • B Limiting particular areas within a building to only authorized people
  • C Ensure appropriate responses rates are in external maintenance agreements
  • D All of the above.
Answer: Option D
Q5
Backward recovery is which of the following?
  • 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
Answer: Option A
Q6
The transaction log includes which of the following?
  • 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
Answer: Option D
Q7
Which of the following could cause data to be unavailable?
  • A Data becoming lost or inaccurate
  • B The database server
  • C Planned database maintenance activities
  • D All of the above.
Answer: Option D
Q8
A shared lock allows which of the following types of transactions to occur?
  • A Delete
  • B Insert
  • C Read
  • D Update
Answer: Option C
Q9
Locking may cause which of the following problems?
  • A Erroneous updates
  • B Deadlock
  • C Versioning
  • D All of the above.
Answer: Option B
Q10
Performance analysis and tuning is which of the following?
  • 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
Answer: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test