Which is a valid CREATE TABLE statement?

The correct answer is A. CREATE TABLE EMP9$# AS (empid number(2)). Table names and column names must begin with a letter and be 1-30 characters long. Characters A-Z,a-z, 0-9, _, $ and # (legal characters but their use is discouraged). Incorrect answer: B Non alphanumeric character such as "*" is discourage in Oracle table name. D Table name…

Creating and Managing Schema Objects

Question

Options

ACREATE TABLE EMP9$# AS (empid number(2));
BCREATE TABLE EMP*123 AS (empid number(2));
CCREATE TABLE PACKAGE AS (packid number(2));
DCREATE TABLE 1EMP_TEST AS (empid number(2));

How the community answered

(23 responses)

A
83% (19)
B
4% (1)
C
4% (1)
D
9% (2)

Explanation

Table names and column names must begin with a letter and be 1-30 characters long. Characters A-Z,a-z, 0-9, _, $ and # (legal characters but their use is discouraged). Incorrect answer: B Non alphanumeric character such as "*" is discourage in Oracle table name. D Table name must begin with a letter.

Topics

#CREATE TABLE#naming rules#object naming#DDL

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice