An exclusive lock locks the item from change but not from read. True False TRUE ANSWER : ? YOUR ANSWER : ?
The overall responsibility of the DBA is to facilitate the development and use of the database. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following locks the item from access of any type? Implicit lock Explicit lock Exclusive lock Shared lock TRUE ANSWER : ? YOUR ANSWER : ?
Locks placed by command are called ________ . exclusive locks shared locks explicit locks implicit locks TRUE ANSWER : ? YOUR ANSWER : ?
A point of synchronization between the database and the transaction log is generally referred to as a stop point. True False TRUE ANSWER : ? YOUR ANSWER : ?
An ACID transaction is one that is atomic, consistent isolated, and durable. True False TRUE ANSWER : ? YOUR ANSWER : ?
A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all. True False TRUE ANSWER : ? YOUR ANSWER : ?
What is the overall responsibility of the DBA? Facilitate the development and use of the database Create and populate tables Development, operation, and maintenance of the database and its applications Both the first and third answers above are correct. TRUE ANSWER : ? YOUR ANSWER : ?
Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions. False True TRUE ANSWER : ? YOUR ANSWER : ?