Database Management Questions & Answers: part4

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

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

1.DBMS periodically suspends all processing and synchronizes its files and journals through the use of

Checkpoint facility
Backup facility
Recovery manager
Database change log
Shadow Paging.

2.The extent of the database resource that is included with each lock is called the level of

DBMS control

3.The file organization which allows us to read records that would satisfy the join condition by using one block read is

Heap file organization
Sequential file organization
Clustering file organization
Hash files organization
Index File.

4.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
Field-level lock.

5.The basic SQL aggregate function that gives the number of rows containing not null values for the given column is


More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
If your ship doesn’t come in, swim out to meet it!-Jonathan Winters