Data And Database Administration MCQs with Explanations

Missing data elements is the correct answer to “Poor data administration can lead to which of the following”. This question is standard in competitive examination syllabi for Data And Database Administration.

Resolve data ownership issues is the correct answer to “A traditional data administrator performs which of the following roles”. This question is standard in competitive examination syllabi for Data And Database Administration.

Database design is the correct answer to “If both data and database administration exist in an organization, the database administrator is responsible for which of the following”. This question is standard in competitive examination syllabi for Data And Database Administration.

All of the above is the correct answer to “Which of the following is part of an administrative policy to secure a database”. This question is standard in competitive examination syllabi for Data And Database Administration.

Where the before-images are applied to the database is the correct answer to “Backward recovery is which of the following”. This question is standard in competitive examination syllabi for Data And Database Administration.

The essential data of the record is the correct answer to “The transaction log includes which of the following”. This question is standard in competitive examination syllabi for Data And Database Administration.

All of the above is the correct answer to “Which of the following could cause data to be unavailable”. This question is standard in competitive examination syllabi for Data And Database Administration.

Read is the correct answer to “A shared lock allows which of the following types of transactions to occur”. This question is standard in competitive examination syllabi for Data And Database Administration.

Deadlock is the correct answer to “Locking may cause which of the following problems”. This question is standard in competitive examination syllabi for Data And Database Administration.

Undertaken as an ongoing part of managing a database is the correct answer to “Performance analysis and tuning is which of the following”. This question is standard in competitive examination syllabi for Data And Database Administration.

Rollback is the correct answer to “Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally”. This question is standard in competitive examination syllabi for Data And Database Administration.

Is free or nearly free database software whose source code is publicly available is the correct answer to “Which of the following is true concerning open-source DBMS”. This question is standard in competitive examination syllabi for Data And Database Administration.

To ensure data integrity when updates occur to the database in a multiuser environment is the correct answer to “Concurrency control is important for which of the following reasons”. This question is standard in competitive examination syllabi for Data And Database Administration.

Switch to duplicate database is the correct answer to “Which of the following is the preferred way to recover a database after a system failure”. This question is standard in competitive examination syllabi for Data And Database Administration.

The time to make a decision and the typical roles of a database administrator is the correct answer to “A data warehouse administrator is concerned with which of the following”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “Failure to control confidentiality may lead to loss of competitiveness.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “Authorization tables contain highly sensitive data and should be protected by stringent security rules.”. This question is standard in competitive examination syllabi for Data And Database Administration.

False is the correct answer to “A transaction log shows before and after images of records that have been modified by transactions.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “The greatest threat to business security is often internal rather than external.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “Information repositories are replacing data dictionaries in many organizations.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “Mirrored databases are almost always provided in high-availability systems.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “Databases are not the property of a single function or individual within the organization.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “Queries that do full table scans should be avoided.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “The restore/rerun technique involves reprocessing the day's transactions up to the point of failure.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.”. This question is standard in competitive examination syllabi for Data And Database Administration.

False is the correct answer to “A disaster recovery plan does not need to include the shipment of database backups to other sites.”. This question is standard in competitive examination syllabi for Data And Database Administration.

False is the correct answer to “With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.”. This question is standard in competitive examination syllabi for Data And Database Administration.

True is the correct answer to “Data modeling and database design are key responsibilities of data and data base administration.”. This question is standard in competitive examination syllabi for Data And Database Administration.

False is the correct answer to “Incorrect data is easy to detect.”. This question is standard in competitive examination syllabi for Data And Database Administration.