Recent questions tagged sql - GATE CSE Doubts

0 votes

0 answers

Madeeasy Test series
Coaching (cname, city) Travel (name, city) Select T1.name from Travel T1 where Not Exist (Select M.city FROM Coaching M where M.cname = madeeasy EXCEPT Select T2.city from Travel T2 where T1.name = T2.name) The above query returns the name of the ... city where madeeasy is located. who have not travelled in all city where madeeasy is located. N.B - This is a 1 mark question.

asked Oct 5 in Databases by MRINMOY_HALDER (32 points) | 18 views

0 votes

0 answers

DBMS self clearance
Can someone explain me group by and having clause in a clear way.

asked Sep 17 in Databases by Priyansh Singh (41 points) | 7 views

0 votes

0 answers

SQL self doubt
ENo SSN 1 15 2 20 3 15 4 null 5 null Relation R SELECT SSN,count(*) FROM R GROUP BY SSN Will the output be: SSN count 15 2 20 1 null 2 SSN count 15 2 20 1 null 1 null 1 SSN count 15 2 20 1

asked Sep 12 in Databases by Sambhrant Maurya (271 points) | 10 views

0 votes

1 answer

referential integrity in DBMS
1. There are 2 relations: gate2016 (exam_date, exam_center, branch_id) and candidate (rollno, name, bid, refno, choice_of_date). In a candidate relation, bid is the foreign key which refers to the key of gate2016. Suppose an insertion into ... can cause inconsistency (c) Both operations can cause inconsistency of data (d) None of them can cause inconsistency of data

asked Aug 26 in Databases by Maguluri Bhaskar (10 points) | 29 views

0 votes

1 answer

SQL question DBMS
Kindly show the output also. Thank you.

asked Aug 4 in Databases by DukeThunders (197 points) | 21 views

0 votes

0 answers

VIRTUAL GATE SQL
Query1: SELECT eno FROM emp WHERE deptno=10 union SELECT eno FROM emp WHERE deptno=20 Query2: SELECT eno FROM emp WHERE deptno=10 or deptno=20 Let the result of Queryl is Q1 and the result of Query2 is Q2, then which of the following is always true? (A) Q1=Q2 (B) Q1 $\subseteq$ Q2 (C) Q2 $\subseteq$ Q1 (D) Data is insufficient

asked Jul 30 in Databases by aditi19 (44 points) | 9 views

To see more, click for the full list of questions or popular tags.

1,680 questions

1,088 answers

4,554 comments

89,591 users