
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
1.
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'?
2.
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?
3.
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?
4.
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 VALUES (NULL, 'Notebook', 15.99, 100);
5.
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');
6.
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');
7.
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?
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
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
33 questions
Excel - Lesson 12
Quiz
•
9th - 12th Grade
25 questions
Microsoft Word Test
Quiz
•
6th - 12th Grade
26 questions
Entrepreneurship
Quiz
•
4th Grade - Professio...
25 questions
HTML
Quiz
•
5th Grade - Professio...
25 questions
Year 9 Hardware Assessment
Quiz
•
9th Grade
25 questions
Simple Machines
Quiz
•
KG - University
26 questions
Chapter 1 - Types and Components of Computer System
Quiz
•
9th - 11th Grade
25 questions
2.3 Robust Programs
Quiz
•
9th - 11th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade