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
Gateforum Test Series: Databases - Sql
Gupta731
asked
in
Databases
Nov 1, 2018
edited
Mar 15, 2019
by
ajaysoni1924
227
views
0
votes
0
votes
gateforum-test-series
databases
sql
Gupta731
asked
in
Databases
Nov 1, 2018
edited
Mar 15, 2019
by
ajaysoni1924
by
Gupta731
227
views
answer
comment
Follow
share this
share
0 Comments
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
0
votes
0
votes
i think answer should be A
because it will lead to first check "raju" and then further checking
hashing can't be a option because it is range query....
Himanshu Kumar Gupta
answered
Jun 10, 2020
by
Himanshu Kumar Gupta
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
1
vote
1
vote
1
answer
1
Shivam Kasat
asked
in
Databases
Dec 19, 2018
498
views
Gateforum Test Series: Databases - Sql
the table “Sales89” contains information about the address,zip,sale-date,price and inflamation-adjusted “real-price” of 222 sales of single family homes in calcutta during 1989.Here is the table schema
Shivam Kasat
asked
in
Databases
Dec 19, 2018
by
Shivam Kasat
498
views
gateforum-test-series
databases
sql
1
vote
1
vote
1
answer
2
Gupta731
asked
in
Databases
Nov 3, 2018
495
views
Gateforum Test Series: Databases - Sql
What will be the result of this query? Select item from inventory i where (Select count(*) from inentory j where j.stock>i.stock)<3; Bottom 3 items of the stock Top 3 items of the stock Top 2 items of the stock Bottom 2 items of the stock Isn't the answer A? But B is provided as an answer.
Gupta731
asked
in
Databases
Nov 3, 2018
by
Gupta731
495
views
gateforum-test-series
databases
sql
0
votes
0
votes
0
answers
3
Gupta731
asked
in
Databases
Nov 3, 2018
651
views
Gateforum Test Series: Databases - Sql
Gupta731
asked
in
Databases
Nov 3, 2018
by
Gupta731
651
views
gateforum-test-series
databases
sql
0
votes
0
votes
0
answers
4
Gupta731
asked
in
Databases
Oct 24, 2018
600
views
GateForum Test Series: Databases - Sql
The answer should be D, but C is provided as the answer.
Gupta731
asked
in
Databases
Oct 24, 2018
by
Gupta731
600
views
gateforum-test-series
databases
sql
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
(24)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(682)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
243k
comments
79.7k
users
Recent Blog Comments
Hlo I'm Rupesh I got AIR 3485 in gate CS and AIR...
@Ajay Sasank here is the direct link...
Thank you for the post didi My GATE 2023 & 2024...
I Hope it helps 😊
Today's best post I seen thank you for motivation
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy