Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part8 : 6 to 10

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

6.The referential integrity rule requires that ________.

Every null foreign key value must reference an existing primary key value

An attribute have a corresponding value

You delete a row in one table whose primary key does not have a matching foreign key value in another table

Every non-null foreign key value reference an existing primary key value

Both (opt1) and (opt3) above.

7.What will happen to leaf and internal nodes if data is inserted into a B-tree?

Collapse

Mix

Split

Merge

Shrink.

8.Which of the following is an incorrect statement? #110.Which of the following is an incorrect statement?

Pointer � A data model which assumes that all data relationships can be structured as hierarchies

Data model � A physical address which identifies where a record can be found on a disk

Child record � An owner record in a hierarchical relationship

Network model � A data relationship in which a record can be owned by records from more than one type

Data model � A conceptual method of structuring data.

9.Which among the following is function of DBA?

Communicating with all computer users

Classify user groups and provide authorization to access data elements

Retrieve data and supply daily reports to the top management

Install upgrades of database hardware

Monitor systems performance and increasing complexity.

10.�One disadvantage of index schemes in file organizations is that an index must be accessed and read to locate records. In order to eliminate the need for maintaining and searching indexes, the method can be used as a method of direct record addressing.� Find the appropriate option which fills in the blanks with suitable terms for (i) and (ii).

i. sequential

indexing

i. indexed Sequential

hashing

i. sequential

More Database Management QUESTIONS AND ANSWERS available in next pages