Which of the following are DML statements?Select one or more:a.INSERTb.CREATEc.SELECTd.TRUNCATE

Step 1: Break Down the Problem

We need to identify which statements are Data Manipulation Language (DML) statements from the given options.

Step 2: Relevant Concepts

DML statements are used to manipulate data in a database. The most common DML commands are:

• INSERT: Adds new records to a table.
• SELECT: Retrieves data from a table.
• UPDATE: Modifies existing records.
• DELETE: Removes records from a table.

Step 3: Analysis and Detail

Let's evaluate the options one by one:

1. INSERT: This is a DML statement as it adds new records to a database.
2. CREATE: This is a Data Definition Language (DDL) statement as it defines a database structure (tables, schemas, etc.).
3. SELECT: This is a DML statement because it is used to retrieve data from a database.
4. TRUNCATE: This is categorized as a DDL statement since it removes all records from a table, but does not log the individual row deletions.

Step 4: Verify and Summarize

From the analysis, we find that:

• DML statements from the options are: INSERT and SELECT.
• CREATE and TRUNCATE are not DML statements.

Final Answer

The DML statements are: a. INSERT and c. SELECT.