Transactional Database MCQ’s  Solved

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

[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]

3. Commit and rollback in database transactions are related to?
A. data security
B. data integrity
C. Data consistency
D. none of these
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]

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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]

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

[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
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

[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]

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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]

8. In database transaction, a transaction is said to be the unit of programs
A. Execution
B. Evolution
C. computation
D. none of these
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]A[/su_spoiler]

9. During transaction maintain the consistency, the database provides?
A. flashback
B. commit
C. rollback
D. atomic
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
12. Schedules should preferably be in a transaction database.
A. dependent
B. cascading
C. cascade less
D. none of these
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
13. In database transaction, Transaction will undo all statements up to commit?
A. Abort
B. Rollback
C. Flashback
D. none of these
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
15. A transaction is terminated if it has?
A. Aborted or committed
B. Aborted
C. running state
D. none of these
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]C[/su_spoiler]
16. In database transaction ensuring durability is the responsibility of?
A. Recover manager
B. update manager
C. Control manager
D. none of these
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]A[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]B[/su_spoiler]
18. Transaction per rollback segment is derived from….
A. processes
B. shared poll size
C. buffers
D. none of these
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]A[/su_spoiler]
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
[su_spoiler title=”Answer – Click Here:” class=”padding: -10px;”]A[/su_spoiler]