What Do You Know About Data Manipulation Language?

10 Questions | Total Attempts: 199

SettingsSettingsSettings
Please wait...
What Do You Know About Data Manipulation Language?

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.


Questions and Answers
  • 1. 
    Which of the following SQL statements is used to retrieve and manipulate data?
    • A. 

      TCL

    • B. 

      DML

    • C. 

      DDL

    • D. 

      DCL

  • 2. 
    Which of these DML commands is used to retrieve rows from a table?
    • A. 

      Select

    • B. 

      Retrieve

    • C. 

      Commit

    • D. 

      Save point

  • 3. 
    This command modifies one or more data.
    • A. 

      Select

    • B. 

      Modify

    • C. 

      Update

    • D. 

      Change

  • 4. 
    Which of these commands adds one or more records to a database?
    • A. 

      Insert

    • B. 

      Delete

    • C. 

      Vector

    • D. 

      Update

  • 5. 
    The SELECT statement embedded within another SELECT statement is called...
    • A. 

      Subject

    • B. 

      Data

    • C. 

      Sublet

    • D. 

      Subselect

  • 6. 
    The ____ command removes one or more record from the database.
    • A. 

      Delete

    • B. 

      Remove

    • C. 

      Vector

    • D. 

      Select

  • 7. 
    Which of these statements is a limited DML statement?
    • A. 

      Delete

    • B. 

      Insert

    • C. 

      Select

    • D. 

      Update

  • 8. 
    All of these DML statements are supported fully in PL/SQL except...
    • A. 

      Select

    • B. 

      Call

    • C. 

      Update

    • D. 

      Delete

  • 9. 
    Which of the following is not a DML command? 
    • A. 

      Update

    • B. 

      Select

    • C. 

      Delete

    • D. 

      Drop

  • 10. 
    Which of the following is returned by the MIN function? 
    • A. 

      Minute

    • B. 

      Smallest value

    • C. 

      Vector

    • D. 

      Largest value

Back to Top Back to top