Which is the valid CREATE [TABLE statement?
A.
CREATE TABLE emp9$# (emp_no NUMBER(4));
B.
CREATE TABLE 9emp$# (emp_no NUMBER(4));
C.
CREATE TABLE emp*123 (emp_no NUMBER(4));
D.
CREATE TABLE emp9$# (emp_no NUMBER(4). date DATE);
Explanation:
Which is the valid CREATE [TABLE statement?
Which is the valid CREATE [TABLE statement?
A.
CREATE TABLE emp9$# (emp_no NUMBER(4));
B.
CREATE TABLE 9emp$# (emp_no NUMBER(4));
C.
CREATE TABLE emp*123 (emp_no NUMBER(4));
D.
CREATE TABLE emp9$# (emp_no NUMBER(4). date DATE);
Explanation:
OPTION A IS CORRECT
CREATE TABLE emp9$# (emp_no NUMBER(4));