Multiple choice technology databases

Which is a valid CREATE TABLE statement?

  1. CREATE TABLE EMP9$# AS (empid number(2));

  2. CREATE TABLE EMP*123 AS (empid number(2));

  3. CREATE TABLE PACKAGE AS (packid number(2));

  4. CREATE TABLE 1EMP_TEST AS (empid number(2));
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL table names cannot start with numbers (1EMP_TEST is invalid) or contain most special characters like * or $# without specific database escaping. PACKAGE is a reserved SQL keyword but is the only option without obvious syntax violations - some databases allow reserved words as table names with proper quoting.

Keep practicing — related questions