Database Management Questions & Answers: part6



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

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

6.Horizontal Fragmentation is

Divide the data up by logical groups of records
Divide the data up by logical groups of attributes
Divide the data up by logical groups of entities
Divide the data up by logical groups of files
Divide the data up by logical frames.

7.In an SQL statement, which of the following parts states the conditions for row selection?

Select
From
Order By
Group By
Where.

8.An index record appears for every search key value in the file is

Secondary index
Dense index
Sparse index
Multi level index
B+ tree.

9.The protocol that ensures conflict serializability is

Time stamp ordering protocol
Two phase locking protocol
Concurrency protocol
Tree protocol
Layered Protocol.

10.Which of the following questions is answered by the SQL statement? Select Count (Product_Description) from Product_T;

How many products are in the Product Table?
How many different product descriptions are in the Product Table?
How many characters are in the field name "Product_Description"?
How many different columns named "Product Description� is there in table Product_T?
How many total records in a table?

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Innovation distinguishes between a leader and a follower.-Steve Jobs