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
14 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
17 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
...
Chaya
22 days ago
Haha, D is the winner! Who needs to specify the column when you can just select everything, right? #LazyProgrammer
upvoted 0 times
...
Antonette
23 days 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
...
Kristel
1 months ago
The correct answer is A. The statement should be 'SELECT EmpId FROM employee WHERE EmpId = 90030'.
upvoted 0 times
Elin
9 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