Managing Multiuser Databases - General Questions Online Exam Quiz
Managing Multiuser Databases - General Questions GK Quiz. Question and Answers related to Managing Multiuser Databases - General Questions. MCQ (Multiple Choice Questions with answers about Managing Multiuser Databases - General Questions
Locks placed by command are called ________ .
Options
A : implicit locks
B : explicit locks
C : exclusive locks
D : shared locks
Which of the following locks the item from change but not from read?
Options
A : Implicit lock
B : Explicit lock
C : Exclusive lock
D : Shared lock
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?
Options
A : Nonrepeatable read
B : Phantom read
C : Dirty read
D : Consistent read
A transaction for which all committed changes are permanent is called:
Options
A : atomic.
B : consistent.
C : isolated.
D : durable.
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Options
A : Read committed
B : Read uncommitted
C : Repeatable read
D : Serializable
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Options
A : Nonrepeatable read
B : Phantom read
C : Dirty read
D : Consistent read
The advantage of optimistic locking is that:
Options
A : the lock is obtained only after the transaction has processed.
B : the lock is obtained before the transaction has processed.
C : the lock never needs to be obtained.
D : transactions that are best suited are those with a lot of activity.
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Options
A : Forward only
B : Static
C : Keyset
D : Dynamic
Which of the following refers to a cursor type where changes of any type and from any source are visible?
Options
A : Forward only
B : Static
C : Keyset
D : Dynamic
Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Options
A : Read committed
B : Read uncommitted
C : Repeatable read
D : Serializable
Advanced SQL - General Questions more Online Exam Quiz
Introduction to SQL - General Questions
JDBC, Java Server Pages, and MySQL - General Questions
Logical Database Design - General Questions
Managing Databases with Oracle - General Questions
SQL Server 2000 - General Questions
Modeling Data in the Organization - General Questions
Object-Oriented Database - General Questions
Object-Oriented Data Modeling - General Questions