Oracle Database 11g: SQL Fundamentals I — Question 10

Which is a valid CREATE TABLE statement?

Answer options

• A. CREATE TABLE EMP9$# AS (empid number(2));
• B. CREATE TABLE EMP*123 AS (empid number(2));
• C. CREATE TABLE PACKAGE AS (packid number(2));
• D. CREATE TABLE 1EMP_TEST AS (empid number(2));

Correct answer: A

Explanation

The correct answer, A, utilizes a valid table name that starts with a letter and includes valid characters. Options B and D have invalid characters or start with a digit, making them unacceptable. Option C, while valid syntax, does not match the correct answer criteria.