Database Management Questions and Answers

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

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

6.What is the name of the operator in a relation that yields values from all rows in a table?

Difference

Product

Select

Project

Join.

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

Sectors.

8.In the context of a database table, the statement �A determines B� indicates that #255.In the context of a database table, the statement �A determines B� indicates that

Knowing the value of attribute A you can not look up the value of attribute B

You do not need to know the value of attribute A in order to look up the value of attribute B

Knowing the value of attribute B you can look up the value of attribute A

Knowing the value of attribute A you can look up the value of attribute B

None of the above.

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

Random file organization.

10.Which of the following concepts is applicable with respect to 2NF?