Transactional Database MCQ’s Solved
1. The durability of database transaction can be ensured in different
A. 4ways
B. 3ways
C. 2ways
D. none of these
2. Which one of the following consists of a sequence of queries and/or update statement.
A. Rollback
B. transaction
C. flashback
D. none of these
3. Commit and rollback in database transactions are related to?
A. data security
B. data integrity
C. Data consistency
D. none of these
4. Use of Concurrent execution of transaction improves of the following element in the database? transaction?
A. Response Time
B. Throughput
C. run time
D. none of these
5. The following program what action can you do?
TRANSACTION…..
Commit;
ROLLBACK;
What does rollback do?
A. clear all transaction
B.radoes the transaction before commit
C. Undoes the transaction before commit
D. nothing action can be performed
6. The transaction that wants to edit the data item is called?
A. Shared mode
B. Exclusive mode
C. inclusive mode
D. none of these
7. The transition wants only to read the data item of the mode is called as?
A. exclusive mode
B. inclusive mode
C. shared mode
D. none of these
8. In database transaction, a transaction is said to be the unit of programs
A. Execution
B. Evolution
C. computation
D. none of these
9. During transaction maintain the consistency, the database provides?
A. flashback
B. commit
C. rollback
D. atomic
10. Which one of the following servers which used in relational database systems,
A. client-server
B. data server
C. transaction servers
D. none of these
11. Which one is in……, one or more user/programs attempts to access the same data at the same time?
A. locking
B. concurrency
C. transaction control
D. none of these
12. Schedules should preferably be in a transaction database.
A. dependent
B. cascading
C. cascade less
D. none of these
13. In database transaction, Transaction will undo all statements up to commit?
A. Abort
B. Rollback
C. Flashback
D. none of these
14. In a transaction database, a distributed transaction can be …….. if queries are issued at one or more nodes.
A. write only
B. fully read-only
C. partially read-only
D. none of these
15. A transaction is terminated if it has?
A. Aborted or committed
B. Aborted
C. running state
D. none of these
16. In database transaction ensuring durability is the responsibility of?
A. Recover manager
B. update manager
C. Control manager
D. none of these
17. Select the most suitable one that can make the transaction permanent in the database?
A. Rollback
B. commit
C. flashback
D. none of these
18. Transaction per rollback segment is derived from….
A. processes
B. shared poll size
C. buffers
D. none of these
19. Which of the following can be considered as a unit of program execution and accesses and possibly updates various data items.
A. Transaction
B. Monitor
C. DBMS
D. none of these