You are working with a table Orders that has a column OrderDate with a default value set to the current date. Which command correctly inserts a new order with default OrderDate?

INSERT INTO Orders (OrderDate) VALUES (DEFAULT);

INSERT INTO Orders SET OrderDate = DEFAULT;

INSERT INTO Orders (OrderDate) VALUES (CURRENT_DATE);

INSERT INTO Orders (OrderDate) VALUES (NOW());

A table Products has columns ProductID, ProductName, and Price. Which statement correctly inserts a product with a price of 0?

INSERT INTO Products (ProductID, ProductName, Price) VALUES (1, 'Sample Product', 0);

INSERT INTO Products (ProductID, ProductName) VALUES (1, 'Sample Product');

INSERT INTO Products (ProductID, ProductName, Price) VALUES (1, 'Sample Product', 10);

INSERT INTO Products VALUES (1, 'Sample Product', 0, 'Extra Column');

You have a table Students with columns StudentID, FirstName, LastName, and Grade. If you want to insert a student named "Emily Clark" with a grade of 85, what is the correct SQL command assuming StudentID is auto-incremented?

INSERT INTO Students (FirstName, LastName, Grade) VALUES ('Emily', 'Clark', 85);

INSERT INTO Students (FirstName, LastName) VALUES ('Emily', 'Clark');

INSERT INTO Students (StudentID, FirstName, LastName, Grade) VALUES (1, 'Emily', 'Clark', 85);

INSERT INTO Students (FirstName, LastName, Grade) VALUES ('Clark', 'Emily', 85);

You are tasked with updating the salary of employees in the "Employees" table. The condition is that only employees in the "IT" department should have their salaries increased by 10%. Which query would you use?

UPDATE Employees SET salary = salary * 1.10 WHERE department = 'IT';

UPDATE Employees SET salary = salary * 1.10 WHERE department = 'Finance';

UPDATE Employees SET salary = salary * 1.05 WHERE department = 'HR';

UPDATE Employees SET salary = salary + 1000 WHERE department = 'IT';

What will be the result after executing the following SQL query? UPDATE Products SET Price = Price - 5 WHERE Price > 50;

Prices of products greater than 50 will be reduced by 5.

Prices of all products will be increased by 5.

Only products with a price of exactly 50 will be updated.

No products will be affected by the query.

A student wants to correct a typo in the "Courses" table. The course name "Intoduction to SQL" should be updated to "Introduction to SQL." Which query is correct?

UPDATE Courses SET course_name = 'Introduction to SQL' WHERE course_name = 'Intoduction to SQL';

UPDATE Courses SET course_name = 'SQL Introduction' WHERE course_name = 'Intoduction to SQL';

UPDATE Courses SET course_name = 'Introduction to SQL' WHERE course_id = 1;

UPDATE Courses SET course_name = 'Introduction to SQL' WHERE course_name LIKE '%Intoduction%';

You mistakenly set the "Status" column in the "Orders" table to 'Pending' for all rows. Now, you want to revert only orders placed on '2025-01-01' to 'Completed.' Which query achieves this?

UPDATE Orders SET Status = 'Completed' WHERE OrderDate = '2025-01-01';

UPDATE Orders SET Status = 'Pending' WHERE OrderDate = '2025-01-01';

UPDATE Orders SET Status = 'Completed' WHERE OrderDate < '2025-01-01';

UPDATE Orders SET Status = 'Completed' WHERE OrderDate = '2025-01-02';

You are asked to reduce the quantity of a product by 50 units in the "Inventory" table where the ProductID is 'P123'. Which query would you use?

UPDATE Inventory SET Quantity = Quantity - 50 WHERE ProductID = 'P123';

INSERT INTO Inventory (ProductID, Quantity) VALUES ('P123', 50);

DELETE FROM Inventory WHERE ProductID = 'P123';

SELECT * FROM Inventory WHERE ProductID = 'P123';

