Database Management Questions and Answers

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

Innovation distinguishes between a leader and a follower.-Steve Jobs

Related Online Test

Bank General Knowledge - Online Test 1
Bank General Knowledge - Online Test 3
Bank General Knowledge - Online Test 4
Bank General Knowledge - Online Test 5
Bank General Knowledge - Online Test 6
Bank Model question Paper - Online Test 1
Bank Numerical Ability - Online Test 1

Database Management Questions & Answers: part4

Database Management Questions and Answers

Related Online Test