Question

During __________ phase, the system reads data and stores them in variables local to the transaction.

a.

Read phase

b.

Validation phase

c.

Write phase

d.

None of the mentioned

Posted under DBMS

Answer: (a).Read phase

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. During __________ phase, the system reads data and stores them in variables local to the transaction.

Add Comment

Similar Questions

Discover Related MCQs

Q. During the _________ phase the validation test is applied to the transaction

View solution

Q. During the _______ phase, the local variables that hold the write operations are copied to the database

View solution

Q. Read only operations omit the _______ phase

View solution

Q. Which of the following timestamp is used to record the time at which the transaction started execution?

View solution

Q. Which of the following timestamps is used to record the time when a transaction has finished its read phase?

View solution

Q. Which of the following timestamps is used to record the time when a database has completed its write operation?

View solution

Q. State true or false: Locking and timestamp ordering force a wait or rollback whenever a conflict is detected.

View solution

Q. State true or false: We determine the serializability order of validation protocol by the validation ordering technique

View solution

Q. In _______ schemes, each write operation creates a new version of Q

View solution

Q. If the first update is overwritten by a second, it is called as a _______ update

View solution

Q. State true or false: Snapshot isolation prevents lost updates

View solution

Q. Which of the following is a variant of snapshot isolation

View solution

Q. Under ________ the system uses locking mechanism that applies only to updates

View solution

Q. The situation in which each pair of transactions has read a data written by the other, but there is no data written by the transactions is called as _______

View solution

Q. Oracle uses __________ for the serializable isolation level

View solution

Q. State true or false: Snapshot isolation has low overhead

View solution

Q. In ________ no two aborts occur unless two concurrent transactions update the same data item.

View solution

Q. Which of the following transactions can multiversion two phase locking protocol not differentiate.

View solution

Q. ________ deletes a data item from a database

View solution

Q. Which of the following does not lock the entire index

View solution

View All MCQs on DBMS

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....