What command is used to add new rows to a table?

SQL Data Manipulation Commands Quiz

Quiz
•
Information Technology (IT)
•
University
•
Hard
Benhar undefined
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
UPDATE
SELECT
INSERT INTO
DELETE
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL command retrieves values from a table?
SELECT
INSERT
UPDATE
DELETE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the DISTINCT operator do in a SELECT statement?
Retrieves values in order
Retrieves values with conditions
Retrieves unique values
Retrieves all values
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL clause is used to filter records based on a condition?
ORDER BY
WHERE
DISTINCT
LIKE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the IS NULL operator in SQL?
To sort records
To retrieve all records
To check if a field is not empty
To check if a field is empty
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How would you select all students in sections IT101, IT102, and IT103?
SELECT * FROM Students WHERE Section BETWEEN 'IT101' AND 'IT103'
SELECT * FROM Students WHERE Section LIKE 'IT10%'
SELECT * FROM Students WHERE Section IN ('IT101', 'IT102', 'IT103')
SELECT * FROM Students WHERE Section = 'IT101' OR Section = 'IT102' OR Section = 'IT103'
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What SQL command would you use to modify existing records?
SELECT
UPDATE
DELETE
INSERT
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
UPN_GBD_S7

Quiz
•
12th Grade - University
15 questions
SQL SELECT Statement Quiz

Quiz
•
University
10 questions
SBD QUIZ#13

Quiz
•
University
10 questions
SQL PRE-ASSESSMENT (MOTIVATION)

Quiz
•
University
13 questions
Uji Pemahaman Basis Data

Quiz
•
University
14 questions
Introduction to Databases Quiz

Quiz
•
10th Grade - University
15 questions
Fundamentos de Bases de Datos

Quiz
•
10th Grade - University
11 questions
СУБД

Quiz
•
University
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade