Search Header Logo

SQL DML Quiz

Authored by John Ulakovich

Information Technology (IT)

University

Used 4+ times

SQL DML Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the acronym DML stand for?

Data Modeling Language

Data Management Language

Data Manipulation Language

Data Markup Language

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement is used to add new rows to a table?

UPDATE

DELETE

INSERT

CREATE

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens if the number of columns listed in an INSERT statement does not match the number of values provided?

The extra columns will be ignored

The database will assign default values

An error will occur

The values will be filled in randomly

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement is used to change the data within an existing row?

ALTER

UPDATE

DELETE

INSERT

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In an INSERT INTO statement, which of the following is not a valid method of inserting rows?

ALTER

UPDATE

DELETE

INSERT

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following allows you to remove rows from a table in SQL?

DELETE

UPDATE

INSERT

SELECT

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens when you use the DELETE statement without a WHERE clause?

No rows are deleted

All rows are deleted

Only the first row is deleted

The command will produce an error

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?