Time Left - 15:00 mins
GATE 2024 Databases Rank Booster Quiz 42
Attempt now to get your rank among 166 students!
Question 1
_______ is NOT a part of the ACID properties.
Question 2
What are the potential problems when a DBMS executes multiple transactions concurrently?
Question 3
Which of the following has “all-or-none” property?
Question 4
Two concurrent executing transactions T1 and T2 are allowed to update same item say ‘A’ in an uncontrolled manner. In such scenario, following problems may occur:
(a) Dirty read problem
(b) Lost update problem
(c) Transaction failure
(d) Inconsistent database state
Which of the following option is correct if database system has no concurrency module and allows concurrent execution of above two transactions?
Question 5
"Dirty read" occurs in the transaction when?
Question 6
Consider the following statement:
S1: Table locking provides the highest degree of concurrency in a relational database.
S2: Isolation is not a part of ACID properties of database transaction.
The number of true statements ________.
S1: Table locking provides the highest degree of concurrency in a relational database.
S2: Isolation is not a part of ACID properties of database transaction.
The number of true statements ________.
Question 7Multiple Correct Options
Consider the following schedules involving three transaction. Which of the following schedules are not conflict serializable?
- 166 attempts
- 0 upvotes
- 0 comments
Tags :
GATE & PSU CSDatabasesJan 2GATE & PSU CS
