Database Management Questions & Answers: part8



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
Trust because you are willing to accept the risk, not because it’s safe or certain