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

Impact
Granularity
Management
DBMS control
Recovery.

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

MIN
COUNT
MAX
SUM
AVG.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
The only place where success comes before work is in the dictionary.- Vidal Sassoon