Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part18 : 11 to 15

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

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

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

Select

From

Order By

Group By

Where.

13.A method that speeds query processing by running a query at the same time against several partitions of a table using multi processors is called

Multiple partition query

Perpendicular query processing

Parallel query processing

Query optimization

Query Execution.

14.In the context of a database table, the statement "A determines B" indicates that #285.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.

More Database Management QUESTIONS AND ANSWERS available in next pages