Question: What does the following SQL assertion do: create assertion Test 1 exists ( select * from Employee _ list where ( salary > 8 0

What does the following SQL assertion do:
create assertion Test1
exists(select * from Employee_list where(salary>80000) AND (dept=Engineering))
Group of answer choices
a) Ensure no one in engineering makes over $80,000
b) Ensure that at least one employee in engineering makes over $80,000
c) Output the number of Engineering employees making over $80,000
d) None of the above

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 Programming Questions!