Which of the following commands creates a new table containing two columns? a. CREATE TABLE newname (coll

Question:

Which of the following commands creates a new table containing two columns?
a. CREATE TABLE newname (coll DATE, col2 VARCHAR2);
b. CREATE TABLE newname AS (SELECT title, retail, cost FROM books);
c. CREATE TABLEnewname (coll, col2);
d. CREATE TABLE newname (coll DATE DEFAULT SYSDATE, col2 VARCHAR2(1));

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: