SQL RENAME
6.Can RENAME be rolled back?
-
A. Always
-
B. Sometimes
-
C. Only with a transaction
-
D. Never
Only with a transaction
Only with a transaction
7.Which SQL keyword is often used with RENAME in PostgreSQL?
-
A. UPDATE
-
B. ALTER TABLE
-
C. MODIFY
-
D. SET NAME
ALTER TABLE
ALTER TABLE
8.In MySQL, which statement renames a table?
-
A. RENAME TABLE old TO new;
-
B. CHANGE TABLE name TO new;
-
C. SET TABLE old = new;
-
D. UPDATE TABLE new_name;
RENAME TABLE old TO new;
RENAME TABLE old TO new;
9.Does RENAME affect data inside a table?
-
A. Yes
-
B. No
No
No
10.s it possible to rename multiple tables in a single RENAME statement (MySQL)?
-
A. No
-
B. Yes
Yes
Yes