CompTIA DataSys+ (DS0-001) — Question 10

Which of the following statements contains an error?

Answer options

• A. Select EmpId from employee where EmpId=90030
• B. Select EmpId where EmpId=90030 and DeptId=34
• C. Select* from employee where EmpId=90030
• D. Select EmpId from employee

Correct answer: B

Explanation

Option B is incorrect because it lacks the 'from' clause, which is necessary for specifying the source table in a SQL query. The other options are correctly structured and include the required elements to execute without errors.