Vidyalelo
Database · all questions

Data and Database Administration
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

30

Questions

2/2

Page

Pick an option on a question to see the right answer and solution.

Information repositories are replacing data dictionaries in many organizations.

Select an option to see the answer and solution.

Mirrored databases are almost always provided in high-availability systems.

Select an option to see the answer and solution.

Databases are not the property of a single function or individual within the organization.

Select an option to see the answer and solution.

Queries that do full table scans should be avoided.

Select an option to see the answer and solution.

The restore/rerun technique involves reprocessing the day's transactions up to the point of failure.

Select an option to see the answer and solution.

Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.

Select an option to see the answer and solution.

A disaster recovery plan does not need to include the shipment of database backups to other sites.

Select an option to see the answer and solution.

With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.

Select an option to see the answer and solution.

Data modeling and database design are key responsibilities of data and data base administration.

Select an option to see the answer and solution.

Incorrect data is easy to detect.

Select an option to see the answer and solution.