Consider the following relationTeacher (tech_id: integer, sal: integer, age: real, did: integer)There is a clustered index one id and an unclustered index on age.1. How would you use the indexes to enforce the constraint that tech_id is a key?2. Write a query of an update that is definitely speeded up because of the available indexes3. Give an example of an update that is definitely slowed down because of the indexes4. Can you give an example of an update that is neither speeded up nor slowed down by the indexes?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here