PrepAway - Latest Free Exam Questions & Answers

Which SQL statement will execute successfully?

Given the following CREATE TABLE statement:
CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY,
lastname VARCHAR(50));
Which SQL statement will execute successfully?

PrepAway - Latest Free Exam Questions & Answers

A.
ALTER TABLE applicant ADD COLUMN resume XML WITH DEFAULT

B.
ALTER TABLE applicant ADD COLUMN resume XML(1000) WITH DEFAULT

C.
ALTER TABLE applicant ADD COLUMN resume XML CHECK (resume IS VALIDATED)

D.
ALTER TABLE applicant ADD COLUMN resume XML(1000) CHECK (resume IS
VALIDATED)


Leave a Reply