After executing the following query, what happens if no rows match the condition in the WHERE clause? UPDATE Employees SET Department = 'Sales' WHERE Department = 'Marketing' AND Salary > 100000;

All rows are updated to 'Sales'.

Only rows with a Salary less than 100000 are updated.

An error is thrown due to no matching rows.

You need to reset the discount percentage for all products in the "Products" table to 0, but only if their current discount is greater than 20%. Which query achieves this?

UPDATE Products SET discount_percentage = 0 WHERE discount_percentage > 20;

UPDATE Products SET discount_percentage = 0 WHERE discount_percentage < 20;

UPDATE Products SET discount_percentage = 0;

UPDATE Products SET discount_percentage = discount_percentage - 20 WHERE discount_percentage > 20;

You want to update multiple columns in the "Employees" table. The "Title" should be 'Manager' and the "Salary" should increase by 20% for employees in the 'HR' department. Which query is correct?

UPDATE Employees SET Title = 'Manager', Salary = Salary * 1.2 WHERE Department = 'HR';

UPDATE Employees SET Title = 'HR Manager', Salary = Salary + 5000 WHERE Department = 'HR';

UPDATE Employees SET Salary = Salary * 1.2 WHERE Title = 'Manager';

UPDATE Employees SET Title = 'Manager' WHERE Department = 'HR';

A user accidentally updated the "Orders" table without using a WHERE clause, setting the "OrderStatus" of all rows to 'Canceled'. What would be the best way to prevent this mistake in the future?

Implement database triggers or stored procedures that enforce the use of a WHERE clause for updates.

Allow all updates without restrictions

Remove the ability to update the 'Orders' table

Implement a daily backup of the database

You are managing a database for a university. The "Students" table contains a column named "ScholarshipStatus," which you need to update. A new policy grants all students with a GPA above 3.5 the status "Eligible." After executing the appropriate query, what steps should you take to ensure the update was successful?

Run a SELECT statement to verify that all students with a GPA above 3.5 now have "Eligible" in the "ScholarshipStatus" column.

Run an UPDATE query to change all records to 'Ineligible'.

Delete the 'ScholarshipStatus' column from the table.

Create a new table for students with a GPA above 3.5.

You are managing a database table named Employees. The table has the following columns: EmployeeID, FirstName, LastName, Department, and Salary. You want to retrieve the first name and last name of employees who work in the "IT" department. Which query should you use?

SELECT FirstName, LastName FROM Employees WHERE Department = 'IT';

SELECT FirstName, LastName FROM Employees WHERE Department = 'HR';

SELECT FirstName, LastName, Department FROM Employees;

SELECT * FROM Employees WHERE Department = 'IT';

You have a table named Sales with columns OrderID, ProductID, Quantity, and TotalAmount. You want to find the total sales amount across all orders. Which query should you use?

SELECT SUM(TotalAmount) FROM Sales;

SELECT COUNT(TotalAmount) FROM Sales;

SELECT AVG(TotalAmount) FROM Sales;

SELECT TotalAmount FROM Sales WHERE OrderID = 1;

You have a table named Products with columns ProductID, ProductName, Category, and Price. You want to list all products sorted by their price in descending order. Which query should you use?

SELECT * FROM Products ORDER BY Price DESC;

SELECT ProductName, Price FROM Products ORDER BY Category ASC;

SELECT * FROM Products ORDER BY ProductName;

SELECT * FROM Products WHERE Price > 100;

You want to retrieve the columns FirstName and LastName from a table named Employees. What is the purpose of the SELECT statement in SQL?

The purpose of the SELECT statement is to retrieve specific columns from a table.

The SELECT statement is used to create a new table in the database.

The SELECT statement is used to update existing records in a table.

The SELECT statement is used to delete records from a table.

A table named Orders contains data about various customer orders. To retrieve orders with an OrderAmount greater than $500, what does the WHERE clause do?

The WHERE clause filters orders to include only those with an OrderAmount greater than $500.

The WHERE clause groups orders by customer name.

