Tesco DDL and DML

E mail

Full Name

What is the correct way to rename a table in SQL?

• MODIFY TABLE old_name TO new_name;

• RENAME TABLE old_name TO new_name;

• ALTER TABLE old_name TO new_name;

• CHANGE TABLE old_name TO new_name;

What is the key difference between TRUNCATE TABLE Products; and DELETE FROM Products;?

• TRUNCATE removes only some records, while DELETE removes all records.

• TRUNCATE deletes all records without logging each row deletion, while DELETE logs each deletion.

• DELETE removes table structure and records, while TRUNCATE keeps both

• Both work the same way

Will the following SQL query execute successfully or cause an error?
CREATE TABLE Customers ( CustomerID INT PRIMARY KEY, CustomerName VARCHAR(100));

INSERT INTO Customers (CustomerID, CustomerName) VALUES (101, 'John Doe');
INSERT INTO Customers (CustomerID, CustomerName) VALUES (101, 'John Doe');

• The query will run successfully, inserting both records.

• The query will fail because CustomerID is a PRIMARY KEY and must be unique.

• The query will run, but only one record will be inserted automatically.

• The query will throw an error because INSERT cannot be used twice on the same table.

What is the correct syntax to delete a record from the Orders table where OrderID is 102?

• REMOVE FROM Orders WHERE OrderID = 102;

• DELETE FROM Orders WHERE OrderID = 102;

• DROP Orders WHERE OrderID = 102;

• ERASE FROM Orders WHERE OrderID = 102;

Which statement is true about the ALTER TABLE command?

• ALTER TABLE can be used to delete records from a table.

• ALTER TABLE is used to modify an existing table’s structure.

• ALTER TABLE is used to delete an entire table permanently.

• ALTER TABLE can rename a column but not a table.