Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location PL
Mob_nav_barsMENU

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?

Show Suggested Answer Hide 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
Kenneth
6 months ago
Hmm, that makes sense too. So it could be DDL as well.
upvoted 0 times
...
Cletus
7 months ago
Actually, I believe they are part of Data Definition Language (DDL) because they define the structure of the database.
upvoted 0 times
...
Dean
7 months ago
I agree with Kenneth, those statements are used to manipulate data in the database.
upvoted 0 times
...
Kenneth
7 months ago
I think SELECT, INSERT, and UPDATE are examples of Data Manipulation Language (DML).
upvoted 0 times
...
Alyce
8 months 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
8 months 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
8 months 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
8 months 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
7 months ago
Good discussion on SQL statements and their purposes.
upvoted 0 times
...
Lasandra
8 months ago
Exactly, DDL is for defining and changing the structure of database objects.
upvoted 0 times
...
Luther
8 months ago
So, DML is mainly for manipulating data and DDL is for structure changes.
upvoted 0 times
...
Evette
8 months ago
It's important to understand the different types of SQL statements.
upvoted 0 times
...
Casandra
8 months ago
This is a basic concept in SQL.
upvoted 0 times
...
Zona
8 months ago
Yes, DML is used for manipulating data in a database.
upvoted 0 times
...
Jesusa
8 months ago
I agree, they are indeed examples of Data Manipulation Language (DML).
upvoted 0 times
...
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77