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

Study for the Database Systems Test. Prepare with flashcards and multiple choice questions, each with hints and explanations. Get ready for success!

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 Passetra

You can unsubscribe at any time. Read our privacy policy