Data Science and Artificial Intelligence
2024 · Paper 1
Take it one question at a time. Try an answer, then check your understanding.
Complete GATE DA 2024 Paper 1 overview, original pages and practice · Timed previous-paper practice
Questions 31–33 of 65. Imported answers require review unless explicitly marked reviewed.
Question 31
Open questionDANAT1 markNeeds review
Consider the following two tables named Raider and Team in a relational database maintained by a Kabadi league. The attribute ID in table Team references the primary key of the Raider table, ID.
Raider:
ID | Name | Raids | RaidPoints |
|---|---|---|---|
1 | Arjun | 200 | 250 |
2 | Ankush | 190 | 219 |
3 | Sunil | 150 | 200 |
4 | Reza | 150 | 190 |
5 | Pratam | 175 | 220 |
6 | Gopal | 193 | 215 |
Team:
City | ID | BidPoints |
|---|---|---|
Jaipur | 2 | 200 |
Patna | 3 | 195 |
Hyderabad | 5 | 175 |
Jaipur | 1 | 250 |
Patna | 4 | 200 |
Jaipur | 6 | 200 |
The SQL query described below is executed on this database:
SELECT *
FROM Raider, Team
WHERE Raider.ID=Team.ID AND City="Jaipur" AND RaidPoints > 200;
The number of rows returned by this query is _____.
Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answerQuestion 32
Open questionDANAT1 markNeeds review
The fundamental operations in a double-ended queue D are:
insertFirst(e) – Insert a new element e at the beginning of D.
insertLast(e) – Insert a new element e at the end of D.
removeFirst() – Remove and return the first element of D.
removeLast() – Remove and return the last element of D.
In an empty double-ended queue, the following operations are performed:
insertFirst(10)
insertLast(32)
a ← removeFirst()
insertLast(28)
insertLast(17)
a ← removeFirst()
a ← removeLast()
The value of a is _____.
Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answerQuestion 33
Open questionDANAT1 markNeeds review
Let
be the function
.The value of the derivative of
at
where
is _____ (rounded off to two decimal places).Note:
denotes the set of real numbers.Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answer