What Do You Know About Data Definition Language? Take This Quiz To Find Out More About Ddl.

10 Questions | Total Attempts: 150

SettingsSettingsSettings
Please wait...
What Do You Know About Data Definition Language? Take This Quiz To Find Out More About Ddl.

A data definition language (DDL), sometimes called data description language, is a syntax for defining data structures, especially database schemas. Take this quiz to find out more about DDL.


Questions and Answers
  • 1. 
    Which DDL statement creates a new object?
    • A. 

      Create

    • B. 

      Object

    • C. 

      Vector

    • D. 

      Statement

  • 2. 
    The DROP statement ___ an object.
    • A. 

      Creates

    • B. 

      Destroys

    • C. 

      Deletes

    • D. 

      Moves

  • 3. 
    In order to modify an existing database object, we use the ___ statement.
    • A. 

      Move

    • B. 

      Object

    • C. 

      Alter

    • D. 

      Change

  • 4. 
    This command "ALTER TABLE sink ADD bubbles INTEGER;" adds a...
    • A. 

      Column

    • B. 

      Object

    • C. 

      Vector

    • D. 

      Color

  • 5. 
    All of the following are DDL statements except...
    • A. 

      Rename

    • B. 

      Create

    • C. 

      Alter

    • D. 

      Object

  • 6. 
    Which of these statements begins with alter?
    • A. 

      Rename

    • B. 

      Revoke

    • C. 

      Audit

    • D. 

      Purge

  • 7. 
    Data definition language lets you create and alter ___ objects.
    • A. 

      Rastar

    • B. 

      Vector

    • C. 

      Statement

    • D. 

      Schema

  • 8. 
    Which of these statements requires an exclusive access to a specified object?
    • A. 

      GRANT

    • B. 

      CREATE

    • C. 

      REVOKE

    • D. 

      ANALYZE

  • 9. 
    Which of these SQL statements can be used to grant or revoke privileges?
    • A. 

      PHP

    • B. 

      DCL

    • C. 

      DDL

    • D. 

      DML

  • 10. 
    The rename statement is used to ___ an object.
    • A. 

      Rename

    • B. 

      Destroy

    • C. 

      Clean

    • D. 

      Drop

Back to Top Back to top