Which is the valid CREATE [TABLE statement?

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:



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Noble

Noble

d is also correct

Striker

Striker

Actually D is wrong because of the Column (date) as you can not create column and name it like that

Striker

Striker

A is True