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).

Using DDL Statements to Create and Manage Tables

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

(32 responses)

A
72% (23)
B
3% (1)
C
16% (5)
D
9% (3)

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).

Topics

#CREATE TABLE#naming conventions#reserved words#DDL syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice