SQL Assessment 2

What does the acronym CRUD stand for in the context of database operations?

• Copy, Run, Update, Dump

• Calculate, Round, Unite, Divide

• Create, Read, Update, Delete

• Connect, Retrieve, Upload, Disconnect

A user runs a query to view a list of all employees in the 'Sales' department. Which CRUD operation are they performing?

• Create

• Read

• Update

• Delete

Which SQL command is used to add a new row to a table?

• ADD

• INSERT

• NEW

• CREATE

What is the purpose of the UPDATE statement?

• To remove a table from the database.

• To change the data in existing rows of a table.

• To add a new column to an existing table.

• To retrieve data from the database.

Which of the following SQL statements would permanently remove a specific customer record from a 'Customers' table?

• DELETE FROM Customers WHERE CustomerID = 123;

• REMOVE FROM Customers WHERE CustomerID = 123;

• UPDATE Customers SET Status = 'Inactive' WHERE CustomerID = 123;

• DROP Customers WHERE CustomerID = 123;

You need to add a new product called 'Wireless Mouse' with a price of $25.99 to the 'Inventory' table. Which statement would you use?

• INSERT INTO Inventory (ProductName, Price) VALUES ('Wireless Mouse', 25.99);

• ADD TO Inventory (ProductName, Price) VALUES ('Wireless Mouse', 25.99);

• UPDATE Inventory SET ProductName = 'Wireless Mouse', Price = 25.99;

• INSERT ROW INTO Inventory VALUES ('Wireless Mouse', 25.99);

A common mistake when performing an UPDATE or DELETE operation is forgetting to include which clause, potentially affecting all rows in the table?

• THE ORDER BY clause

• THE LIMIT clause

• THE WHERE clause

• THE GROUP BY clause

Which CRUD operation is represented by the SELECT statement in SQL?

• Create

• Read

• Update

• Delete

• Use SELECT to find the book, then use INSERT to change the price.

• Use an UPDATE statement with a WHERE clause to target the specific book.

• Use DELETE to remove the old row and INSERT to add a new one with the correct price.

• Use ALTER TABLE to modify the price column.

After a company merges with another, you need to add several new employees to your database from a list. You are performing a:

• Read operation

• Delete operation

• Update operation

• Create operation