CSE :: Database System 2 - CS
- Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
- Which of the following is true concerning open-source DBMS?
- Concurrency control is important for which of the following reasons?
- Which of the following is the preferred way to recover a database after a system failure?
- A data warehouse administrator is concerned with which of the following?
- To build a data warehouse and develop business intelligence applications, it is important that an organization build and maintain a comprehensive repository.
- Authorization tables contain highly sensitive data and should be protected by stringent security rules.
- A transaction log shows before and after images of records that have been modified by transactions.
A.
Is free or nearly free database software whose source code is publicly available |
B.
Is free or nearly free database software whose source code is not publicly available |
C.
Is not competitive against PC-oriented packages and is fully SQL compliant |
D.
Is competitive against PC-oriented packages and is not fully SQL compliant |
A.
To ensure data integrity when updates occur to the database in a multiuser environment |
B.
To ensure data integrity when updates occur to the database in a single-user environment |
C.
To ensure data integrity while reading data occurs to the database in a multiuser environment |
D.
To ensure data integrity while reading data occurs to the database in a single-user environment |
A.
The time to make a decision but not the typical roles of a database administrator |
B.
The time to make a decision and the typical roles of a database administrator |
C.
The typical roles of a data administrator and redesigning existing applications |
D.
The typical roles of a database administrator and redesigning existing applications |