SQL DDL and DML Statement Basics

1. Which clause is used with the INSERT statement to specify which columns to populate?

COLUMNS

FIELDS

INTO

VALUES

Submit

3. Which of the following are DDL statements? (Select all that apply)

CREATE

ALTER

DELETE

DROP

Submit

4. The WHERE clause is typically used with which DML statement to filter rows?

CREATE

DELETE and UPDATE

ALTER

DROP

5. A PRIMARY KEY constraint is defined using which DDL clause?

CONSTRAINT PRIMARY KEY

PRIMARY KEY

UNIQUE PRIMARY

KEY PRIMARY

6. Which DDL statement modifies the structure of an existing table?

CHANGE

MODIFY

ALTER TABLE

UPDATE SCHEMA

7. True or False: INSERT and UPDATE are both considered DML statements.

True

False

Submit

9. Which of the following are DML statements? (Select all that apply)

SELECT

INSERT

UPDATE

DROP

Submit

10. True or False: The TRUNCATE statement is a DDL operation that removes all rows quickly.

True

False

11. Which SQL statement is used to create a new table in a database?

CREATE TABLE

INSERT TABLE

DEFINE TABLE

NEW TABLE

Submit

13. Which statement removes specific rows from a table based on a condition?

REMOVE

ERASE

DELETE

DISCARD

14. True or False: DROP TABLE removes all data but keeps the table structure.

True

False

15. Which DML statement modifies existing data in a table?

MODIFY

CHANGE

UPDATE

EDIT

Submit

17. Which statement is used to add new rows to a table?

ADD ROW

INSERT INTO

APPEND

NEW ROW

18. What is the primary purpose of DML statements?

Define database structure and schema

Manipulate and retrieve data within tables

Control user access permissions

Optimize query performance

19. Which DDL statement is used to remove an entire table from a database?

DELETE

DROP TABLE

TRUNCATE

REMOVE TABLE

20. What does DDL stand for in SQL?

Data Definition Language

Data Deletion Language

Database Design Layout

Dynamic Data Language

DataSys+ SQL DDL and DML Statement Basics Quiz

1. Which clause is used with the INSERT statement to specify which columns to populate?

2.

What first name or nickname would you like us to use?

2. COMMIT and ROLLBACK are classified as ______ statements in SQL.

3. Which of the following are DDL statements? (Select all that apply)

4. The WHERE clause is typically used with which DML statement to filter rows?

5. A PRIMARY KEY constraint is defined using which DDL clause?

6. Which DDL statement modifies the structure of an existing table?

7. True or False: INSERT and UPDATE are both considered DML statements.

8. The RENAME statement in SQL is used to ______ a table or column.

9. Which of the following are DML statements? (Select all that apply)

10. True or False: The TRUNCATE statement is a DDL operation that removes all rows quickly.

11. Which SQL statement is used to create a new table in a database?

12. The CREATE INDEX statement is classified as a ______ statement.

13. Which statement removes specific rows from a table based on a condition?

14. True or False: DROP TABLE removes all data but keeps the table structure.

15. Which DML statement modifies existing data in a table?

16. The ALTER TABLE statement allows you to ______ columns in an existing table.

17. Which statement is used to add new rows to a table?

18. What is the primary purpose of DML statements?

19. Which DDL statement is used to remove an entire table from a database?

20. What does DDL stand for in SQL?