Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Recent questions tagged sql
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 $\_\_\_\_\_\_\_\_$.
Arjun
asked
in
Databases
Feb 16
by
Arjun
801
views
gate-ds-ai-2024
numerical-answers
databases
sql
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?
GO Classes
asked
in
Databases
Feb 5
by
GO Classes
278
views
goclasses2024-mockgate-14
databases
sql
2-marks
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.
GO Classes
asked
in
Databases
Feb 4
by
GO Classes
150
views
gate2024-da-memory-based
goclasses
databases
sql
numerical-answers
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?
GO Classes
asked
in
Databases
Feb 4
by
GO Classes
116
views
gate2024-da-memory-based
goclasses
databases
sql
b-tree
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.
GO Classes
asked
in
Databases
Jan 28
by
GO Classes
453
views
goclasses2024-mockgate-13
goclasses
databases
sql
2-marks
0
votes
1
answer
6
please explain this sql question and how do we get the answer?
pcla
asked
in
Databases
Jan 27
by
pcla
142
views
databases
sql
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.
GO Classes
asked
in
Databases
Jan 21
by
GO Classes
699
views
goclasses2024-mockgate-12
goclasses
databases
sql
1-mark
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
GO Classes
asked
in
Databases
Jan 13
by
GO Classes
861
views
goclasses2024-mockgate-11
goclasses
databases
sql
2-marks
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';
Ramayya
asked
in
Databases
Jan 7
by
Ramayya
442
views
isro-2024
databases
sql
query
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?
tishhaagrawal
asked
in
Databases
Dec 16, 2023
by
tishhaagrawal
354
views
databases
sql
query
gate-preparation
rdbms
doubt
made-easy-test-series
1
vote
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?
Sajal Mallick
asked
in
Databases
Nov 5, 2023
by
Sajal Mallick
349
views
made-easy-test-series
databases
sql
true-false
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
24aaaa23
asked
in
Databases
Oct 2, 2023
by
24aaaa23
378
views
databases
sql
0
votes
1
answer
13
DBMS
Çșȇ ʛấẗẻ
asked
in
Databases
Sep 23, 2023
by
Çșȇ ʛấẗẻ
190
views
databases
sql
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
equimanthorn
asked
in
Databases
Sep 15, 2023
by
equimanthorn
332
views
databases
sql
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 _____
Rahhul A
asked
in
Databases
Aug 3, 2023
by
Rahhul A
419
views
rdbms
sql
er-diagram
er-to-relational
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.
gateexplore
asked
in
Databases
Jun 30, 2023
by
gateexplore
900
views
sql
relational-algebra
databases
self-doubt
1
vote
1
answer
17
Applied root test series
priyansh_1705
asked
in
Databases
Jun 8, 2023
by
priyansh_1705
221
views
databases
sql
Page:
1
2
3
4
5
6
...
17
next »
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
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
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent questions tagged sql
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...