Which of the following is a valid SQL statement?
A) CREATE TABLE newname (colA NUMBER,colB DATE);
B) CREATE TABLE newname as SELECT * FROM books;
C) CREATE TABLE newname (colA,colB);
D) CREATE TABLE newname (colA DATE,colB VARCHAR2(3);

Question

Which of the following is a valid SQL statement?​
A) ​CREATE TABLE newname (colA NUMBER,colB DATE);
B) ​CREATE TABLE newname as SELECT * FROM books;
C) ​CREATE TABLE newname (colA,colB);
D) ​CREATE TABLE newname (colA DATE,colB VARCHAR2(3);

Quizplus · Accepted Answer

Option A is a valid SQL statement for creating a new table named "newname" with two columns, "colA" of type NUMBER and "colB" of type DATE. The syntax correctly defines the data types for each column and ends with a semicolon.

Which of the Following Is a Valid SQL Statement?​

Which of the Following Is a Valid SQL Statement?