Managing Multiuser Databases - Database MCQ Questions and answers- Technical Aptitude Page-4 section-1

31.
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.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

32.
The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

33.
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

34.
Database administration refers to a function that applies to the entire organization.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

35.
Locks placed by command are implicit locks.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

36.
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

37.
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 & Solution Discuss in Board Save for Later

38.
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 & Solution Discuss in Board Save for Later

39.
A point of synchronization between the database and the transaction log is generally referred to as a stop point.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

40.
An exclusive lock locks the item from change but not from read.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

Managing Multiuser Databases - Database MCQ Questions and answers- Technical Aptitude

31. 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.

Answer & Solution

32. The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.

Answer & Solution

33. The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.

Answer & Solution

34. Database administration refers to a function that applies to the entire organization.

Answer & Solution

35. Locks placed by command are implicit locks.

Answer & Solution

36. The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

Answer & Solution

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

Answer & Solution

38. 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.

Answer & Solution

39. A point of synchronization between the database and the transaction log is generally referred to as a stop point.

Answer & Solution

40. An exclusive lock locks the item from change but not from read.

Answer & Solution

31.
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.

32.
The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.

33.
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.

34.
Database administration refers to a function that applies to the entire organization.

35.
Locks placed by command are implicit locks.

36.
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

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

38.
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.

39.
A point of synchronization between the database and the transaction log is generally referred to as a stop point.

40.
An exclusive lock locks the item from change but not from read.