Data and Database Administration - General Questions Online Exam Quiz
Data and Database Administration - General Questions GK Quiz. Question and Answers related to Data and Database Administration - General Questions. MCQ (Multiple Choice Questions with answers about Data and Database Administration - General Questions
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.
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.
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.
Which of the following is part of an administrative policy to secure a database?
Options
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.
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
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
Which of the following could cause data to be unavailable?
Options
A : Data becoming lost or inaccurate
B : The database server
C : Planned database maintenance activities
D : All of the above.
A shared lock allows which of the following types of transactions to occur?
Options
A : Delete
B : Insert
C : Read
D : Update
Locking may cause which of the following problems?
Options
A : Erroneous updates
B : Deadlock
C : Versioning
D : All of the above.
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
Advanced SQL - General Questions more Online Exam Quiz
Polymorphism - General Questions
Properties - General Questions
Structures - General Questions
Advanced SQL - General Questions
Database Design Using Normalization - General Questions
Database Processing for BIS - General Questions
Database Redesign - General Questions