Database Management Questions and Answers

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

If your ship doesnât come in, swim out to meet it!-Jonathan Winters

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

Database Management Questions and Answers

Related Online Test