Multiple choice technology programming languages

Choose the correct statements for creating a table?

  1. Names are case sensitive.

  2. Names must not be oracle server reserve word.

  3. Table names and column names need not be start with a letter.

  4. We cannot use a column alias in a WHERE clause
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

In Oracle SQL, table/column names cannot be reserved words (like SELECT, FROM, etc.) without quoting. Column aliases (defined in SELECT clause) cannot be used in WHERE clause because WHERE is processed before SELECT. Names are case-insensitive and must start with a letter.

Keep practicing — related questions