Tests Employees EID Test_no EID Department Score Assuming a database with the ab

Question

Tests Employees EID Test_no EID Department Score Assuming a database with the above two tables exist, which of the following statements correctly describes the UPDATE statement below? UPDATE Tests SET Score = CASE WHEN Score is null THEN O WHEN Score> 80 THEN Score 5 WHEN Score between 50 and 80 THEN Score+1 ELSE Score END FROM Tests join Employees on Tests.EID Employees.EID WHERE Testno 5 and Employees.Department 'R&D;' All scores of test with Test no 5 are updated. Not every score of test with Test no 5 of employees of R&D; department is updated All scores of test with Test-no 5 of employees of R&D; department are updated. Score 90 will be updated to 95 and score 66 will become 71. If a score has no value (ie., NULL), it will be updated to be zero.

Explanation / Answer

Answer:
All scores of test with Test_no 5 of employees of R & D department are updatd.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.