In reference to the above given table structures, which of th…

Unit 4 · Database Management Systems Paper 2 CS · November 2020

Directions (Q96–100): A university database has the tables EMPLOYEE (EID, NAME, SALARY, DEPTNO, HODEID …; PRIMARY KEY EID; HODEID references EMPLOYEE(EID); DEPTNO references DEPARTMENT(DID)), DEPARTMENT (DID, DNAME, HODID; PRIMARY KEY DID; UNIQUE DNAME; HODID references EMPLOYEE(EID)) and PROJECTWORK (EMPID, PROJNO; PRIMARY KEY (EMPID, PROJNO); 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;

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: A. (A) and (B) only

Explanation

ALTER TABLE EMPLOYEE DROP SALARY with CASCADE or RESTRICT is valid SQL; ALTER EMPLOYEE (without TABLE) is not.

← Previous question Next question →

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;`

Explanation

More Database Management Systems questions

In reference to the above given tablestructures, 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;

Explanation

More Database Management Systems questions

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;`