elect the correct answerWhich one is not Data Manipulation Language Statement?OptionsDELETEUPDATETRUNCATEINSERTSELECT

Break Down the Problem

1. Identify the category of SQL statements related to Data Manipulation Language (DML).
2. Evaluate each option to determine if it falls under DML or not.

Relevant Concepts

• Data Manipulation Language (DML) includes SQL statements that are used to manage data within schema objects. Common DML statements include:
  • INSERT: Adds new records.
  • UPDATE: Modifies existing records.
  • DELETE: Removes records.
  • SELECT: Retrieves data from the database.

Analysis and Detail

1. DELETE: This statement is used to remove existing records from a table. Thus, it is a DML statement.
2. UPDATE: This statement modifies existing records in a table. Hence, it is a DML statement.
3. TRUNCATE: Although it is used to remove records from a table, it is a Data Definition Language (DDL) statement because it does not log individual row deletions and resets identity columns.
4. INSERT: This statement is used to add new records. It is a DML statement.
5. SELECT: This statement retrieves information from the database. It is a DML statement.

Verify and Summarize

Among the given options, TRUNCATE is not a Data Manipulation Language statement as it is categorized under Data Definition Language.

Final Answer

TRUNCATE is the correct answer as it is not a Data Manipulation Language statement.