Multiple choice technology databases

Which four are correct guidelines for naming database tables? (Choose four.)

  1. Must begin with either a number or a letter

  2. Must be 1-30 characters long

  3. Should not be an Oracle Server reserved word

  4. Must contain only A-Z, a-z, 0-9, _, *, and #
  5. Must contain only A-Z, a-z, 0-9, _, $, and #

  6. Must begin with a letter
Reveal answer Fill a bubble to check yourself
B,C,E,F Correct answer
Explanation

Oracle table names must be 1-30 characters (B), cannot be reserved words (C), contain only A-Z, a-z, 0-9, _, $, and # (E), and must begin with a letter (F). Option A is wrong because names cannot begin with numbers. Option D incorrectly includes * and omits $. These are standard Oracle naming conventions.

Keep practicing — related questions