Service

Chat Now

Which of the following SQL statements drop the primary key of Department relation? The fie

Which of the following SQL statements drop the primary key of Department relation? The fie

Which of the following SQL statements drop the primary key of Department relation? The fields in Employee should reflect the removal in Department table.

(a)ALTER TABLE Department DROP PRIMARY KEY
(b)ALTER TABLE Department DROP PRIMARY KEY(Dept_Code)
(c)ALTER TABLE Department DROP PRIMARY KEY CASCADE
(d)ALTER TABLE Department DROP PRIMARY KEY RESTRICT
(e)DROP PRIMARY KEY Dept_Code FROM Department CAS.

Johnson 29-Dec-2017

Answer (Solved)

question Get solution