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);
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);
Why option D is incorrect?
Because column name cannot be any reservered word. In this case column cannot have name ‘date’.
http://docs.oracle.com/cd/B19306_01/server.102/b14200/ap_keywd.htm
ok
Why option C is incorrect?
A schema object is an object that is owned by a user. All schema object names must
conform to certain rules:
■ The name may be from 1 to 30 characters long (with the exception of
database link names that may be up to 128 characters long).
■ Reserved words (such as SELECT) cannot be used as object names.
■ All names must begin with a letter from “A” through “Z.”
■ The characters in a name can only be letters, numbers, an underscore (_),
the dollar sign ($), or the hash symbol (#).
■ Lowercase letters will be converted to uppercase.
special letters not allowed,so why emp9# is correct statement