Database Management Questions and Answers

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

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

11.The following incomplete SQL statement, once completed, is expected to be used to retrieve all employees who have not worked on at least one project? SELECT EMP_ID FROM EMPLOYEE WHERE ��... (SELECT * FROM ALLOCATION WHERE EMPLOYEE.EMP_ID=ALLOCATION.EMP_ID); Fill in the blank with the correct keyword.

EXISTS

NOT EXISTS

ALL

EXIT

NOT IN.

12.What is a predicate expressing a condition that always must be satisfied?

Assertion

Trigger

Procedure

Function

Generalization.

13.The best solution for a DBA to do in the case of a deadlock is

re-boot the system

backup the database, drop the indexes and restore the database

see the sessions which are running and kill all the sessions involved in the deadlock except for one

de fragmenting the disk

None of the above.

14.In a relationship, when a primary key from one table is also defined in a second table, what is the name of the field is referred to in the second table.

Combined Key

Redundant field

Primary key

Foreign key

Candidate Key.

More Database Management QUESTIONS AND ANSWERS available in next pages