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

 Tests Employees EID Test_no EID Department Score Assuming a database with

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!