Question:

Solve the following query:

GATE AR

Updated On: Jan 13, 2026

Hide Solution

Verified By Collegedunia

Correct Answer: 3

Solution and Explanation

The correct answer is 3.

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?
View Solution
On a relation named Loan of a bank:
View Solution
Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute. Suppose attribute D1 takes 3 values and D2 takes 2 values, and all combinations of these values are present in the table Facts. How many tuples are there in the result of the following query? \[ \text{SELECT D1, D2, sum(val)} \] \[ \text{FROM Facts} \] \[ \text{GROUP BY CUBE (D1, D2);} \]
View Solution
On a relation named Loan of a bank:

The following SQL query is executed:
SELECT L1.loannumber FROM Loan L1 WHERE L1.amount \(>\) (SELECT MAX(L2.amount) FROM Loan L2 WHERE L2.branchname = 'SR Nagar');
View Solution
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 ?
View Solution

View More Questions

Questions Asked in GATE AR exam

View More Questions