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
49
votes
4
answers
481
GATE CSE 2014 Set 1 | Question: 54
Given the following schema: employees(emp-id, first-name, last-name, hire-date, dept-id, salary) departments(dept-id, dept-name, manager-id, location-id) You want to display the last names and hire dates of all latest hires in their ... of pairwise comparison. It generates an error because of the GROUP BY clause cannot be used with table joins in a sub-query.
go_editor
asked
in
Databases
Sep 28, 2014
by
go_editor
14.5k
views
gatecse-2014-set1
databases
sql
normal
44
votes
8
answers
482
GATE CSE 2006 | Question: 69
Consider the relation enrolled (student, course) in which (student, course) is the primary key, and the relation paid (student, amount) where student is the primary key. Assume no null values and no foreign keys or integrity constraints. Assume that amounts ... faster than Plan 2 for all databases For $x = 9000,$ Plan I executes slower than Plan 2 for all databases
Rucha Shelke
asked
in
Databases
Sep 26, 2014
by
Rucha Shelke
15.2k
views
gatecse-2006
databases
sql
normal
61
votes
7
answers
483
GATE CSE 2006 | Question: 68
Consider the relation enrolled (student, course) in which (student, course) is the primary key, and the relation paid (student, amount) where student is the primary key. Assume no null values and no foreign keys or integrity constraints. ... strictly fewer rows than Query$2$ There exist databases for which Query$4$ will encounter an integrity violation at runtime
Rucha Shelke
asked
in
Databases
Sep 26, 2014
by
Rucha Shelke
20.2k
views
gatecse-2006
databases
sql
normal
85
votes
6
answers
484
GATE CSE 2006 | Question: 67
Consider the relation account (customer, balance) where the customer is a primary key and there are no null values. We would like to rank customers according to decreasing balance. The customer with the largest balance gets rank $1.$ Ties are not broke but ranks are skipped: if ... of the above statements are correct? $2$ and $5$ $1$ and $3$ $1$ and $4$ $3$ and $5$
Rucha Shelke
asked
in
Databases
Sep 26, 2014
by
Rucha Shelke
21.0k
views
gatecse-2006
databases
sql
normal
72
votes
3
answers
485
GATE CSE 2014 Set 1 | Question: 22
Given the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL. S2: Given the table $R(a,b,c)$ where $a$ and $b$ together form the primary key, the following is a valid table definition. CREATE ... S1 is TRUE and S2 is FALSE Both S1 and S2 are TRUE S1 is FALSE and S2 is TRUE Both S1 and S2 are FALSE
go_editor
asked
in
Databases
Sep 26, 2014
by
go_editor
23.4k
views
gatecse-2014-set1
databases
normal
sql
25
votes
4
answers
486
GATE CSE 1998 | Question: 7-a
Suppose we have a database consisting of the following three relations. $\text{FREQUENTS (student, parlor)}$ giving the parlors each student visits. $\text{SERVES (parlor, ice-cream)}$ ... the following in SQL: Print the students that frequent at least one parlor that serves some ice-cream that they like.
Kathleen
asked
in
Databases
Sep 26, 2014
by
Kathleen
6.1k
views
gate1998
databases
sql
descriptive
52
votes
2
answers
487
GATE CSE 2013 | Question: 35
Consider the following relational schema. Students(rollno: integer, sname: string) Courses(courseno: integer, cname: string) Registration(rollno: integer, courseno: integer, percent: real) Which of the following queries are equivalent to this query in English? Find the distinct names of ... I, II, III and IV I, II and III only I, II and IV only II, III and IV only
Arjun
asked
in
Databases
Sep 24, 2014
by
Arjun
15.0k
views
gatecse-2013
databases
sql
relational-calculus
normal
22
votes
4
answers
488
GATE CSE 1999 | Question: 22-a
Consider the set of relations EMP (Employee-no. Dept-no, Employee-name, Salary) DEPT (Dept-no. Dept-name, Location) Write an SQL query to: Find all employees names who work in departments located at ‘Calcutta’ and whose salary is greater than Rs.50,000. Calculate, for each department number, the number of employees with a salary greater than Rs. 1,00,000.
Kathleen
asked
in
Databases
Sep 23, 2014
by
Kathleen
12.3k
views
gate1999
databases
sql
easy
descriptive
39
votes
2
answers
489
GATE CSE 1999 | Question: 2.25
Which of the following is/are correct? An SQL query automatically eliminates duplicates An SQL query will not work if there are no indexes on the relations SQL permits attribute names to be repeated in the same relation None of the above
Kathleen
asked
in
Databases
Sep 23, 2014
by
Kathleen
19.7k
views
gate1999
databases
sql
easy
69
votes
5
answers
490
GATE CSE 2005 | Question: 77, ISRO2016-55
The relation book (title, price) contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list? select title from book as B where (select count(*) from ... books Title of the fifth most inexpensive book Title of the fifth most expensive book Titles of the five most expensive books
Kathleen
asked
in
Databases
Sep 22, 2014
by
Kathleen
30.4k
views
gatecse-2005
databases
sql
easy
isro2016
68
votes
8
answers
491
GATE CSE 2009 | Question: 55
Consider the following relational schema: $\text{Suppliers}(\underline{\text{sid:integer}},\text{ sname:string, city:string, street:string})$ $\text{Parts}(\underline{\text{pid:integer}}, \text{ pname:string, color:string})$ ... of all suppliers who have supplied only non-blue part. Find the names of all suppliers who have not supplied only blue parts.
Kathleen
asked
in
Databases
Sep 22, 2014
by
Kathleen
38.4k
views
gatecse-2009
databases
sql
normal
69
votes
5
answers
492
GATE CSE 2007 | Question: 61
Consider the table employee(empId, name, department, salary) and the two queries $Q_1, \, Q_2$ below. Assuming that department $5$ has more than one employee, and we want to find the employees who get higher salary than anyone in the department $5,$ ... $Q_1$ and $Q_2$ produce the same answer Neither $Q_1$ nor $Q_2$ is the correct query
Kathleen
asked
in
Databases
Sep 21, 2014
by
Kathleen
26.7k
views
gatecse-2007
databases
sql
normal
verbal-aptitude
38
votes
3
answers
493
GATE CSE 2004 | Question: 53
The employee information in a company is stored in the relation Employee (name, sex, salary, deptName) Consider the following SQL query Select deptName From Employee Where sex = M' Group by deptName Having avg(salary) > (select avg ( ... salary of employees in same the department the average salary of male employees is more than the average salary in the company
Kathleen
asked
in
Databases
Sep 18, 2014
by
Kathleen
11.2k
views
gatecse-2004
databases
sql
normal
46
votes
3
answers
494
GATE CSE 2003 | Question: 86
Consider the set of relations shown below and the SQL query that follows. Students: (Roll_number, Name, Date_of_birth) Courses: (Course_number, Course_name, Instructor) Grades: (Roll_number, Course_number, Grade) Select distinct Name from Students, Courses, Grades where ... students who have got an A grade in at least one of the courses taught by Korth None of the above
Kathleen
asked
in
Databases
Sep 17, 2014
by
Kathleen
15.2k
views
gatecse-2003
databases
sql
easy
32
votes
5
answers
495
GATE CSE 2002 | Question: 15
A university placement center maintains a relational database of companies that interview students on campus and make job offers to those successful in the interview. The schema of the database is given below: ... students were offered jobs, the name of the degree and the average offered salary of students in this degree program.
Kathleen
asked
in
Databases
Sep 15, 2014
by
Kathleen
5.5k
views
gatecse-2002
databases
normal
descriptive
relational-algebra
sql
16
votes
2
answers
496
GATE CSE 2001 | Question: 21-a
Consider a relation examinee (regno, name, score), where regno is the primary key to score is a real number. Write a relational algebra using $( \Pi, \sigma, \rho, \times)$ to find the list of names which appear more than once in examinee.
Kathleen
asked
in
Databases
Sep 14, 2014
by
Kathleen
3.7k
views
gatecse-2001
databases
sql
normal
descriptive
60
votes
5
answers
497
GATE CSE 2001 | Question: 2.25
Consider a relation geq which represents "greater than or equal to", that is, $(x,y) \in $ geq only if $y \geq x$. create table geq ( ib integer not null, ub integer not null, primary key ib, foreign key (ub) references geq on delete cascade ); Which ... (z,w) with z > x is deleted A tuple (z,w) with w < x is deleted The deletion of (x,y) is prohibited
Kathleen
asked
in
Databases
Sep 14, 2014
by
Kathleen
10.7k
views
gatecse-2001
databases
sql
normal
6
votes
1
answer
498
GATE CSE 2000 | Question: 22
Consider a bank database with only one relation transaction (transno, acctno, date, amount) The amount attribute value is positive for deposits and negative for withdrawals. Define an SQL view TP containing the information (acctno,T1.date,T2.amount) for every ... since it was created. To simplify your query, break it up into 2 steps by defining an intermediate view V.
Kathleen
asked
in
Databases
Sep 14, 2014
by
Kathleen
2.5k
views
gatecse-2000
databases
sql
normal
descriptive
63
votes
4
answers
499
GATE CSE 2000 | Question: 2.26
In SQL, relations can contain null values, and comparisons with null values are treated as unknown. Suppose all comparisons with a null value are treated as false. Which of the following pairs is not equivalent? $x = 5 \quad not (not (x = 5))$ $x = 5 \quad x > 4$ and $x < 6,$ where $x$ is an integer $x ≠ 5 \quad not (x = 5)$ none of the above
Kathleen
asked
in
Databases
Sep 14, 2014
by
Kathleen
18.6k
views
gatecse-2000
databases
sql
normal
57
votes
4
answers
500
GATE CSE 2000 | Question: 2.25
Given relations r(w, x) and s(y, z) the result of select distinct w, x from r, s is guaranteed to be same as r, provided. r has no duplicates and s is non-empty r and s have no duplicates s has no duplicates and r is non-empty r and s have the same number of tuples
Kathleen
asked
in
Databases
Sep 14, 2014
by
Kathleen
16.3k
views
gatecse-2000
databases
sql
22
votes
6
answers
501
GATE CSE 1991 | Question: 12-a
Suppose a database consist of the following relations: SUPPLIER (SCODE,SNAME,CITY). PART (PCODE,PNAME,PDESC,CITY). PROJECTS (PRCODE,PRNAME,PRCITY). SPPR (SCODE,PCODE,PRCODE,QTY). Write SQL programs corresponding to the following queries: Print PCODE values for ... part to a project in the second city, but do not print the triples in which the two CITY values are same.
Kathleen
asked
in
Databases
Sep 12, 2014
by
Kathleen
3.3k
views
gate1991
databases
sql
normal
descriptive
65
votes
6
answers
502
GATE CSE 2012 | Question: 15
Which of the following statements are TRUE about an SQL query? P : An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q : An SQL query can contain a HAVING clause only if it has a GROUP BY clause R : All attributes used ... Not all attributes used in the GROUP BY clause need to appear in the SELECT clause P and R P and S Q and R Q and S
gatecse
asked
in
Databases
Aug 5, 2014
by
gatecse
39.7k
views
gatecse-2012
databases
easy
sql
ambiguous
Page:
« prev
1
...
12
13
14
15
16
17
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:...