Database Management Questions & Answers: part20



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
LIKE
IN
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
SQL � 4
SQL2
SQL PLUS.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Trust because you are willing to accept the risk, not because it’s safe or certain