Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part20 : 11 to 15

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

11.A table is in the Fourth Normal Form (4NF) if

All attributes must be dependent on the primary key, and must be dependent on each other

All attributes must be dependent on the primary key, but must be independent of each other

No row can contain two or more multivalued facts about an entity

A and C

B and C.

12.ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is

BETWEEN

IS NULL

Exists.

13.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 files organization

Index File.

14.The most recent version of standard SQL prescribed by the American National Standards Institute is

SQL-99

SQL 2002