Microsoft Exam DP-900 Topic 3 Question 77 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 77
Topic #: 3

[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 Fernanda at Mar 21, 2024, 10:06 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Alyce

4 days ago

Haha, yeah, they should have mixed in a DCL statement just to see who's really paying attention. But hey, at least they're not asking us to write a stored procedure from scratch. That would be pure evil.

upvoted 0 times

...

Emmett

5 days ago

Yup, no doubt about it. DML all the way. Although, I have to say, I'm a bit disappointed they didn't throw in a tricky one like 'GRANT' or 'REVOKE' to really keep us on our toes.

upvoted 0 times

...

Ivory

6 days ago

I agree, C is the correct answer. These SQL statements are all about modifying the actual data, not the database structure or user permissions. Easy peasy!

upvoted 0 times

...

Jill

7 days ago

This is a pretty straightforward question. I think the answer is clearly C) Data Manipulation Language (DML). SELECT, INSERT, and UPDATE are all used to manipulate data within a database.

upvoted 0 times

...