Multiple choice

When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

  1. are case insensitive.

  2. are case sensitive.

  3. must always be in lower case.

  4. must always be in upper case.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL*Plus and Oracle database identifiers are case-insensitive by default. This means 'SELECT', 'select', and 'Select' are treated identically, and table/column names like 'Employee' and 'employee' refer to the same object. This case-insensitivity applies unless quoted identifiers are used, in which case they become case-sensitive. The default behavior makes SQL*Plus more user-friendly and less prone to typing errors.

Keep practicing — related questions