Exercise: Data And Database Administration

Questions for: Data And Database Administration

Performance analysis and tuning is which of the following?
A:
Undertaken one time at the time of a DBMS installation
B:
Undertaken one time at the time of the implementation of a new application
C:
Undertaken as an ongoing part of the backup of a database
D:
Undertaken as an ongoing part of managing a database
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Locking may cause which of the following problems?
A:
Erroneous updates
B:
Deadlock
C:
Versioning
D:
All of the above.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
A shared lock allows which of the following types of transactions to occur?
A:
Delete
B:
Insert
C:
Read
D:
Update
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following could cause data to be unavailable?
A:
Data becoming lost or inaccurate
B:
The database server
C:
Planned database maintenance activities
D:
All of the above.
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
The transaction log includes which of the following?
A:
The before-image of a record
B:
The after-image of a record
C:
The before and after-image of a record
D:
The essential data of the record
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz