Database Management Questions & Answers: part18



Software Programming : Database Management QUESTIONS AND ANSWERS :: part18 : 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.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?

8.What does the following SQL statement do? Select * From Customer Where Cust_Type = "Best";

Selects all the fields from the Customer table for each row with a customer labeled "best"
Selects the "*" field from the Customer table for each row with a customer labeled "best"
Selects fields with a "*" in them from the Customer table
Selects all the fields from the Customer table for each row with a customer labeled "*"
Counts all records and displays the value.

9.Which type of file is easiest to update?

Sequential
Hashed
Indexed
Clustered
Random.

10.All of the following are advantages of SQL-invoked routines EXCEPT

Flexibility
Efficiency
Sharability
Security
Easy of use.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
If your ship doesn’t come in, swim out to meet it!-Jonathan Winters