Question: 1. Construct a query to select the first 200 film titles (in ascending alphabetical order) where the film takes place in a 'Boa. You may


1. Construct a query to select the first 200 film titles (in ascending alphabetical order) where the film takes place in a 'Boa. You may assume that the film location is contained within the film table and attribute, description. Additionally, it is alway at the end of the sentence. For example in the following film description: s after the first occurrence of the word 'in' and finishes "A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies" The location is "The Canadian Rockies". Notes for Question 4.1 Boat' can be any boat, U-Boat, JET Boat etc, as long as the location includes the word 'Boat' You do not need to consider the film description output from the trigger you created for question 2.2 . 2. Create a function-based index called IDX_SEARCH_LOCATION that could potentially increase the speed of the query written in 4.1. Write a SQL statement to create an index that best fits that task and explain your choice. 3. Report the execution time of the query statement you wrote in Task 4.1 before and after creating the index in Task 4.2. Explain any difference. If there is no difference, explain why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
