Recent questions tagged sql / GATE Overflow for GATE CSE

0 votes

2 answers

1

GATE DS&AI 2024 | Question: 21
Consider the following two tables named Raider and Team in a relational database maintained by a Kabaddi 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$ ... Jaipur" AND RaidPoints > 200; The number of rows returned by this query is $\_\_\_\_\_\_\_\_$.

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

Arjun

881 views

Arjun asked Feb 16

4 votes

0 answers

2

GO Classes Test Series 2024 | Mock GATE | Test 14 | Question: 40
Consider the following schema (primary keys are underlined): Which of the following queries returns the department numbers of those departments for which there are no courses being offered?

Consider the following schema (primary keys are underlined):Which of the following queries returns the department numbers of those departments for which there are no cour...

GO Classes

314 views

GO Classes asked Feb 5

0 votes

0 answers

3

Memory Based GATE DA 2024 | Question: 17
Consider the following SQL query: \[ \begin{aligned} &\text{SELECT * FROM Raider, Team} \\ &\text{WHERE Raider.id = Team.id} \\ &\text{AND City = 'Jaipur'} \\ &\text{AND Raid_points \textgreater 200; ... {aligned} \] Determine the number of rows returned by the SQL query, given the conditions specified for the City and Raid points.

Consider the following SQL query:\[\begin{aligned}&\text{SELECT * FROM Raider, Team} \\&\text{WHERE Raider.id = Team.id} \\&\text{AND City = 'Jaipur'} \\&\text{AND Raid_p...

GO Classes

172 views

GO Classes asked Feb 4

0 votes

0 answers

4

Memory Based GATE DA 2024 | Question: 58
DBMS question: One SQL query is given. Based on the query which data structure can be used involving hashing, B+ tree, etc?

DBMS question: One SQL query is given. Based on the query which data structure can be used involving hashing, B+ tree, etc?

GO Classes

132 views

GO Classes asked Feb 4

5 votes

1 answer

5

GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 64
Consider the following schema: The primary key fields are underlined, and the domain of each field is listed after the field name. Assume there are no NULL values in any column of any relation and every relation has at least one tuple. ... who have a rating of $10 $ OR have reserved boat $104.$ All sids of sailor table Empty set.

Consider the following schema:The primary key fields are underlined, and the domain of each field is listed after the field name. Assume there are no NULL values in any c...

GO Classes

485 views

GO Classes asked Jan 28

0 votes

1 answer

6

please explain this sql question and how do we get the answer?

pcla

152 views

pcla asked Jan 27

12 votes

1 answer

7

GO Classes Test Series 2024 | Mock GATE | Test 12 | Question: 25
Let $\mathrm{R}(\mathrm{a}, \mathrm{b})$ be a schema and $\mathrm{Q} 1$ and $\mathrm{Q} 2$ are queries on $\mathrm{R}$. Q1: SELECT * FROM R; Q2: (SELECT * FROM R) INTERSECT (SELECT * FROM R); Which of the ... to $\text{Q2}$ is always contained in the answer to $\text{Q1}.$ $\text{Q1}$ and $\text{Q2}$ produce different answers.

Let $\mathrm{R}(\mathrm{a}, \mathrm{b})$ be a schema and $\mathrm{Q} 1$ and $\mathrm{Q} 2$ are queries on $\mathrm{R}$.Q1: SELECT * FROM R; Q2: (SELECT * FROM R) INTERSEC...

GO Classes

736 views

GO Classes asked Jan 21

12 votes

1 answer

8

GO Classes Test Series 2024 | Mock GATE | Test 11 | Question: 57
You are given a table named Alums that contains the names and personal information of all graduates of the college that you work for. It includes name and age attributes, and a state attribute specifying the state in which a person ... of the youngest graduate living in California (CA)? only II only III only I and II only II and III

You are given a table named Alums that contains the names and personal information of all graduates of the college that you work for. It includes name and age attributes,...

GO Classes

898 views

GO Classes asked Jan 13

2 votes

2 answers

9

ISRO 2024
Which of the following SQL query deletes all tuples in the teacher relation for those teachers associated with a department located in the building with name CSE and which is in department relation: DELETE FROM teacher WHERE dept_name IN CSE'; DELETE FROM ... WHERE dept_name IN ( SELECT dept_name FROM department WHERE building = CSE); DELETE FROM teacher WHERE dept_name IN CSE';

Which of the following SQL query deletes all tuples in the teacher relation for those teachers associated with a department located in the building with name CSE and whic...

Ramayya

470 views

Ramayya asked Jan 7

0 votes

1 answer

10

MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right? For example, in the above question - The ... the same below) Can anyone please explain whether I am approaching this right, or if I am missing something?

My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right?For example, in the...

tishhaagrawal

407 views

tishhaagrawal asked Dec 16, 2023

1 votes

1 answer

11

MADE EASY TEST SERIES
Unique not null is equivalent to primary key. Relational Algebra and SQL has same expressive power. Which of the above statements are False?

Unique not null is equivalent to primary key.Relational Algebra and SQL has same expressive power.Which of the above statements are False?

Sajal Mallick

357 views

Sajal Mallick asked Nov 5, 2023

2 votes

2 answers

12

sql
Consider the label student (sid, sname, class, avg_marks). Q1: Select sid from student S1 Where not exists (Select sid from student S where S.class=5 and S1.avg_marks <= S.avg_marks) Q2: Select sid from student S1 Where s1. avg_marks>Any (Select distinct ... output B. will show sid of students who has maximum avg_marks. C. will show sid of student whose avg_marks is second highest. D.None

Consider the label student (sid, sname, class, avg_marks).Q1: Select sid from student S1Where not exists(Select sid from student S where S.class=5 and S1.avg_marks <= S.a...

24aaaa23

385 views

24aaaa23 asked Oct 2, 2023

0 votes

1 answer

13

DBMS

Çșȇ ʛấẗẻ

191 views

Çșȇ ʛấẗẻ asked Sep 23, 2023

2 votes

1 answer

14

Applied Roots - DBMS Practice Test 2 (SQL query order question)
A SQL query is written in its format as clauses are arranged in a specific sequence and these clauses are executed in different sequence. If we're writing a query using select, from, where, group by, having, order by, Distinct clauses. Then ... clauses are needed to be replaced while writing it's execution order. A) 1 B) 2 C) 3 D) 4

