GATE DA topic:database-management-warehousing PYQs & Answers — Page 3

Questions 21–22 of 22. Imported answers require independent review unless marked reviewed.

Given the relational schema

and the set of functional dependencies:

Which of the following functional dependencies can be derived from the above set?

Your answerSelect all correct options. You can choose more than one.

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

An OTT company is maintaining a large disk-based relational database of different movies with the following schema:

Movie(

)

Genre(

)

Movie_Genre(

)

Consider the following SQL query on the relational 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.GenreId = Genre.ID;

This SQL query can be sped up using which of the following indexing options?

Your answerSelect all correct options. You can choose more than one.

B+ tree on all the attributes.

Hash index on

and B+ tree on the remaining attributes.

Hash index on

and B+ tree on the remaining attributes.

Hash index on all the attributes.

You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer

GATE DA topic:database-management-warehousing PYQs