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 81 discussion

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

You have a database table named SongInformation as defined below:

You need to create a Structured Query Language (SQL) query to retrieve only the names of songs that sold more than 1000 compact discs (CDs).
Which query should you use?

  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by martino88 at April 28, 2019, 6:17 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
PapaPanic
Highly Voted 6 years, 1 month ago
correct answer should be A
upvoted 40 times
...
martino88
Highly Voted 6 years, 1 month ago
This is wrong. Select name From <table name> Where cdssold > 1000
upvoted 27 times
Marcilla
4 years, 2 months ago
... which is option "A" instead of "D"
upvoted 2 times
...
...
mirsandu
Most Recent 3 years ago
Selected Answer: A
correct answer should be A
upvoted 1 times
...
defcon1
3 years, 6 months ago
Selected Answer: A
The table name is SongInformation and we want to retrieve only the names. The correct answer is therefore A
upvoted 1 times
...
jetblack81
4 years ago
As everyone has said, it's A. D would select every piece of info.
upvoted 1 times
...
CristianCruz
4 years, 1 month ago
Please update the answer with A, it's the correct one. D returns the hole columns because of this character (*)
upvoted 1 times
...
sandycheeks
4 years, 1 month ago
Correct answer is A
upvoted 2 times
...
Joka_Prep
4 years, 2 months ago
Correct answer is A
upvoted 1 times
...
qaqa111
4 years, 2 months ago
Answer should be A.
upvoted 1 times
...
FAYEE
4 years, 2 months ago
The correct answer should be A
upvoted 1 times
...
Mario81
4 years, 3 months ago
Might at well go with answer 'E'
upvoted 1 times
...
Mirela_Rona
4 years, 3 months ago
Please update the answer with A, it's the correct one. D returns the hole columns because of this character (*)
upvoted 1 times
...
Yorkatta
4 years, 3 months ago
And they still didn't correct the wrong answer...where can we report this?
upvoted 1 times
...
CristianCruz
4 years, 3 months ago
La correcta es la A, deberian actualizarlo
upvoted 1 times
...
tostasa
4 years, 5 months ago
the answer must be A because in D it return whole columns not only name
upvoted 1 times
...
Korongo
4 years, 5 months ago
Correct answer is A
upvoted 1 times
...
Korongo
4 years, 5 months ago
Correct answer is A
upvoted 1 times
...
Load full discussion...
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