Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- 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?

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

Jenifer

8 months ago

I always mix those up, thanks for clarifying!

upvoted 0 times

...

Salome

8 months ago

DML for sure, no doubt about it!

upvoted 0 times

...

Marylyn

8 months ago

Wait, are you sure? I thought they were DDL.

upvoted 0 times

...

Melodie

8 months ago

Yup, totally agree with that.

upvoted 0 times

...

Santos

9 months ago

They're definitely DML statements!

upvoted 0 times

...

Glory

9 months ago

I might be mixing things up, but I thought DCL was about permissions and security, not data manipulation.

upvoted 0 times

...

Rebecka

9 months ago

I'm not entirely sure, but I think DML sounds right since it deals with data operations.

upvoted 0 times

...

Cordelia

9 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

9 months ago

I think SELECT, INSERT, and UPDATE are related to how we manipulate data, so maybe it's DML?

upvoted 0 times

...

Rachael

9 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

9 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

9 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

10 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

10 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

10 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

10 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

...

...