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?

  1. `ALTER SCHEMA Products TRANSFER Warehouse.Inventory;`
  2. `ALTER TABLE Warehouse.Inventory TRANSFER Products.Inventory;`
  3. `ALTER TABLE Warehouse.Inventory ADD SCHEMA Products;`
  4. `ALTER SCHEMA Warehouse ADD TABLE Inventory;`

Answer: The correct answer of the above question is Option A:`ALTER SCHEMA Products TRANSFER Warehouse.Inventory;`