A SQL query is written in its format as clauses are arranged in a specific sequence and these clauses are executed in different sequence. If we’re writing a query using...

equimanthorn

342 views

equimanthorn asked Sep 15, 2023

0 votes

1 answer

15

Dbms practice - Self doubt
Consider the below instance of relation : Employee: Emp_rating Emp_name Emp_mail Emp_sal 1. Surabhi sm301@gj 40000 2. Vishu sp11@ap 60000 1. Surabhi Null 50000 3. Yashy ar@dy 60000 The maximum possible number of alternate keys for the above relational instance is/are _____

Consider the below instance of relation : Employee: Emp_ratingEmp_nameEmp_mailEmp_sal1.Surabhism301@[email protected]@dy60000 The maxi...

Rahhul A

430 views

Rahhul A asked Aug 3, 2023

0 votes

1 answer

16

Database
Considering the following schema, create the appropriate tables and insert at least 5 records: AUTHOR(author-id,name, city,country) PUBLISHER (publisher-id, name,city, country) CATALOG (book-id, title, author-id, publisher-id, category-id, year, price) CATEGORY ( ... in the catalog. (g) Obtain the author and publisher who have published books in more than or 14 equal to 2 categories.

Considering the following schema, create the appropriate tables and insert at least 5 records:AUTHOR(author-id,name, city,country)PUBLISHER (publisher-id, name,city, coun...

gateexplore

944 views

gateexplore asked Jun 30, 2023

1 votes

1 answer

17

Applied root test series

priyansh_1705

222 views

priyansh_1705 asked Jun 8, 2023

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true