IndiaBIX

Database - Data and Database Administration

Exercise : Data and Database Administration - General Questions
11.
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
Rollback
Rollforward
Switch to duplicate database
Reprocess transactions
Answer: Option
Explanation:
No answer description is available. Let's discuss.
12.
Which of the following is true concerning open-source DBMS?
Is free or nearly free database software whose source code is publicly available
Is free or nearly free database software whose source code is not publicly available
Is not competitive against PC-oriented packages and is fully SQL compliant
Is competitive against PC-oriented packages and is not fully SQL compliant
Answer: Option
Explanation:
No answer description is available. Let's discuss.
13.
Concurrency control is important for which of the following reasons?
To ensure data integrity when updates occur to the database in a multiuser environment
To ensure data integrity when updates occur to the database in a single-user environment
To ensure data integrity while reading data occurs to the database in a multiuser environment
To ensure data integrity while reading data occurs to the database in a single-user environment
Answer: Option
Explanation:
No answer description is available. Let's discuss.
14.
Which of the following is the preferred way to recover a database after a system failure?
Rollback
Rollforward
Switch to duplicate database
Reprocess transactions
Answer: Option
Explanation:
No answer description is available. Let's discuss.
15.
A data warehouse administrator is concerned with which of the following?
The time to make a decision but not the typical roles of a database administrator
The time to make a decision and the typical roles of a database administrator
The typical roles of a data administrator and redesigning existing applications
The typical roles of a database administrator and redesigning existing applications
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers