Home > Information Technology > Database > SQL Data Manipulation Language (DML)

24 Questions	Log in			00:00:00

1. What does DML stand for in SQL?

Data Management Language

Data Manipulation Language

Data Modeling Language

Data Query Language

2. Which SQL statement is used to retrieve data from a database?

INSERT

UPDATE

SELECT

DELETE

3. Which SQL statement is used to update existing records in a database?

INSERT

UPDATE

SELECT

DELETE

4. What is the purpose of the SQL DELETE statement?

To create a new table

To retrieve data

To modify table structure

To remove records from a table

5. Which SQL statement is used to insert new records into a table?

INSERT

UPDATE

SELECT

DELETE

6. Which SQL statement is used to retrieve unique values from a column?

DISTINCT

UNIQUE

PRIMARY KEY

INDEX

7. What does the SQL ORDER BY clause do?

Adds a new column to a table

Modifies table structure

Filters rows based on a condition

Sorts query results

8. What is the purpose of the SQL GROUP BY clause?

To create a new table

To filter rows based on a condition

To perform mathematical calculations

To group rows into sets based on one or more columns

9. Which SQL statement is used to join two or more tables based on a related column?

INSERT

JOIN

UPDATE

SELECT

10. What is the result of the following SQL query SELECT COUNT(*) FROM Customers;?

The number of columns in the Customers table

The total number of records in the Customers table

The average value of a specific column in the Customers table

The sum of a specific column in the Customers table

11. What is the purpose of the SQL SUM() function?

To find the average value of a column

To concatenate strings in a column

To calculate the total sum of a numeric column

To count the number of records

12. Which SQL statement is used to change data in an existing table?

ALTER TABLE

MODIFY

CHANGE

UPDATE

13. What is the purpose of the SQL AVG() function?

To find the maximum value of a column

To find the minimum value of a column

To calculate the average value of a numeric column

To count the number of distinct values

14. Which SQL statement is used to delete all records from a table without deleting the table structure?

DROP TABLE

DELETE

TRUNCATE TABLE

REMOVE

15. What is the purpose of the SQL HAVING clause?

To filter rows based on a condition

To group rows into sets

To perform calculations on grouped rows

To join multiple tables

16. Which SQL statement is used to add a new column to an existing table?

CREATE COLUMN

ALTER TABLE

ADD COLUMN

MODIFY TABLE

17. What does the SQL DISTINCT keyword do?

Orders query results in ascending order

Orders query results in descending order

Retrieves unique values from a column

Retrieves all records from a table

18. What is the purpose of the SQL WHERE clause?

To group rows into sets

To filter rows based on a condition

To sort query results

To join multiple tables

19. Which SQL statement is used to create a new table?

INSERT TABLE

ADD TABLE

CREATE TABLE

NEW TABLE

20. What is the purpose of the SQL MAX() function?

To find the minimum value of a column

To count the number of records

To calculate the maximum value of a numeric column

To perform calculations on grouped rows

21. Which SQL statement is used to add a primary key to an existing table?

CREATE PRIMARY KEY

ADD PRIMARY KEY

ALTER TABLE

PRIMARY KEY TABLE

22. What is the purpose of the SQL COUNT() function?

To calculate the total sum of a numeric column

To find the average value of a column

To count the number of records

To retrieve unique values from a column

23. Which SQL statement is used to remove a table from a database?

DELETE TABLE

REMOVE TABLE

DROP TABLE

CLEAR TABLE

24. What is the purpose of the SQL MIN() function?

To calculate the maximum value of a column

To count the number of records

To find the minimum value of a numeric column

To perform calculations on grouped rows

🎁 Claim Rewards

🎁 Login to earn rewards !!!

Please Log in to save and analyze your score

24 uniquely designed questions just for you to evaluate your skills in SQL Data Manipulation Language (DML) quiz. Are you ready to challenge yourself and explore more? Let's get started and see how much you can score out of 24.

Test your SQL Data Manipulation Language (DML) knowledge with 25 multiple-choice questions. Explore SQL operations, queries, and functions

Please feel free to report any corrections if you come across any inaccuracies or errors. Your feedback is valuable in maintaining the accuracy of our content.

Start Quiz

Questions

