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
A Correct answer
Explanation

Oracle table names must start with a letter, can contain letters, digits, and underscores, and cannot be a reserved word. Option A (EMP9$#) is valid because $ and # are allowed characters. Options B (*), C (PACKAGE is reserved), and D (starts with digit 1) are invalid.

Keep practicing — related questions