A developer then runs the following command ALTER TABLE ADD KEY (DEPARTMENT__ID); What is the outcome? CONSTRAINT DEPARTMENT PK A primary key for DEPARTMENTS is created. PRIMARY A foreign key for DEPARTMENTS is created. An error occurs because column DEPARTMENT_ID already has the constraint NOT NULL The command DESC does not show information of the primary key of a table, therefore we won't know if the command will or will not fail.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
The command DESC DEPARTMENTS shows the following information:
Name
A M G V
Null?
MANAGER D
LOCATION ID
DEPARTMENT ID NOT NULL NUMBER (4)
DEPARTMENT NAME NOT NULL VARCHAR2 (30)
NUMBER (6)
NUMBER (4)
Туре
A developer then runs the following command
ALTER TABLE ADD CONSTRAINT
KEY (DEPARTMENT ID);
What is the outcome ?
DEPARTMENT PK
A primary key for DEPARTMENTS is created.
A foreign key for DEPARTMENTS is created.
PRIMARY
An error occurs because column DEPARTMENT_ID already has the
constraint NOT NULL
The command DESC does not show information of the primary key of a
table, therefore we won't know if the command will or will not fail.
Transcribed Image Text:The command DESC DEPARTMENTS shows the following information: Name A M G V Null? MANAGER D LOCATION ID DEPARTMENT ID NOT NULL NUMBER (4) DEPARTMENT NAME NOT NULL VARCHAR2 (30) NUMBER (6) NUMBER (4) Туре A developer then runs the following command ALTER TABLE ADD CONSTRAINT KEY (DEPARTMENT ID); What is the outcome ? DEPARTMENT PK A primary key for DEPARTMENTS is created. A foreign key for DEPARTMENTS is created. PRIMARY An error occurs because column DEPARTMENT_ID already has the constraint NOT NULL The command DESC does not show information of the primary key of a table, therefore we won't know if the command will or will not fail.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Procedures in SQL
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education