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:
d is also correct
Actually D is wrong because of the Column (date) as you can not create column and name it like that
A is True