SQL question. Which option(s) are correct: In the COMPANY database, used in lectures, the following statement creates a table: CREATE TABLE EMPLOYEE ( ... FOREIGN KEY(DNO)REFERENCES DEPARTMENT(DNUMBER)ON DELETE SET DEFAULT ON UPDATE CASCADE, FOREIGN KEY(SUPERSSN)REFERENCES EMPLOYEE(SSN)ON DELETE SET NULL ON UPDATE CASCADE, ... ); What will happen if an employee's social security number (SSN) changes? Select one or more: a. The SUPERSSN value will be set to NULL for all employees supervised by that employee. b. The SSN value will automatically change for that employee's supervisor. c. The SUPERSSN value will automatically change for all employees supervised by that employee. d. The SSN value will be set to NULL for that employee's supervisor. e. None of the above.
SQL question. Which option(s) are correct:
In the COMPANY
CREATE TABLE EMPLOYEE (
...
FOREIGN KEY(DNO)REFERENCES DEPARTMENT(DNUMBER)ON DELETE SET DEFAULT ON UPDATE CASCADE,
FOREIGN KEY(SUPERSSN)REFERENCES EMPLOYEE(SSN)ON DELETE SET NULL ON UPDATE CASCADE,
...
);
What will happen if an employee's social security number (SSN) changes?
Select one or more:
a.
The SUPERSSN value will be set to NULL for all employees supervised by that employee.
b.
The SSN value will automatically change for that employee's supervisor.
c.
The SUPERSSN value will automatically change for all employees supervised by that employee.
d.
The SSN value will be set to NULL for that employee's supervisor.
e.
None of the above.
Step by step
Solved in 3 steps
