Positioning statements in Oracle WHERE clause - Exercise

This exercise is worth a total of 10 points. To receive full credit, you will need to write a query that correctly orders items in the WHERE clause. Once you have completed your answer, you'll submit your answer.

Here is a query that looks for students who have blue eyes and who are from Sweden.

SELECT
last_name
FROM
STUDENT
WHERE
eye_color = ‘BLUE'
AND
national_origin = 'SWEDEN';

Your job as DBA is to tune this query to ensure that the Boolean predicates are in their proper order from least restrictive to most restrictive.

• Submitting your Exercise
  Enter your queries in the two text boxes below and click Submit button to submit your responses. Remember, you must fill in both text boxes before clicking the Submit button.

For this exercise, you need to perform the following tasks:

1. Write a query to verify that indexes exist for the eye_color and national_origin columns of the student table.

2. Write an SQL query that counts the number of distinct values for eye_color and national_origin.