Database Management Questions & Answers: part13



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

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

1.Which of the following best describes the internal level of the ANSI/SPARC three level architecture?

The internal level is concerned with the layout of records and their locations within disk blocks
The internal level is concerned with the data as seen by individuals internal to the enterprise
The internal level is concerned with the users� view of the data
The internal level is concerned with the how stored fields are represented and which indices exist
The internal level provides a conceptual view of the data structure.

2.The unit of storage that can store one are more records in a hash file organization are

Buckets
Disk pages
Blocks
Nodes
Baskets.

3.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.

4.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 file organization
Index file organization.

5.Which of the following is true with respect to the B+ tree index method?

Records are physically stored in primary key order
B+ trees use a hashing algorithm
The index tree may become unbalanced as a result of updates
Only the primary key field may have a B+ tree index
Records are physically stored in secondary key order.

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