Database Management Questions & Answers: part2



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 2015 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

    Health is the greatest gift, contentment is the greatest wealth -Buddha