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
C
Cripstwick
Community Contributor
Quizzes Created: 636 | Total Attempts: 839,615
| Attempts: 256
SettingsSettings
Please wait...
  • 1/10 Questions

    Which of these commands adds one or more records to a database?

    • Insert
    • Delete
    • Vector
    • Update
Please wait...
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

Quiz Preview

  • 2. 
    Which of the following SQL statements is used to retrieve and manipulate data? - ProProfs

    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?  - ProProfs

    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? - ProProfs

    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. - ProProfs

    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?  - ProProfs

    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... - ProProfs

    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. - ProProfs

    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... - ProProfs

    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? - ProProfs

    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:

Quiz Review Timeline (Updated): Sep 1, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Sep 01, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 17, 2017
    Quiz Created by
    Cripstwick
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.