The WHERE clause sorts the orders by OrderAmount in descending order.

The WHERE clause retrieves all orders regardless of the OrderAmount.

You need to remove all rows from a table named Orders without deleting the table itself. Which statement correctly describes what the DELETE query does in this scenario?

The DELETE query removes all rows from the Orders table without deleting the table itself.

The DELETE query removes the Orders table entirely.

The DELETE query only removes specific columns from the Orders table.

The DELETE query creates a backup of the Orders table before removing rows.

You have a table named Employees with columns EmployeeID, Name, and Department. You want to remove employees who belong to the "Finance" department. What is the purpose of using the WHERE clause in a DELETE query?

To filter which records to delete based on specific conditions.

To specify the columns to be deleted.

To determine the order of deletion.

To limit the number of records deleted.

You accidentally execute the following query on the Products table: DELETE FROM Products; What is the result of running this query?

All records in the Products table will be deleted.

The Products table will be emptied but remain intact.

The query will prompt for confirmation before deleting records.

Only some records in the Products table will be deleted.

You want to delete specific rows from the Inventory table but need to confirm which rows will be deleted first. How can you preview the rows that match the condition in the DELETE query?

Use a SELECT statement with the same WHERE clause as the DELETE query.

Run an UPDATE query with the same WHERE clause.

Execute a TRUNCATE command on the Inventory table.

Use a JOIN statement to combine with another table.

COMP9. DATA MANIPULATION LANGUAGE

Authored by Michael Atienza

Computers

9th Grade

Used 6+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 2 pts

You have a table Employees with columns EmployeeID, FirstName, LastName, and Position. How would you insert a new employee with the following details: EmployeeID = 101, FirstName = 'John', LastName = 'Doe', Position = 'Manager'?

INSERT INTO Employees (EmployeeID, FirstName, LastName, Position) VALUES (101, 'John', 'Doe', 'Manager');

SELECT * FROM Employees WHERE EmployeeID = 101;

DELETE FROM Employees WHERE EmployeeID = 101;

UPDATE Employees SET FirstName = 'John' WHERE EmployeeID = 101;

MULTIPLE CHOICE QUESTION

1 min • 2 pts

If a table Orders has columns OrderID, ProductName, and Quantity and you only want to insert a value for ProductName and Quantity, which command is correct?

INSERT INTO Orders (OrderID, ProductName) VALUES (1, 'ProductA');

INSERT INTO Orders (Quantity) VALUES (10);

INSERT INTO Orders (ProductName, Quantity) VALUES ('ProductA', 10);

INSERT INTO Orders (ProductName) VALUES ('ProductA', 10);

MULTIPLE CHOICE QUESTION

1 min • 2 pts

What happens if you execute the following command and the StudentID column in the Students table is set to auto-increment?

The StudentID will be set to a random value.

The StudentID will reset to zero.

The StudentID will remain unchanged.

The StudentID will automatically increment to the next available value.

MULTIPLE SELECT QUESTION

1 min • 2 pts

You have a table Products with columns ProductID, ProductName, Price, and Stock. Which of the following statements would add a new product named "Notebook" with a price of 15.99 and stock of 100?

INSERT INTO Products (ProductName, Price, Stock) VALUES ('Notebook', 15.99, 100);

INSERT INTO Products VALUES (NULL, 'Notebook', 15.99, 100);

DELETE FROM Products WHERE ProductName = 'Notebook';

UPDATE Products SET Price = 15.99 WHERE ProductName = 'Notebook';

MULTIPLE CHOICE QUESTION

1 min • 2 pts

What would happen if you attempt to execute the following command on a table where EmployeeID is the primary key and already contains the value 201?
INSERT INTO Employees (EmployeeID, FirstName, LastName) VALUES (201, 'Jake', 'Brown');

The insertion will fail due to a primary key constraint violation.

The command will create a duplicate entry without any error.

The command will update the existing record with EmployeeID 201.

The insertion will succeed and add a new record.

MULTIPLE CHOICE QUESTION

