MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Managing Multiuser Databases
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
True
False
Q.2
A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
True
False
Q.3
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
Q.4
A point of synchronization between the database and the transaction log is generally referred to as a stop point.
True
False
Q.5
An exclusive lock locks the item from change but not from read.
True
False
Q.6
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.
True
False
Q.7
The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.
True
False
Q.8
When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
True
False
Q.9
The size of a lock is referred to as lock sizing.
True
False
Q.10
The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
True
False
Q.11
Database administration refers to a function that applies to the entire organization.
True
False
Q.12
When two transactions are being processed against the database at the same time they are termed concurrent transactions.
True
False
Q.13
Locks placed by the DBMS are explicit locks.
True
False
Q.14
In optimistic locking, the assumption is made that conflict will occur.
True
False
Q.15
Locks placed by command are implicit locks.
True
False
Q.16
Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.
True
False
Q.17
The overall responsibility of the DBA is to facilitate the development and use of the database.
True
False
Q.18
The size of the lock is referred to as the lock granularity.
True
False
Q.19
A durable transaction is one in which all committed changes are permanent.
True
False
Q.20
An ACID transaction is one that is atomic, consistent isolated, and durable.
True
False
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page