Quiz for RENAME

Q1: Which command is used to rename a table in SQL?

A. CHANGE TABLE B. MODIFY TABLE C. RENAME TABLE D. ALTER TABLE NAME

Q2: Which SQL command is used to rename a table?

A. ALTER TABLE old_name RENAME TO new_name; B. RENAME TABLE old_name TO new_name; C. MODIFY TABLE old_name TO new_name; D. CHANGE TABLE old_name new_name;

Q3: Which clause is used in MySQL to rename a table?

A. RENAME TABLE old_name = new_name; B. RENAME TABLE old_name TO new_name; C. ALTER TABLE RENAME TO; D. MODIFY TABLE;

Q4: To rename a column in a table, which clause is used in Oracle?

A. ALTER TABLE table_name CHANGE old_col new_col; B. RENAME COLUMN old_col TO new_col; C. ALTER TABLE table_name RENAME COLUMN old_col TO new_col; D. MODIFY COLUMN;

Q5: In SQL Server, how do you rename a column?

A. ALTER TABLE table_name RENAME COLUMN; B. EXEC sp_rename; C. MODIFY TABLE; D. RENAME TABLE;

Q6: Which command is used to rename a database in MySQL?

A. ALTER DATABASE RENAME; B. RENAME DATABASE old_name TO new_name; C. RENAME SCHEMA old_name TO new_name; D. There is no direct command.

Q7: Is it possible to rename multiple tables in a single RENAME command?

A. Yes, in all RDBMS B. Yes, in MySQL only C. No, only one at a time D. Yes, but only in PostgreSQL

Q8: What happens if the new table name already exists?

A. It is overwritten B. An error occurs C. It is merged D. Old table is dropped

Q9: Can you rename a view using the RENAME command?

A. Yes B. No C. Depends on DBMS D. Only in MySQL

Q10: What is the correct way to rename a column in PostgreSQL?

A. ALTER TABLE table_name CHANGE COLUMN old_col new_col TYPE data_type; B. RENAME COLUMN old_col TO new_col; C. ALTER TABLE table_name RENAME COLUMN old_col TO new_col; D. MODIFY COLUMN old_col new_col;

Q11: Can RENAME TABLE change both schema and name?

A. Yes, using full table reference B. No C. Only schema D. Only name

Q12: How would you rename the "employee" table to "staff"?

A. ALTER TABLE employee TO staff; B. RENAME employee TO staff; C. ALTER TABLE employee RENAME TO staff; D. MODIFY TABLE employee TO staff;

Q13: Which RDBMS uses `RENAME TABLE` syntax?

A. MySQL B. Oracle C. PostgreSQL D. SQL Server

Q14: Can you rename a column and change its datatype in one command?

A. Yes B. No C. Only in SQL Server D. Only in Oracle

Q15: Which of the following is invalid?

A. ALTER TABLE tab RENAME TO new_tab; B. ALTER TABLE tab RENAME COLUMN col1 TO col2; C. RENAME TABLE tab; D. EXEC sp_rename;

Q16: To rename a column in MySQL, what syntax is used?

A. ALTER TABLE table_name CHANGE old_col new_col data_type; B. RENAME COLUMN old_col TO new_col; C. MODIFY COLUMN old_col; D. RENAME old_col;

Q17: What is required when renaming a column in MySQL?

A. Just old and new name B. Old, new name, and data type C. Only new name D. Only old name

Q18: Can you rename a constraint in SQL?

A. Yes, in all RDBMS B. Only in SQL Server and Oracle C. No D. Yes, using ALTER CONSTRAINT

Q19: Is RENAME part of standard SQL?

A. Yes B. No C. Only partially D. Depends on version

Q20: How do you rename a schema in PostgreSQL?

A. ALTER SCHEMA RENAME TO new_schema; B. RENAME SCHEMA old TO new; C. ALTER SCHEMA old RENAME TO new; D. RENAME DATABASE old TO new;

Q21: Which keyword is NOT used in renaming operations?

A. ALTER B. RENAME C. MODIFY D. EXEC