Multiple choice technology web technology

What are all the valid queries to rename a table employee to employee_copy?

  1. rename table employee as employee_copy

  2. rename employee to employee_copy

  3. alter employee rename to employee_copy

  4. alter table employee rename as employee_copy

  5. alter table employee rename to employee_copy

Reveal answer Fill a bubble to check yourself
B,E Correct answer
Explanation

Oracle supports two valid syntaxes for renaming tables: (1) RENAME old_name TO new_name, and (2) ALTER TABLE old_name RENAME TO new_name. The 'AS' keyword is invalid in both syntaxes. ALTER without TABLE is also invalid.