Database Management Questions and Answers

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

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

1.A named set of SQL statements that are considered when a data modification occurs are called

Stored procedures

Triggers

Packages

Trapdoors

Treatments.

2.The entity integrity rule states that

No primary key attribute can be null

Referential integrity must be maintained across all entities

Each entity must have a primary key

A primary key must have only one attribute

Foreign key attribute can be Null.

3.Which of the following indexes is based on the values being uniformly distributed using a mathematical function? #17.Which of the following indexes is based on the values being uniformly distributed using a mathematical function?

Ordered index

Hashed index

Dense index

Sparse index

Secondary index.

4.Which type of file is easiest to update?

Sequential

Hashed

Indexed

Clustered

B+ tree.

5.A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key, but contains transitive dependencies is in which normal form?

First

Second

Third

Fourth

Fifth.

More Database Management QUESTIONS AND ANSWERS available in next pages