With regards to transaction processing, any DBMS should be capable of: – McqOptions

MCQOPTIONS

1.	With regards to transaction processing, any DBMS should be capable of:
A.	Ensuring that transactions are free from interference from other users.
B.	Parts of a transaction are not lost due to a failure.
C.	Transactions do not make the database inconsistent.
D.	All of the above.
Answer» E.

Discussion

No Comment Found

Related MCQs

<p>Who detects the failure of the system and restore the database to consistent state ?</p>
<p>Which phage always carries a small piece of E.coli genome?</p>
<p>Which of the following are functions of Database Manager ?<br> <br> 1. Interacting with File Manager<br> 2. Creating Queries to Access data<br> 3. Security Enforcement<br> 4. Database Definition and Schema Generation</p>
<p>Transaction management ensures ____________ and __________ properties.</p>
<p>___________ is an interface between low level database and application program.</p>
<p>A transaction may not always complete its execution successfully. Such a transaction is termed</p>
<p>Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?</p>
<p>What are the Svedberg values for the subunits of the 70S ribosomes of E. colli?</p>
<p>When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj ). Otherwise, Ti is rolled back (dies). This is</p>
<p>The deadlock state can be changed back to stable state by using _____________ statement.</p>