ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

Exam 98-364 topic 1 question 134 discussion

Actual exam question from Microsoft's 98-364
Question #: 134
Topic #: 1
[All 98-364 Questions]

You are developing a SQL query.
Which two SQL constructs represent data manipulation language (DML) statements? Choose two.

  • A. SELECT EmployeeName FROM Employee WHERE EmployeeName = 'Jack Smith';
  • B. INSERT INTO Employee VALUES ('Jack Smith')
  • C. ALTER TABLE Employee ADD EmployeeName Varchar;
  • D. CREATE ROW IN Employee WHERE EmployeeName = 'Jack Smith';
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️
Data manipulation languages have their functional capability organized by the initial word in a statement, which is almost always a verb. In the case of SQL, these verbs are:
✑ SELECT ... FROM ... WHERE ... (strictly speaking DQL)
✑ SELECT ... INTO ...
✑ INSERT INTO ... VALUES ...
✑ UPDATE ... SET ... WHERE ...
✑ DELETE FROM ... WHERE ...
References:
https://en.wikipedia.org/wiki/Data_manipulation_language
by JasonBH at Oct. 4, 2020, 11:40 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
pypaul
4 years ago
A & B - DML are Insert, Update, delete, Select
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel