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

- Free Preparation Discussions

CompTIA Exam DS0-001 Topic 4 Question 15 Discussion

Actual exam question for CompTIA's DS0-001 exam
Question #: 15
Topic #: 4
[All DS0-001 Questions]

Which of the following statements contains an error?

Show Suggested Answer Hide Answer

Contribute your Thoughts:

Rasheeda
22 days ago
Wait, aren't we supposed to use single quotes around the values? Like 'EmpId = '90030''? These SQL purists are getting out of hand!
upvoted 0 times
...
Stephane
26 days ago
C looks good to me. Selecting all columns from the employee table where EmpId = 90030 seems like the correct statement.
upvoted 0 times
Justine
7 days ago
A) Select EmpId from employee where EmpId=90030
upvoted 0 times
...
...
Chaya
1 months ago
Haha, D is the winner! Who needs to specify the column when you can just select everything, right? #LazyProgrammer
upvoted 0 times
...
Antonette
1 months ago
I think B is the one with an error. The syntax should be 'SELECT EmpId FROM employee WHERE EmpId = 90030 AND DeptId = 34'.
upvoted 0 times
Hollis
9 days ago
I agree, B seems to have a syntax error.
upvoted 0 times
...
...
Kristel
2 months ago
The correct answer is A. The statement should be 'SELECT EmpId FROM employee WHERE EmpId = 90030'.
upvoted 0 times
Suzi
2 days ago
B) Select EmpId where EmpId=90030 and DeptId=34
upvoted 0 times
...
Elin
18 days ago
A) Select EmpId from employee where EmpId=90030
upvoted 0 times
...
...
Lorrie
2 months ago
I believe statement D is incorrect because it does not specify any condition for filtering the results.
upvoted 0 times
...
Lanie
2 months ago
I agree with Kati. The asterisk should not be used in the SELECT statement.
upvoted 0 times
...
Kati
2 months ago
I think statement C contains an error.
upvoted 0 times
...
Aliza
2 months ago
Why do you think option B is incorrect?
upvoted 0 times
...
Luisa
2 months ago
I disagree, I believe option B is the one with the error.
upvoted 0 times
...
Aliza
2 months ago
I think option C has an error.
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