Database Management Questions & Answers: part16



Software Programming : Database Management QUESTIONS AND ANSWERS :: part16 : 1 to 5

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :

1.Which property of transaction ensures that either all operations of the transaction are reflected properly in the database or none are?

Atomicity
Durability
Isolation
Consistency
Consistency.

2.What constraints maintain uniqueness in a record?

Entity integrity
Referential Integrity
Domain Integrity
Check integrity
NULL.

3.A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a

database-level lock
table-level lock
page-level lock
row-level lock.
column-level lock.

4.Which level of RAID refers to disk mirroring with block striping?

RAID level 1
RAID level 2
RAID level 0
RAID level 3
RAID level 4.

5.A condition that occurs when two transactions wait for each other to unlock data is known as a(n)

shared lock
exclusive lock
two-phase lock
deadlock
Timestamp.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
If you are not willing to risk the usual you will have to settle for the ordinary- Jim Rohn