New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft DP-900 Exam - 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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

0/2000 characters
Jenifer
3 months ago
I always mix those up, thanks for clarifying!
upvoted 0 times
...
Salome
4 months ago
DML for sure, no doubt about it!
upvoted 0 times
...
Marylyn
4 months ago
Wait, are you sure? I thought they were DDL.
upvoted 0 times
...
Melodie
4 months ago
Yup, totally agree with that.
upvoted 0 times
...
Santos
4 months ago
They're definitely DML statements!
upvoted 0 times
...
Glory
4 months ago
I might be mixing things up, but I thought DCL was about permissions and security, not data manipulation.
upvoted 0 times
...
Rebecka
5 months ago
I'm not entirely sure, but I think DML sounds right since it deals with data operations.
upvoted 0 times
...
Cordelia
5 months ago
I remember practicing a question about SQL statements, and I feel like DDL was more about creating tables, not manipulating data.
upvoted 0 times
...
Alverta
5 months ago
I think SELECT, INSERT, and UPDATE are related to how we manipulate data, so maybe it's DML?
upvoted 0 times
...
Rachael
5 months ago
I'm a little confused here. I thought DML was just for data manipulation, but SELECT seems more like a query than a manipulation. Maybe I'm overthinking this. I'll just go with my gut and choose C.
upvoted 0 times
...
Ashlee
5 months ago
Okay, I've got this. SELECT, INSERT, and UPDATE are all DML statements used for querying and modifying data in a database. The other options, DDL and DCL, are for defining the database structure and controlling user access, respectively.
upvoted 0 times
...
Raelene
5 months ago
Hmm, I'm a bit unsure about this one. I know DML is used for manipulating data, but I can't remember if that includes things like SELECT. Let me think this through...
upvoted 0 times
...
Gracie
5 months ago
I'm pretty confident that this is a DML (Data Manipulation Language) question. The keywords SELECT, INSERT, and UPDATE are all part of the DML.
upvoted 0 times
...
Stephen
5 months ago
This seems like a straightforward question about the key skills needed for the Senior Manufacturing Manager/Director role. I'm pretty confident I can figure this out.
upvoted 0 times
...
Xuan
5 months ago
This is a tricky one. I'm not super familiar with XQuery, so I'll need to take my time and really understand the question and the example data before selecting an answer. Hopefully I can eliminate a few of the choices to narrow it down.
upvoted 0 times
...
Steffanie
5 months ago
Option D stands out to me as the most logical approach. Obtaining buy-in from business units through communication is crucial for successful security control implementation.
upvoted 0 times
...
Kenneth
2 years ago
Hmm, that makes sense too. So it could be DDL as well.
upvoted 0 times
...
Cletus
2 years ago
Actually, I believe they are part of Data Definition Language (DDL) because they define the structure of the database.
upvoted 0 times
...
Dean
2 years ago
I agree with Kenneth, those statements are used to manipulate data in the database.
upvoted 0 times
...
Kenneth
2 years ago
I think SELECT, INSERT, and UPDATE are examples of Data Manipulation Language (DML).
upvoted 0 times
...
Alyce
2 years 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
2 years 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
2 years 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
2 years 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
Carlee
2 years ago
Good discussion on SQL statements and their purposes.
upvoted 0 times
...
Lasandra
2 years ago
Exactly, DDL is for defining and changing the structure of database objects.
upvoted 0 times
...
Luther
2 years ago
So, DML is mainly for manipulating data and DDL is for structure changes.
upvoted 0 times
...
Evette
2 years ago
It's important to understand the different types of SQL statements.
upvoted 0 times
...
Casandra
2 years ago
This is a basic concept in SQL.
upvoted 0 times
...
Zona
2 years ago
Yes, DML is used for manipulating data in a database.
upvoted 0 times
...
Jesusa
2 years ago
I agree, they are indeed examples of Data Manipulation Language (DML).
upvoted 0 times
...
...

Save Cancel