Microsoft
70-432 · Question #37
You are a database developer for your company. You use the following Transact-SQL code. SELECT e.Resume,j.EmployeeID FROM JobCandidate j, Employee e WHERE j.EmployeeID =* e.EmployeeID You need to…
The correct answer is C. SELECT e.Resume, j.EmployeeID. See the full explanation below for the reasoning.
Question
You are a database developer for your company. You use the following Transact-SQL code. SELECT e.Resume,j.EmployeeID FROM JobCandidate j, Employee e WHERE j.EmployeeID =* e.EmployeeID You need to rewrite this code to be ANSI compliant. How should you rewrite the code?
Options
- ASELECT e.Resume, j.EmployeeID
- BSELECT e.Resume, j.EmployeeID
- CSELECT e.Resume, j.EmployeeID
- DSELECT e.Resume, j.EmployeeID
How the community answered
(21 responses)- A10% (2)
- B5% (1)
- C71% (15)
- D14% (3)
Community Discussion
No community discussion yet for this question.