Managing Multiuser Databases Questions and Answers

Q: Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

Correct answer: Phantom readA phantom read is the appearance of new rows that were not there on the earlier read, inserted and committed by another transaction in the interval. It is distinct from a nonrepeatable read, where rows already seen have changed or gone. Only the serializable isolation level prevents phantoms.

Q: The size of the lock is referred to as the lock granularity.

Correct answer: TrueLock granularity is the size of the item locked, from a single row up to the whole database. Fine granularity allows more transactions to proceed at once but requires far more locks to be held and checked; coarse granularity is cheap to administer but blocks transactions that would not really have conflicted.

Q: When two transactions are being processed against the database at the same time they are termed concurrent transactions.

Correct answer: TrueTransactions are concurrent when their execution overlaps in time, whether or not they touch the same data. The whole apparatus of locking and isolation levels exists to make concurrent transactions behave as though they had run one after another, which is what serializability means.

Q: Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

Correct answer: Dirty readA dirty read is reading data that another transaction has changed but not yet committed. If that transaction subsequently rolls back, the value read never existed in the database at all, and any decision taken on it is unfounded. Only the read uncommitted isolation level permits it.

Q: A transaction for which all committed changes are permanent is called:

Correct answer: durableDurability means that once a transaction has committed, its changes are permanent and survive any subsequent failure. It is achieved by writing to a log on stable storage before the commit is acknowledged.

Q: A cursor type in which the application can only move forward through the recordset is called:

Correct answer: forward only.A forward-only cursor can move through the recordset in one direction and cannot return to a row it has passed. It is the cheapest kind, since nothing needs to be retained behind the current position, and it is the right choice whenever the application simply processes each row once.

Q: A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

Correct answer: FalseWhat is described is a nonrepeatable read: rows already seen have been modified or deleted by a committed transaction. A phantom read is the appearance of new rows that were not there before. The distinction decides which isolation level is needed, since repeatable read prevents the first but not the second.

Q: In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

Correct answer: Read committedRead committed guarantees only that data read has been committed by someone, so dirty reads are impossible. It takes no long-term read locks, so a row may change between two reads within the same transaction - a non-repeatable read - and new rows may appear, a phantom. It is the default level in most systems, as a compromise between correctness and concurrency.

Q: 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.

Correct answer: TrueThis is the definition of a transaction and it is the atomicity property stated in full. The series of actions is treated as a single indivisible unit, so a transfer between two accounts either debits one and credits the other or does neither - the database is never left with the money in neither place.

41.

Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

A.Nonrepeatable read
B.Phantom read
C.Dirty read
D.Consistent read

Answer: B

Correct answer: Phantom read

A phantom read is the appearance of new rows that were not there on the earlier read, inserted and committed by another transaction in the interval. It is distinct from a nonrepeatable read, where rows already seen have changed or gone. Only the serializable isolation level prevents phantoms.

Discuss in Forum

42.

The size of the lock is referred to as the lock granularity.

A.True
B.False

Answer: A

Correct answer: True

Lock granularity is the size of the item locked, from a single row up to the whole database. Fine granularity allows more transactions to proceed at once but requires far more locks to be held and checked; coarse granularity is cheap to administer but blocks transactions that would not really have conflicted.

Discuss in Forum

43.

When two transactions are being processed against the database at the same time they are termed concurrent transactions.

A.True
B.False

Answer: A

Correct answer: True

Transactions are concurrent when their execution overlaps in time, whether or not they touch the same data. The whole apparatus of locking and isolation levels exists to make concurrent transactions behave as though they had run one after another, which is what serializability means.

Discuss in Forum

44.

Which of the following occurs when one transaction reads a changed record that has not been committed to the database?

A.Nonrepeatable read
B.Phantom read
C.Dirty read
D.Consistent read

Answer: C

Correct answer: Dirty read

A dirty read is reading data that another transaction has changed but not yet committed. If that transaction subsequently rolls back, the value read never existed in the database at all, and any decision taken on it is unfounded. Only the read uncommitted isolation level permits it.

Discuss in Forum

45.

What is the overall responsibility of the DBA?

A.Facilitate the development and use of the database
B.Create and populate tables
C.Development, operation, and maintenance of the database and its applications
D.Both the first and third answers above are correct.

Answer: D

Correct answer: Both the first and third answers above are correct.

The two statements are the same responsibility described at two levels. The DBA facilitates the development and use of the database, and that facilitation covers the development, operation and maintenance of the database and its applications. Creating and populating tables is one task within that, not a statement of the overall responsibility.

Discuss in Forum

46.

A transaction for which all committed changes are permanent is called:

A.atomic.
B.consistent.
C.isolated.
D.durable.

Answer: D

Correct answer: durable

Durability means that once a transaction has committed, its changes are permanent and survive any subsequent failure. It is achieved by writing to a log on stable storage before the commit is acknowledged.

Discuss in Forum

47.

A cursor type in which the application can only move forward through the recordset is called:

A.forward only.
B.static.
C.keyset.
D.dynamic.

Answer: A

Correct answer: forward only.

A forward-only cursor can move through the recordset in one direction and cannot return to a row it has passed. It is the cheapest kind, since nothing needs to be retained behind the current position, and it is the right choice whenever the application simply processes each row once.

Discuss in Forum

48.

A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

A.True
B.False

Answer: B

Correct answer: False

What is described is a nonrepeatable read: rows already seen have been modified or deleted by a committed transaction. A phantom read is the appearance of new rows that were not there before. The distinction decides which isolation level is needed, since repeatable read prevents the first but not the second.

Discuss in Forum

49.

In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

A.Read committed
B.Read uncommitted
C.Repeatable read
D.Serializable

Answer: A

Correct answer: Read committed

Read committed guarantees only that data read has been committed by someone, so dirty reads are impossible. It takes no long-term read locks, so a row may change between two reads within the same transaction - a non-repeatable read - and new rows may appear, a phantom. It is the default level in most systems, as a compromise between correctness and concurrency.

Discuss in Forum

50.

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.

A.True
B.False

Answer: A

Correct answer: True

This is the definition of a transaction and it is the atomicity property stated in full. The series of actions is treated as a single indivisible unit, so a transfer between two accounts either debits one and credits the other or does neither - the database is never left with the money in neither place.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: Managing Multiuser Databases Questions and Answers || Managing Multiuser Databases MCQ Questions and Answers || Managing Multiuser Databases GK Questions and Answers || Managing Multiuser Databases GK MCQ Questions || Managing Multiuser Databases Multiple Choice Questions and Answers || Managing Multiuser Databases GK || GK on Managing Multiuser Databases || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

Managing Multiuser Databases Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications