Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which of the following is an example of a Data Definition Language (DDL) command ?

  • A.SELECT
  • B.INSERT
  • C.CREATE
  • D.UPDATE

Answer: C

The DDL command is CREATE.

Data Definition Language commands define and change the structure of database objects: CREATE, ALTER, DROP, TRUNCATE and RENAME.

SELECT, INSERT and UPDATE work on the data inside tables, so they are Data Manipulation Language (DML) commands (SELECT is sometimes classed as DQL).

DDL changes are usually auto-committed, so they cannot be rolled back the way DML changes can in a transaction.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.