Database Transactions Mcqs

Our collections of Multiple choice questions and answers focuses on study of Database Transactions. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on Database Transactions comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Database Transactions Mcqs

1.
The deadlock in a set of transaction can be determined by

Read-only graph

Wait graph

Wait-for graph

All of the mentioned

2.
A deadlock exists in the system if and only if the wait-for graph contains a ___________.

Cycle

Direction

Bi-direction

Rotation

3.
Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is

How long the transaction has computed, and how much longer the transaction will compute before it completes its designated task.

How many data items the transaction has used.

How many more data items the transaction needs for it to complete and how many transactions will be involved in the rollback.

All of the above

4.
__________ rollback requires the system to maintain additional information about the state of all the running transactions.

Total

Partial

Time

Commit

6.
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?

Nonrepeatable read

Phantom read

Dirty read

Consistent read

7.
A transaction for which all committed changes are permanent is called:

Atomic

Consistent

Isolated

Durable

8.
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

Read committed

Read uncommitted

Repeatable read

Serializable

9.
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

Nonrepeatable read

Phantom read

Dirty read

Consistent read

10.
A transaction may not always complete its execution successfully. Such a transaction is termed

Aborted

Terminated

Closed

All of the mentioned

11.
Transaction processing is associated with everything below except

Producing detail, summary, or exception reports

Recording a business activity

Confirming an action or triggering a response

Maintaining data

12.
Transaction management ensures ____________ and __________ properties.

Atomicity and Intigrity

Atomicity and Durability

Atomicity and Abstraction

None of these

13.
____________ is an interface between low level database and application program.

Database Associator

Database Server

Database Manage

None of these

14.
Which of the following are functions of Database Manager ?1. Interacting with File Manager2. Creating Queries to Access data3. Security Enforcement4. Database Definition and Schema Generation

1 and 2

3 and 1

1, 2 and 3

All of these

15.
Who detects the failure of the system and restore the database to consistent state ?

Database Administrator

Application Programmer

Naive User

Storage Manager

error: You are not allowed to do so.....
0Shares
0
Scroll to Top