Microsoft Exam DP-900 Topic 11 Question 79 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 79
Topic #: 11

[All DP-900 Questions]

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

AData Definition Language (DDL)

BData Control Language (DCL)

CData Manipulation Language (DML)

Show Suggested Answer

Suggested Answer: C

by Brice at Apr 22, 2024, 04:09 AM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Mitzie

6 months ago

I think we can confidently say that SELECT, INSERT, and UPDATE fall under Data Manipulation Language (DML) based on how they are used in SQL queries.

upvoted 0 times

...

Mayra

6 months ago

I believe it's Data Manipulation Language (DML) too. It makes sense since SELECT, INSERT, and UPDATE deal with manipulating the data itself.

upvoted 0 times

...

Hildegarde

6 months ago

I don't think so. DDL is used to define the structure of the database, like creating tables and indexes.

upvoted 0 times

...

Dustin

7 months ago

But aren't those statements also used to define the structure of the database? Could it be Data Definition Language (DDL)?

upvoted 0 times

...

Annmarie

7 months ago

I agree, DML is used to retrieve, insert, and modify data in a database.

upvoted 0 times

...

Donte

7 months ago

I think SELECT, INSERT, and UPDATE are examples of Data Manipulation Language (DML). They manipulate the data in the database.

upvoted 0 times

...

Lashawn

8 months ago

It's important to know the different types of SQL statements for managing databases efficiently.

upvoted 0 times

...

Marguerita

8 months ago

I remember learning about DML in my database management class.

upvoted 0 times

...

Lashawn

8 months ago

That's correct. Those statements are used to manipulate data in a database.

upvoted 0 times

...

Marguerita

8 months ago

C) Data Manipulation Language (DML)

upvoted 0 times

Tess

8 months ago

UPDATE falls under Data Manipulation Language (DML) as well.

upvoted 0 times

...

Gerardo

8 months ago

INSERT is also part of Data Manipulation Language (DML).

upvoted 0 times

...

Ivory

8 months ago

SELECT is an example of Data Manipulation Language (DML).

upvoted 0 times

...