Question: Your database currently has a table called Inventory in the Warehouse schema. You need to move the table to the Products schema. Which query accomplishes this goal?
- `ALTER SCHEMA Products TRANSFER Warehouse.Inventory;`
- `ALTER TABLE Warehouse.Inventory TRANSFER Products.Inventory;`
- `ALTER TABLE Warehouse.Inventory ADD SCHEMA Products;`
- `ALTER SCHEMA Warehouse ADD TABLE Inventory;`
Answer: The correct answer of the above question is Option A:`ALTER SCHEMA Products TRANSFER Warehouse.Inventory;`