Multiple choice technology

Which of the following is Data Definition Language?

  1. INSERT

  2. DELETE

  3. UPDATE

  4. CREATE

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data Definition Language (DDL) commands define database structures like tables, indexes, and schemas. CREATE is a DDL command used to create database objects. INSERT, DELETE, and UPDATE are Data Manipulation Language (DML) commands that manipulate data within existing structures.

AI explanation

To answer this question, you need to understand the different types of SQL commands.

Option A) INSERT - This option is incorrect because INSERT is a Data Manipulation Language (DML) command used to insert new rows into a table.

Option B) DELETE - This option is incorrect because DELETE is a DML command used to delete existing rows from a table.

Option C) UPDATE - This option is incorrect because UPDATE is a DML command used to modify existing rows in a table.

Option D) CREATE - This option is correct because CREATE is a Data Definition Language (DDL) command used to create new database objects, such as tables, views, indexes, and schemas.

The correct answer is D) CREATE. This option is correct because CREATE is a DDL command used to define or create database objects.