What Do You Know About Data Manipulation Language?

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Cripstwick

Cripstwick

Community Contributor

Quizzes Created: 636 | Total Attempts: 828,847

| Attempts: 255

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/10 Questions

Which of these commands adds one or more records to a database?
- Insert
- Delete
- Vector
- Update

About This Quiz

A data manipulation language (or DML) is a family of syntax elements used in a database to select, insert, delete and update data. Take this quiz to find out what you truly know about DML.

What Do You Know About Data Manipulation Language? - Quiz

2.

Which of the following SQL statements is used to retrieve and manipulate data?
- TCL
- DML
- DDL
- DCL
Correct Answer

A. DML

Explanation

DML stands for Data Manipulation Language and is used to retrieve and manipulate data in SQL. It includes statements such as SELECT, INSERT, UPDATE, and DELETE, which are used to query and modify data in a database. DML statements allow users to retrieve specific data from tables, insert new data, update existing data, and delete unwanted data.

Rate this question:
3.

Which of the following is not a DML command?
- Update
- Select
- Delete
- Drop
Correct Answer

A. Drop

Explanation

The DROP command is not a Data Manipulation Language (DML) command. DML commands are used to manipulate data within a database, such as updating, selecting, or deleting records. The DROP command, on the other hand, is a Data Definition Language (DDL) command used to remove objects from the database, such as tables or indexes.

Rate this question:
4.

Which of these DML commands is used to retrieve rows from a table?
- Select
- Retrieve
- Commit
- Save point
Correct Answer

A. Select

Explanation

The correct answer is "select." This DML command is used to retrieve rows from a table. It allows you to specify the columns and conditions to filter the data you want to retrieve. The "retrieve" option is not a valid DML command. "Commit" is used to save changes made to the database, and "save point" is used to mark a specific point in a transaction for rollback purposes.

Rate this question:
5.

The ____ command removes one or more record from the database.
- Delete
- Remove
- Vector
- Select
Correct Answer

A. Delete

Explanation

The "delete" command is used to remove one or more records from the database. This command is commonly used in database management systems to delete specific data entries or entire rows from a table. It allows users to remove unwanted or outdated information from the database, ensuring data integrity and maintaining an accurate and up-to-date database.

Rate this question:
6.

Which of the following is returned by the MIN function?
- Minute
- Smallest value
- Vector
- Largest value
Correct Answer

A. Smallest value

Explanation

The MIN function is used to find the smallest value in a set of values. Therefore, the correct answer is "smallest value".

Rate this question:
7.

All of these DML statements are supported fully in PL/SQL except...
- Select
- Call
- Update
- Delete
Correct Answer

A. Call

Explanation

The SELECT, UPDATE, and DELETE statements are all fully supported in PL/SQL. However, the CALL statement is not supported in PL/SQL. The CALL statement is used to invoke a stored procedure or function in other programming languages such as Java or C#. In PL/SQL, stored procedures and functions are invoked using the EXECUTE statement.

Rate this question:
8.

This command modifies one or more data.
- Select
- Modify
- Update
- Change
Correct Answer

A. Update

Explanation

The command "update" is the correct answer because it is commonly used to modify one or more data in a database. It is specifically designed for making changes to existing data, allowing users to update the values of specific columns or rows in a table. The other options, "select," "modify," and "change," do not specifically indicate the action of modifying data and are not commonly used for this purpose.

Rate this question:
9.

The SELECT statement embedded within another SELECT statement is called...
- Subject
- Data
- Sublet
- Subselect
Correct Answer

A. Subselect

Explanation

A subselect is a SELECT statement that is embedded within another SELECT statement. It is used to retrieve data from one or more tables and is typically used as a subquery within the WHERE or HAVING clause of the outer query. The subselect allows for more complex and specific queries by providing a way to filter and manipulate data before it is returned in the outer query's result set.

Rate this question:
10.

Which of these statements is a limited DML statement?
- Delete
- Insert
- Select
- Update
Correct Answer

A. Select

Explanation

A limited DML statement refers to a statement that does not modify or change data in the database. Among the given options, the "select" statement is the only one that retrieves data from the database without making any changes to it. The "delete," "insert," and "update" statements, on the other hand, are DML statements that respectively remove data, add new data, and modify existing data in the database. Therefore, the correct answer is "select."

Rate this question: