Multiple choice technology databases

Which are correct guidelines for naming database tables?

  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-+, _, *, 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

Under standard Oracle database guidelines, table names must begin with a letter, be 1 to 30 characters long, not use reserved words, and contain only alphanumeric characters, underscores, dollar signs, and pound signs. Special characters like + and * are forbidden.

Keep practicing — related questions