1 min • 2 pts

You are inserting data into a table with a column that allows NULL values. Which statement will successfully insert a NULL into that column?

INSERT INTO Sales (Product, Price) VALUES ('Pen', NULL);

INSERT INTO Sales (Product, Price) VALUES ('Pen', 'NULL');

INSERT INTO table_name (column_name) VALUES (DEFAULT);

INSERT INTO table_name (column_name) VALUES (0);

MULTIPLE CHOICE QUESTION

1 min • 2 pts

You have a table Customers with columns CustomerID, Name, and Email. If you want to add a new customer with only their Name and Email, leaving CustomerID to be auto-generated, which command should you use?

UPDATE Customers SET Name = 'Customer Name', Email = 'customer@example.com' WHERE CustomerID = 1;

SELECT * FROM Customers WHERE Name = 'Customer Name';

DELETE FROM Customers WHERE Name = 'Customer Name';

INSERT INTO Customers (Name, Email) VALUES ('Customer Name', 'customer@example.com');

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

25 questions

Adobe Flash

Quiz

•

9th Grade

34 questions

Multimedia Webpage Design 1.01

Quiz

•

9th - 12th Grade

30 questions

COLOR Theory

Quiz

•

9th - 12th Grade

25 questions

Programming in Python

Quiz

•

9th Grade

26 questions

Macromedia Flash

Quiz

•

8th Grade - Professio...

25 questions

Understanding Strings and Functions Quiz

Quiz

•

8th Grade - University

25 questions

Code.org Quiz1

Quiz

•

7th Grade - University

25 questions

Examen de Redes

Quiz

•

9th Grade

Popular Resources on Wayground

8 questions

2 Step Word Problems

Quiz

•

KG - University

20 questions

Comparing Fractions

Quiz

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

Latin Bases claus(clois,clos, clud, clus) and ped

Quiz

•

6th - 8th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

7 questions

The Story of Books

Quiz

•

6th - 8th Grade

Discover more resources for Computers

10 questions

Mastering Proper Keyboarding Techniques

Interactive video

•

6th - 10th Grade

10 questions

Exploring Cybersecurity Techniques and Threats

Interactive video

•

6th - 10th Grade

COMP9. DATA MANIPULATION LANGUAGE

You have a table Employees with columns EmployeeID, FirstName, LastName, and Position. How would you insert a new employee with the following details: EmployeeID = 101, FirstName = 'John', LastName = 'Doe', Position = 'Manager'?

If a table Orders has columns OrderID, ProductName, and Quantity and you only want to insert a value for ProductName and Quantity, which command is correct?

What happens if you execute the following command and the StudentID column in the Students table is set to auto-increment?

You have a table Products with columns ProductID, ProductName, Price, and Stock. Which of the following statements would add a new product named "Notebook" with a price of 15.99 and stock of 100?

What would happen if you attempt to execute the following command on a table where EmployeeID is the primary key and already contains the value 201?INSERT INTO Employees (EmployeeID, FirstName, LastName) VALUES (201, 'Jake', 'Brown');

You are inserting data into a table with a column that allows NULL values. Which statement will successfully insert a NULL into that column?

You have a table Customers with columns CustomerID, Name, and Email. If you want to add a new customer with only their Name and Email, leaving CustomerID to be auto-generated, which command should you use?

You are working with a table Orders that has a column OrderDate with a default value set to the current date. Which command correctly inserts a new order with default OrderDate?

A table Products has columns ProductID, ProductName, and Price. Which statement correctly inserts a product with a price of 0?

You have a table Students with columns StudentID, FirstName, LastName, and Grade. If you want to insert a student named "Emily Clark" with a grade of 85, what is the correct SQL command assuming StudentID is auto-incremented?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

What would happen if you attempt to execute the following command on a table where EmployeeID is the primary key and already contains the value 201?
INSERT INTO Employees (EmployeeID, FirstName, LastName) VALUES (201, 'Jake', 'Brown');