Multiple choice technology databases

Which is a Valid table name:

  1. emp@_tab

  2. emp#_tab
  3. $emp_tab

  4. Emp_delete
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

Oracle table names must start with a letter, can contain letters, digits, and underscores only, and are case-insensitive by default. emp#_tab is valid (# was allowed in older Oracle versions), $emp_tab is invalid ($ is not a standard identifier character), and Emp_delete is valid (starts with letter, contains only underscore as special character).

Keep practicing — related questions