Examine the structure of the PROGRAMS table:
Which two SQL statements would execute successfully?

View the Exhibit and examine the structures of the employees and departments tables.
You must update the employees table according to these requirements::
-Update only those employees who work in Boston or Seattle (locations 2900 and 2700).
-Set department_id for these employees to the department id corresponding to London (locationid 2100).
-Set the employees' salary in iocation_id 2100 to 1.1 times the average salary of their department.
-Set the employees' commission In location_id 2100 to 1.5 times the average commission of their department.
You issue this command:
What is the result?

Examine this statement:

What is returned upon execution?

Which statements are correct regarding indexes? (Choose all that apply.)