Comprehension
Comprehension: Consider the following table structures related to a university for given questions.
EMPLOYEE
NAME
|
VARCHAR (30)
|
NOT NULL,
|
EID
|
VARCHAR (10)
|
NOT NULL,
|
DEPTNO
|
INT (5)
|
NOT NULL,
|
HODEID
|
VARCHAR (10),
|
|
SALARY
|
INT (10),
|
|
PRIMARY KEY (EID),
FOREIGN KEY (HODEID) REFRENCES EMPLOYEE (EID),
FOREIGN KEY (DEPTNO) REFRENCES DEPARTMENT (DID);
DEPARTMENT
DID
|
INT (5)
|
NOT NULL,
|
DNAME
|
VARCHAR (30)
|
NOT NULL,
|
HODID
|
VARCHAR (10)
|
NOT NULL,
|
HODNAME
|
VARCHAR (30),
|
|
PRIMARY KEY (DID),
UNIQUE (DNAME),
FOREIGN KEY (HODID) REFERENCES EMPLOYEE (EID),
PROJECT WORE:
EMPID
|
VARCHAR (10)
|
NOT NULL,
|
PROJNO
|
INT (5)
|
NOT NULL,
|
PROJECTLOC
|
VARCHAR (30)
|
NOT NULL,
|
PRIMARY KEY (EMPID, PROJNQ),
FOREIGN KEY (EMPID) REFERENCES EMPLOYEE (EID),
In reference to the above given table structures, which of the following query/queries will drop the ‘SALARY’ column from 'EMPLOYEE' table ?
(A) ALTER TABLE EMPLOYEE DROP SALARY CASCADE;
(B) ALTER TABLE EMPLOYEE DROP SALARY RESTRICT;
(C) ALTER EMPLOYEE DROP SALARY:
Choose the correct answer from the options given below:
1. (A) and (B) only
2. (A) and (C) only
3. (B) and (C) only
4. (A) only