Data and Database Administration MCQs

30 questionsDatabasePage 3 of 4

Practice free Data and Database Administration multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 30 questions — no login required.

Question 19hard
A transaction log shows before and after images of records that have been modified by transactions.
⚑ Report✎ Feedback
Question 20medium
The greatest threat to business security is often internal rather than external.
⚑ Report✎ Feedback
Question 21medium
Information repositories are replacing data dictionaries in many organizations.
⚑ Report✎ Feedback
Advertisement
Question 22medium
Mirrored databases are almost always provided in high-availability systems.
⚑ Report✎ Feedback
Question 23hard
Databases are not the property of a single function or individual within the organization.
⚑ Report✎ Feedback
Question 24medium
Queries that do full table scans should be avoided.
⚑ Report✎ Feedback
Advertisement
Question 25hard
The restore/rerun technique involves reprocessing the day's transactions up to the point of failure.
⚑ Report✎ Feedback
Question 26hard
Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.
⚑ Report✎ Feedback
Question 27hard
A disaster recovery plan does not need to include the shipment of database backups to other sites.
⚑ Report✎ Feedback
1234