Question: Which of the following is not a valid SQL statement? a. CREATE TABLE anothernewtable (newtableid VARCHAR2(2)); b. CREATE TABLE anothernewtable (date, anotherdate) AS (SELECT orderdate,

Which of the following is not a valid SQL statement?
a. CREATE TABLE anothernewtable (newtableid VARCHAR2(2));
b. CREATE TABLE anothernewtable (date, anotherdate) AS (SELECT orderdate, shipdate FROM orders);

c. CREATE TABLE anothernewtable (firstdate, seconddate) AS (SELECT orderdate, shipdate FROM orders);

d. All of the above are valid statements.

Step by Step Solution

3.56 Rating (177 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

b CREATE TABLE ano... 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_60b8c1212144f_716028.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1212144f_716028.docx

120 KBs Word File

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