Which of the following is an example of a Data Manipulation Language statement?

Prepare for success in your database systems exam with our comprehensive study tools. Use flashcards and multiple choice questions, with detailed hints and explanations. Ace your exam with confidence!

Multiple Choice

Which of the following is an example of a Data Manipulation Language statement?

Explanation:
Data Manipulation Language statements are used to change the data stored in tables, not the structure of the database. Inserting a new row is a quintessential DML operation because it adds data to a table. For example, INSERT INTO employees (id, name) VALUES (1, 'Alice') adds a new record to the employees table. The other options deal with schema or access control: CREATE defines a new table or object, DROP removes an object, and GRANT assigns privileges. These are not about manipulating the actual data, so they are not DML.

Data Manipulation Language statements are used to change the data stored in tables, not the structure of the database. Inserting a new row is a quintessential DML operation because it adds data to a table. For example, INSERT INTO employees (id, name) VALUES (1, 'Alice') adds a new record to the employees table.

The other options deal with schema or access control: CREATE defines a new table or object, DROP removes an object, and GRANT assigns privileges. These are not about manipulating the actual data, so they are not DML.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy