Database Management Questions & Answers: part4



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

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

6.A table that displays data redundancies yields ____________ anomalies. #47.A table that displays data redundancies yields ____________ anomalies.

Update
Insertion
Deletion
All of the above
None of the above.

7.A unit of storage that can store one or more records in a hash file organization is denoted as

Buckets
Disk pages
Blocks
Nodes
Baskets.

8.A condition that occurs when two transactions wait for each other to unlock data is known as a(n)

Shared lock
Exclusive lock
Binary lock
Two-phase lock
Deadlock.

9.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.

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

SQL 2011
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