Awesome q2a theme
Ask us anything
Toggle navigation
Email or Username
Password
Remember
Login
Register
|
I forgot my password
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Blogs
Previous Year
Exams
Recent questions tagged sql
+1
vote
0
answers
Self Doubt regarding ER diagram
What is degree of Self Referential Relationship? Unary or Binary?
asked
16 hours
ago
in
Databases
by
adas7099
(
9
points)
|
4
views
selfdoubt
sql
databases
0
votes
0
answers
How to convert this problem statement to ER model
Can Somebody know how to design ER Diagram from this ?
asked
3 days
ago
in
Databases
by
ghostman23111
(
5
points)
|
6
views
databases
sql
0
votes
2
answers
applied subjectwise test
A:Result of Sids of suppliers who supply some red or green part. B:Result of Sids of suppliers who do not supply any red or green part. C:Result of Sids of suppliers who supply every red or green part. D:Result of Sids of suppliers who do not supply some red or green part.
asked
Nov 16, 2020
in
Databases
by
Ashutosh777
(
-219
points)
|
63
views
sql
0
votes
1
answer
#self doubt sql
If we define a UNIQUENESS Constarint on a column of table then under that column can we have multiple NULL entries.??
asked
Aug 11, 2020
in
Databases
by
Anujjain
(
7
points)
|
14
views
sql
0
votes
0
answers
Madeeasy dbms workbook 2020 , chapter : relation algebra ,tuple relational calculus and sql, question number 15
asked
Jul 4, 2020
in
Databases
by
swatiChaudhary
(
11
points)
|
53
views
made-easy-workbook
databases
sql
sql
0
votes
0
answers
Relational Algebra
NOTE: * denotes primary key; f denotes foreign key Que: Consider the above schema and give relational algebra query for the following 1. Find no. of students who have taken the courses taught by 'Joe' and not registered in any other courses, also they should ... place in PLACEID 100. 5. Find the details of student who has score GRADEPOINT A in all the course he/she is registered.
asked
Jun 18, 2020
in
Databases
by
Tris Ravi
(
5
points)
|
16
views
sql
er-diagram
relational-algebra
+1
vote
1
answer
GATE2005-77, ISRO2016-55 Video Solution
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
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
29
views
gate2005
databases
sql
easy
isro2016
video-solution
0
votes
0
answers
GATE2012-15 Video Solution
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 in ... 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
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
8
views
gate2012
databases
easy
sql
ambiguous
video-solution
0
votes
0
answers
GATE2009-55 Video Solution
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.
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
8
views
gate2009
databases
sql
normal
video-solution
+1
vote
1
answer
GATE2007-61 Video Solution
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, which one ... $Q_1$ and $Q_2$ produce the same answer Neither $Q_1$ nor $Q_2$ is the correct query
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
13
views
gate2007
databases
sql
normal
verbal-ability
video-solution
0
votes
0
answers
GATE2009-56 Video Solution
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})$ ... $3NF$ but not in $\text{BCNF}$ The schema is in $2NF$ but not in $3NF$ The schema is not in $2NF$
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
12
views
gate2009
databases
sql
database-normalization
normal
video-solution
0
votes
0
answers
GATE2006-67 Video Solution
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 ... ranks using ODBC. Which two of the above statements are correct? 2 and 5 1 and 3 1 and 4 3 and 5
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
5
views
gate2006
databases
sql
normal
video-solution
0
votes
0
answers
GATE2006-IT-85 Video Solution
Consider a database with three relation instances shown below. The primary keys for the Drivers and Cars relation are did and cid respectively and the records are stored in ascending order of these primary keys as given in the tables. No indexing is available in the database. ... key, then $n$ lies in the range: $36 - 40$ $44 - 48$ $60 - 64$ $100 - 104$
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
8
views
gate2006-it
databases
sql
normal
video-solution
0
votes
0
answers
GATE2014-1-22 Video Solution
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 TABLE S ... ? 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
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
20
views
gate2014-1
databases
normal
sql
video-solution
0
votes
1
answer
GATE2006-68 Video Solution
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 ... which Query3 returns strictly fewer rows than Query2 There exist databases for which Query4 will encounter an integrity violation at runtime
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
11
views
gate2006
databases
sql
normal
video-solution
0
votes
0
answers
GATE2014-2-54 Video Solution
SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries always gives the same answer as the nested query shown below: select * from R where a in (select S.a from S) select R.* ... distinct a from S) as S1 where R.a=S1.a select R.* from R,S where R.a=S.a and is unique R
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
9
views
gate2014-2
databases
sql
normal
video-solution
0
votes
0
answers
GATE2000-2.26 Video Solution
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
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
8
views
gate2000
databases
sql
normal
video-solution
0
votes
0
answers
GATE2019-51 Video Solution
A relational database contains two tables Student and Performance as shown below: ... S, Performance P WHERE P.Marks >84 GROUP BY S.Student_name; The number of rows returned by the above SQL query is ________
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
29
views
gate2019
numerical-answers
databases
sql
video-solution
0
votes
0
answers
GATE2017-2-46 Video Solution
Consider the following database table named $\text{top_scorer}$ ... (SELECT tc.goals FROM top_scorer AS tc WHERE tc.country='Germany') The number of tuples returned by the above SQL query is ______
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
20
views
gate2017-2
databases
sql
numerical-answers
video-solution
0
votes
0
answers
GATE2000-2.25 Video Solution
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
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
17
views
gate2000
databases
sql
video-solution
+1
vote
1
answer
GATE1999-2.25 Video Solution
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
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
11
views
gate1999
databases
sql
easy
video-solution
+1
vote
1
answer
GATE2015-1-27 Video Solution
Consider the following relation: ... P WHERE S.Roll_No= P.Roll_No GROUP BY S.STUDENT_Name The numbers of rows that will be returned by the SQL query is_________________.
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
15
views
gate2015-1
databases
sql
normal
numerical-answers
video-solution
+1
vote
1
answer
GATE2013-35 Video Solution
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
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
38
views
gate2013
databases
sql
relational-calculus
normal
video-solution
0
votes
0
answers
GATE2008-IT-74 Video Solution
Student (school-id, sch-roll-no, sname, saddress) School (school-id, sch-name, sch-address, sch-phone) Enrolment(school-id sch-roll-no, erollno, examname) ExamResult(erollno, examname, marks) What does the following SQL query output? SELECT sch-name, ... of the school and the number of its students scoring 100 in at least one exam nothing; the query has a syntax error
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
21
views
gate2008-it
databases
sql
normal
video-solution
0
votes
0
answers
GATE2017-1-23 Video Solution
Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An instance of the schema EMP and a SQL query on it are given below: ... (SELECT DeptName, COUNT(EmpId) AS EC(DeptName, Num) FROM EMP GROUP BY DeptName) The output of executing the SQL query is _____________ .
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
10
views
gate2017-1
databases
sql
numerical-answers
video-solution
+1
vote
1
answer
GATE2014-3-54 Video Solution
Consider the following relational schema: employee (empId,empName,empDept) customer (custId,custName,salesRepId,rating) salesRepId is a foreign key referring to empId of the employee relation. Assume that each employee makes a sale to at least one customer. ... customers having a 'GOOD' rating. Names of all the employees with all their customers having a 'GOOD' rating.
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
24
views
gate2014-3
databases
sql
easy
video-solution
0
votes
0
answers
GATE2006-69 Video Solution
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 ... executes faster than Plan 2 for all databases For x = 9000, Plan I executes slower than Plan 2 for all databases
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
6
views
gate2006
databases
sql
normal
video-solution
0
votes
0
answers
GATE2014-1-54 Video Solution
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 respective ... of pairwise comparison. It generates an error because of the GROUP BY clause cannot be used with table joins in a sub-query.
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
16
views
gate2014-1
databases
sql
normal
video-solution
0
votes
0
answers
GATE2005-IT-69 Video Solution
In an inventory management system implemented at a trading corporation, there are several tables designed to hold all the information. Amongst these, the following two tables hold information on which items are supplied by which suppliers, and which warehouse ... who do not supply any item supply exactly one item supply one or more items supply two or more items
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
33
views
gate2005-it
databases
sql
normal
video-solution
+1
vote
1
answer
GATE2016-2-52 Video Solution
Consider the following database table named water_schemes: ... total_avg (capacity) as select avg (capacity) from total select name from total, total_avg where total.capacity ≥ total_avg.capacity
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
15
views
gate2016-2
databases
sql
normal
numerical-answers
video-solution
+1
vote
1
answer
GATE2003-86 Video Solution
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
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
16
views
gate2003
databases
sql
easy
video-solution
0
votes
0
answers
GATE2012-51 Video Solution
Consider the following relations $A, B$ and $C:$ ... contain? SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = Arun') $4$ $3$ $0$ $1$
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
11
views
gate2012
databases
sql
normal
video-solution
0
votes
0
answers
GATE2005-IT-68 Video Solution
A table 'student' with schema (roll, name, hostel, marks), and another table 'hobby' with schema (roll, hobbyname) contains records as shown below: ... between the number of rows output by the SQL statement and the number of tuples in $S'$ is $6$ $4$ $2$ $0$
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
12
views
gate2005-it
databases
sql
relational-algebra
normal
video-solution
0
votes
0
answers
GATE2015-3-3 Video Solution
Consider the following relation Cinema($\textit{theater, address, capacity}$) Which of the following options will be needed at the end of the SQL query SELECT P1.address FROM Cinema P1 such that it always finds the addresses of theaters with maximum capacity? ... (select max(P2.capacity) from Cinema P2) WHERE P1.capacity > Any (select max(P2.capacity) from Cinema P2)
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
8
views
gate2015-3
databases
sql
normal
video-solution
0
votes
0
answers
GATE2001-2.25 Video Solution
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
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
15
views
gate2001
databases
sql
normal
video-solution
0
votes
0
answers
GATE2004-IT-74 Video Solution
A relational database contains two tables student and department in which student table has columns roll_no, name and dept_id and department table has columns dept_id and dept_name. The following insert statements were executed successfully to populate the empty tables: ... department 0 row and 4 columns 3 rows and 4 columns 3 rows and 5 columns 6 rows and 5 columns
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
5
views
gate2004-it
databases
sql
normal
video-solution
+1
vote
1
answer
GATE2011-32 Video Solution
Consider a database table T containing two columns $\text{X}$ and $\text{Y}$ each of type $\text{integer}$. After the creation of the table, one record $\text{(X=1, Y=1)}$ is inserted in the table. Let $\text{MX}$ and $\text{MY}$ ... will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7; 127 255 129 257
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
14
views
gate2011
databases
sql
normal
video-solution
0
votes
0
answers
GATE2018-12 Video Solution
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock(isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn=S.isbn; Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN ... above is certain to have an output that is a superset of the outputs of the other three queries? Query 1 Query 2 Query 3 Query 4
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
6
views
gate2018
databases
sql
easy
video-solution
0
votes
0
answers
GATE2011-46 Video Solution
Database table by name $\text{Loan_Records}$ ... Bank_Manager FROM Loan_Records) AS S NATURAL JOIN (SELECT Bank_Manager, Loan_Amount FROM Loan_Records) AS T ); $3$ $9$ $5$ $6$
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
11
views
gate2011
databases
sql
normal
video-solution
0
votes
0
answers
GATE2015-1-7 Video Solution
SELECT operation in SQL is equivalent to The selection operation in relational algebra The selection operation in relational algebra, except that SELECT in SQL retains duplicates The projection operation in relational algebra The projection operation in relational algebra, except that SELECT in SQL retains duplicates
asked
Apr 18, 2020
in
Databases
by
admin
(
573
points)
|
6
views
gate2015-1
databases
sql
relational-algebra
easy
video-solution
Page:
1
2
next »
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
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Recent Posts
New GATEOverflow PDFs
Guidelines to users
No Recent Blog Comments
9,092
questions
3,152
answers
14,579
comments
95,935
users