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.
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
4. __________ rollback requires the system to maintain additional information about the state of all the running transactions.
Total
Partial
Time
Commit
5. Which of these is data type long literal?
0x99fffL
ABCDEFG
0x99fffa
99671246
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
12. Transaction management ensures ____________ and __________ properties.
Atomicity and Intigrity
Atomicity and Durability
Atomicity and Abstraction
None of these
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
13. ____________ is an interface between low level database and application program.
Database Associator
Database Server
Database Manage
None of these
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
15. Who detects the failure of the system and restore the database to consistent state ?
Database Administrator
Application Programmer
Naive User
Storage Manager
Answer & Solution
No Solution for this Answer..! Report or Discus this Question