Which of the following SQL statements is invalid and returns an error message? a. ALTER TABLE books

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 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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: