Time Left - 10:00 mins

GATE CS 2018 - Database Quiz- 5 (SQL)

Attempt now to get your rank among 674 students!

Question 1

SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries always gives the same answer as the nested query shown below:
Select * from R where a in (select S. a from S)

Question 2

Consider the following database table named top_scorer.

Consider the following SQL query:

SELECT ta.player FROM top_scorer AS ta
WHERE ta.goals > ALL ( SELECT tb.goals
		       FROM top_scorer AS tb
		       WHERE tb.country = 'Spain' )
      AND ta.goals > ANY (SELECT tc.goals
	       	        FROM top_scorer AS tc
		        WHERE tc.country = 'Germany')

The number of tuples returned by the above SQL query is ____

Question 3

The NOT NULL constraint enforces a column to?

Question 4

Identify the capabilities of SELECT statement.

Projection
Selection
Data Control
Transaction

Question 5

SELECT operation in SQL is equivalent to?

674 attempts
2 upvotes
13 comments

Tags :

GATE & PSU CS Databases

Sep 26GATE & PSU CS