Database Management Questions and Answers

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

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

1.The lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is

Database-level lock

Table-level lock

Page-level lock

Row-level lock

Field-level lock.

2.In the ANSI/SPARC three level database model, the external view is best described by which of the following options?

It is the link between users and the storage structures

It is dependent on the underlying DBMS product used (e.g. Oracle, DBASE)

It is the place where the users interface to the DBMS

It is not part of the model

It is the place where the storage structures link to the database.

3.A Relational operator that yields all possible pairs of rows from two tables is known as a/an

Union

Intersect

Difference

Project

Product.

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

Atomicity

Durability

Isolation

Consistency

Concurrency.

5.What factors would not determine the capacity of a block of a disk organization?

Blocking factor

Record size

Block pointer

Inter-block gap

End of track.

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: part8

Database Management Questions and Answers

Related Online Test