Exercise: Data And Database Administration

Questions for: Data And Database Administration

A data warehouse administrator is concerned with which of the following?
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
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is the preferred way to recover a database after a system failure?
A:
Rollback
B:
Rollforward
C:
Switch to duplicate database
D:
Reprocess transactions
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Concurrency control is important for which of the following reasons?
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
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is true concerning open-source DBMS?
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
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
A:
Rollback
B:
Rollforward
C:
Switch to duplicate database
D:
Reprocess transactions
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz