SQL Data Manipulation Commands Quiz

SQL Data Manipulation Commands Quiz

University

10 Qs

quiz-placeholder

Similar activities

Repaso ADO.NET

Repaso ADO.NET

University

10 Qs

NoSQL Concepts 2

NoSQL Concepts 2

University

10 Qs

SQL DML Quiz

SQL DML Quiz

University

15 Qs

SQL PRE-ASSESSMENT (MOTIVATION)

SQL PRE-ASSESSMENT (MOTIVATION)

University

10 Qs

Evaluación de MySQL

Evaluación de MySQL

University

10 Qs

Fundamentos de Bases de Datos

Fundamentos de Bases de Datos

10th Grade - University

15 Qs

Understanding Database Triggers

Understanding Database Triggers

University

10 Qs

SQL Data Manipulation Commands Quiz

SQL Data Manipulation Commands Quiz

Assessment

Quiz

Information Technology (IT)

University

Hard

Created by

Benhar undefined

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?