Multiple choice technology databases

Which of the following can be a valid column name?

  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Oracle column names must start with a letter, can contain letters, numbers, and underscore (), but cannot start with a number. 'Catch#22' is valid because it starts with a letter and contains a hash symbol (#) which is allowed in column names. '1966_Invoices' starts with a number so it's invalid. 'Column' is a reserved keyword. '#Invoices' starts with a symbol.

Keep practicing — related questions