Question:
An OTT company is maintaining a large disk-based relational database of different movies with the following schema :
Movie (ID, Customer Rating)
Genre (ID, Name)
Movie Genre (MovieID, GenreID)
Consider the following SQL query on the relation database above :
SELECT *
FROM Movie, Genre, Movie_Genre
WHERE
Movie. CustomerRating > 3.4 AND
Genre.Name = "Comedy" AND
Movie_Genre.MovieID = Movie. ID AND
Movie_Genre.Genre ID = Genre. ID;
This SQL query can be sped up using which of the following indexing options ?
An OTT company is maintaining a large disk-based relational database of different movies with the following schema :
Movie (ID, Customer Rating)
Genre (ID, Name)
Movie Genre (MovieID, GenreID)
Consider the following SQL query on the relation database above :
SELECT *
FROM Movie, Genre, Movie_Genre
WHERE
Movie. CustomerRating > 3.4 AND
Genre.Name = "Comedy" AND
Movie_Genre.MovieID = Movie. ID AND
Movie_Genre.Genre ID = Genre. ID;
This SQL query can be sped up using which of the following indexing options ?
Movie (ID, Customer Rating)
Genre (ID, Name)
Movie Genre (MovieID, GenreID)
Consider the following SQL query on the relation database above :
SELECT *
FROM Movie, Genre, Movie_Genre
WHERE
Movie. CustomerRating > 3.4 AND
Genre.Name = "Comedy" AND
Movie_Genre.MovieID = Movie. ID AND
Movie_Genre.Genre ID = Genre. ID;
This SQL query can be sped up using which of the following indexing options ?
Updated On: Jul 9, 2024
- B+ tree on all the attributes.
- Hash index on Genre.Name and B+ tree on the remaining attributes.
- Hash index on Movie.CustomerRating and B+ tree on the remaining attributes.
- Hash index on all the attributes.
Hide Solution
Verified By Collegedunia
The Correct Option is A, B
Solution and Explanation
The correct option is (A) : B+ tree on all the attributes and (B) : Hash index on Genre.Name and B+ tree on the remaining attributes.
Was this answer helpful?
0
0
Top Questions on SQL
- Given the table facts: \[ \text{facts (D1, D2, val)} \] with the following data:
Consider the following SQL query:
What is the total number of rows produced? - SQL applies conditions on the groups through ________ clause after groups have been formed?
- What is the output of the SQL statement?
SELECT MID('CUET2024',2,5)? - Amit wants to be familiar with SQL. One of his friends Anand suggests him to execute the following SQL commands:
(A) Create Table Student
(B) Use Database DB
(C) Select * from Student
(D) Insert into Student
In which order Amit needs to run the above commands? - Which SQL expression calculates the square root of 16?
View More Questions
Questions Asked in GATE AR exam
- Which of the following methods is/are used in traffic survey to measure the Running Speed and Journey Speed?
- GATE AR - 2024
- Traffic survey methods, Traffic flow Analysis
- For the beam shown below, ignoring the self-weight, the maximum hogging moment (in kN·m) generated for the loads indicated is _______ (rounded off to one decimal place).
- GATE AR - 2024
- High Rise and Long Span structures, gravity and lateral load resisting systems
- Let f: R→ R be a function. Note: R denotes the set of real numbers.
\(f(x) = \left\{ \begin{array}{ll} -x, & \text{if } x < -2 \\ ax^2+bx+c, & \text{if }\ x \in[-2,2]\\ x, & \text{if } x>2 \end{array} \right.\)
Which ONE of the following choices gives the values of a, b, c that make the function f continuous and differentiable ?- GATE AR - 2024
- Differential Equations
- Consider the dataset with six datapoints : {(x1, y1), (x2, y2), ..., (x6, y6)}, where x1 = \(\begin{bmatrix} 1 \\ 0 \end{bmatrix}\), x2 = \(\begin{bmatrix} 0 \\ 1 \end{bmatrix}\), x3 = \(\begin{bmatrix} 0 \\ -1 \end{bmatrix}\), x4 = \(\begin{bmatrix} -1 \\ 0 \end{bmatrix}\), x5 = \(\begin{bmatrix} 2\\ 2 \end{bmatrix}\), x6 = \(\begin{bmatrix} -2 \\ -2 \end{bmatrix}\) and the labels are given by y1 = y2 = y5 = 1, and y3 = y4 = y6 = -1 .A hard margin linear support vector machine is trained on the above dataset. Which ONE of the following sets is a possible set of support vectors?
- GATE AR - 2024
- Database Concepts
- A ramp with a slope of 1 : 12 is required for wheelchair access. Intermediate landings of length 1.5 m each have to be provided after every 9 m running length. The running length of a straight ramp including landing, to negotiate a level difference of 900 mm vertical height, in m, is ( rounded off to two decimal places).
- GATE AR - 2024
- Urban renewal and conservation
View More Questions