Database Management Questions & Answers: part6



Software Programming : Database Management QUESTIONS AND ANSWERS :: part6 : 1 to 5

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

1.Out of the following activities, which is the one that normally performed by DBMS, without the interference of the DBA?

Integrity
Retention
Security
Granting the Privileges
Recovery.

2.Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?

Record controller
Exclusive lock
Authorization rule
Two phase lock
Three Phase lock.

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

4.A type of query that is placed within a WHERE or HAVING clause of another query is called

Master query
Sub query
Super query
Multi-query
Co-related query.

5.Which of the following type of index is automatically created when we do not specify?

Bitmap
Balanced Tree Index
Binary Tree Index
Hashed
Sparse Index.

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