SQL RENAME
1.What does the RENAME statement do in SQL?
-
A. Renames columns only
-
B. Renames entire databases
-
C. Renames tables or columns
-
D. Deletes objects
Renames tables or columns
Renames tables or columns
2.Which command is correct to rename a table in SQL Server?
-
A. ALTER TABLE old_name RENAME TO new_name;
-
B. EXEC sp_rename 'old_name', 'new_name';
-
C. RENAME TABLE old_name TO new_name;
-
D. UPDATE TABLE old_name SET name = new_name;
EXEC sp_rename 'old_name', 'new_name';
EXEC sp_rename 'old_name', 'new_name';
3.How do you rename a column in PostgreSQL?
-
A. RENAME COLUMN old_col TO new_col;
-
B. ALTER TABLE tbl RENAME COLUMN old_col TO new_col;
-
C. SET COLUMN name = new_col;
-
D. None of the above
ALTER TABLE tbl RENAME COLUMN old_col TO new_col;
ALTER TABLE tbl RENAME COLUMN old_col TO new_col;
4.Is RENAME a DML command?
-
A. Yes
-
B. No
No
No
5.Which of the following RENAME usage is invalid in PostgreSQL?
-
A. Renaming a table
-
B. Renaming a column
-
C. Renaming data types
-
D. Renaming a row
Renaming a row
Renaming a row