Multiple choice technology databases

If Product is a table name than a) RENAME product to PRO; b) ALTER TABLE product RENAME TO pro;

  1. a is ture

  2. b is fasle

  3. b is false a is ture

  4. a is false b is ture
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In SQL, the correct syntax for renaming a table is 'ALTER TABLE product RENAME TO pro' (or 'RENAME TO PRO' in some databases). The simple 'RENAME product TO PRO' statement is not valid SQL syntax. Therefore, statement (a) is false and statement (b) is true.

Keep practicing — related questions