Question: Which of the following SQL statements is invalid and returns an error message? a. ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); b. ALTER TABLE

Which of the following SQL statements is invalid and returns an error message?
a. ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid);
b. ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid);
c. ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid);
d. ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid);
e. All of the above statements are invalid.

Step by Step Solution

3.54 Rating (175 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c ALTER TABL... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c121225ce_716079.pdf

180 KBs PDF File

Word file Icon

1803_60b8c121225ce_716079.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!