1. What does DML stand for in SQL?
Answer: Data Manipulation Language
Explanation: DML stands for Data Manipulation Language, which is used to manipulate data stored in a database.Report for correction

2. Which SQL statement is used to retrieve data from a database?
Answer: SELECT
Explanation: The SELECT statement is used to retrieve data from a database.Report for correction

3. Which SQL statement is used to update existing records in a database?
Answer: UPDATE
Explanation: The UPDATE statement is used to update existing records in a database.Report for correction

4. What is the purpose of the SQL DELETE statement?
Answer: To remove records from a table
Explanation: The DELETE statement is used to remove records from a table in a database.Report for correction

5. Which SQL statement is used to insert new records into a table?
Answer: INSERT
Explanation: The INSERT statement is used to insert new records into a table in a database.Report for correction

6. Which SQL statement is used to retrieve unique values from a column?
Answer: DISTINCT
Explanation: The DISTINCT keyword is used to retrieve unique values from a column in a SELECT query.Report for correction

7. What does the SQL ORDER BY clause do?
Answer: Sorts query results
Explanation: The ORDER BY clause is used to sort the query results based on one or more columns.Report for correction

8. What is the purpose of the SQL GROUP BY clause?
Answer: To group rows into sets based on one or more columns
Explanation: The GROUP BY clause is used to group rows into sets based on specified columns.Report for correction

9. Which SQL statement is used to join two or more tables based on a related column?
Answer: JOIN
Explanation: The JOIN statement is used to combine data from two or more tables based on a related column.Report for correction

10. What is the result of the following SQL query SELECT COUNT(*) FROM Customers;?
Answer: The total number of records in the Customers table
Explanation: The COUNT(*) function counts the total number of records in the Customers table.Report for correction

11. What is the purpose of the SQL SUM() function?
Answer: To calculate the total sum of a numeric column
Explanation: The SUM() function is used to calculate the total sum of a numeric column.Report for correction

12. Which SQL statement is used to change data in an existing table?
Answer: UPDATE
Explanation: The UPDATE statement is used to change data in an existing table.Report for correction

13. What is the purpose of the SQL AVG() function?
Answer: To calculate the average value of a numeric column
Explanation: The AVG() function is used to calculate the average value of a numeric column.Report for correction

14. Which SQL statement is used to delete all records from a table without deleting the table structure?
Answer: TRUNCATE TABLE
Explanation: The TRUNCATE TABLE statement is used to delete all records from a table without deleting the table structure.Report for correction

15. What is the purpose of the SQL HAVING clause?
Answer: To perform calculations on grouped rows
Explanation: The HAVING clause is used to filter grouped rows based on specified conditions.Report for correction

16. Which SQL statement is used to add a new column to an existing table?
Answer: ALTER TABLE
Explanation: The ALTER TABLE statement is used to add a new column to an existing table.Report for correction

17. What does the SQL DISTINCT keyword do?
Answer: Retrieves unique values from a column
Explanation: The DISTINCT keyword is used to retrieve unique values from a column in a SELECT query.Report for correction

18. What is the purpose of the SQL WHERE clause?
Answer: To filter rows based on a condition
Explanation: The WHERE clause is used to filter rows in the result set based on a specified condition.Report for correction

19. Which SQL statement is used to create a new table?
Answer: CREATE TABLE
Explanation: The CREATE TABLE statement is used to create a new table in a database.Report for correction

20. What is the purpose of the SQL MAX() function?
Answer: To calculate the maximum value of a numeric column
Explanation: The MAX() function is used to calculate the maximum value of a numeric column.Report for correction

21. Which SQL statement is used to add a primary key to an existing table?
Answer: ADD PRIMARY KEY
Explanation: The ADD PRIMARY KEY statement is used to add a primary key to an existing table.Report for correction

22. What is the purpose of the SQL COUNT() function?
Answer: To count the number of records
Explanation: The COUNT() function is used to count the number of records in a result set.Report for correction

23. Which SQL statement is used to remove a table from a database?
Answer: DROP TABLE
Explanation: The DROP TABLE statement is used to remove a table from a database.Report for correction

24. What is the purpose of the SQL MIN() function?
Answer: To find the minimum value of a numeric column
Explanation: The MIN() function is used to find the minimum value of a numeric column in a database table.Report for correction

Start Quiz

Congratulations!!! You have completed all questions