Consider the relation Emp-Dept with SSn as key: Ename | SSn | EAddr | Dept. No…

PYQ KVS TGT/PGT 2018

Consider the relation Emp-Dept with SSn as key:

Ename | SSn | EAddr | Dept. No | Dept. Name | Dept. Manager SSn

Which of the following is (are) invalid operation(s)?

(i) Inserting an employee without name and address.

(ii) Inserting an employee with only SSn.

(iii) Inserting a department with no employee.

(iv) Inserting an employee without SSn.

  1. A.

    (i) only

  2. B.

    (iv) only

  3. C.

    (iii) and (iv)

  4. D.

    (ii) and (iii)

Attempted by 326 students.

Sign up free to check your answer

Sign up free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…