Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Foundations Technology Fundamentals For IT Success

Authors: Bob Bryla

1st Edition

0782143725, 9780782143720

More Books

Students also viewed these Databases questions