GATEverse Practice, past papers & mock tests
GATE 2027: 115 days Sign in Create account
GATE 2024 · session-1
Database Management and WarehousingIndexing and SQLmediumMSQ2 marks
An OTT company is maintaining a large disk-based relational database of different movies with the following schema: • Movie (ID, CustomerRating) • Genre (ID, Name) • Movie_Genre (MovieID, GenreID) The given SQL query is: ` SELECT * FROM Movie, Genre, Movie_Genre WHERE Movie.CustomerRating > 3.4 AND Genre.Name = "Comedy" AND Movie_Genre.MovieID = Movie.ID AND Movie_Genre.GenreID = Genre.ID; ` Problem Statement: This SQL query can be sped up using which of the following indexing options?

Select every correct option.

Save your progress

Related Database Management and Warehousing PYQs

GATE 2024 · session-1

Consider a database that includes the following relations: Defender(name, rating, side, goals), Forward(name, rating, assists, goa…

GATE 2024 · session-1

Let the minimum, maximum, mean, and standard deviation values for the attribute income of data scientists be Rs 246000, Rs 170000,…

GATE 2024 · session-1

Consider the following two tables named Raider and Team in a relational database maintained by a Kabaddi league. The attribute ID …

GATE 2024 · session-1

Given the relational schema R = (U, V, W, X, Y, Z) and the set of functional dependencies: {U → V, U → W, W → Y, W → Z, X → Y, X →…

GATE 2026 · session-8

Let \(R(A,B,C,D,E)\) be a relational schema with functional dependency set \(F = \{A \rightarrow BC,\ CD \rightarrow E,\ E \righta…

GATE 2026 · session-8

Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each combination of the attributes Prod…