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, shipdate FROM orders); c. CREATE TABLE anothernewtable (firstdate, seconddate) AS (SELECT orderdate, shipdate FROM orders); d. All of the above are valid statements.

Answer 1

Answer:

b. CREATE TABLE anothernewtable (date, anotherdate)

AS (SELECT orderdate, shipdate FROM orders);

Explanation:

b part query is not valid SQL statement.

Answer 2

Answer:

Option D  All of the above are valid statements.

Explanation:

CREATE TABLE anothernewtable (newtableid VARCHAR2(2));

CREATE TABLE anothernewtable (date, anotherdate) AS (SELECT orderdate, shipdate FROM orders);

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

All these statements are valid for SQL