Register

Recent questions tagged query

0 0 votes
0 0 answers
752
752 views
NIELIT 2022 April Scientist B | Section B | Question: 115
The employee information in a company is stored in the relationEmployee (name, sex, salary, deptName)Consider the following $\text{SQL}$ querySelect deptName From Employe...
User Avatar
0 0 votes
1 1 answer
693
693 views
UGC NET CSE | December 2019 | Part 2 | Question: 20
Which of the component module of $\text{DBMS}$ does rearrangement and possible ordering of operations, eliminate redundancy in query and use efficient algorithms and ind...
User Avatar
2 2 votes
3 3 answers
2.9k
2.9k views
UGC NET CSE | December 2019 | Part 2 | Question: 22
Given two tablesEMPLOYEE (EID, ENAME, DEPTNO) DEPARTMENT (DEPTNO, DEPTNAME)Find the most appropriate statement of the given query:Select count (*) ‘total’ from EMPLOYEE w...
User Avatar
1 1 vote
2 2 answers
2.2k
2.2k views
UGC NET CSE | December 2007 | Part 2 | Question: 20
Consider the query :SELECT student_name FROM students WHERE class_name=(SELECT class_name FROM students WHERE math_marks=100);what will be the output ?the list of names o...
User Avatar
1 1 vote
3 3 answers
2.6k
2.6k views
Raghuramkrishnan 3e Exercise 5.1 Question no-5 page no-175 SQL
Class(name, meets_at, room, fid)Faculty(fid, fname, deptid)Find the names of faculty members who teach in every room in which some class is taught
User Avatar
0 0 votes
0 0 answers
1.1k
1.1k views
Molina Exercise-6.3.1 Question no-f Page no-280 SQL
Product(maker, model, type)PC(model, speed, ram, hd, price)Laptop(model, speed, ram, hd, screen, price)Printer(model, color, type, price)Find the maker(s) of the PC(s) wi...
User Avatar
5 5 votes
1 answers 1 answer
3.5k
3.5k views
FAQ-7
Is it ok to drop for 2nd time for GATE ? i.e. dropping for giving GATE 3rd time in a row ? Please give your opinions.
User Avatar
0 0 votes
0 0 answers
1.0k
1.0k views
DBMS SUBJECT TEST
Let Depositor and Lender be relational schemas such that Depositor = {a/c number, cname , balance, branch} and Lender ={loan_number ,cname, amount , branch}. Now consider...
User Avatar
0 0 votes
0 0 answers
648
648 views
Gate 2019
Sir when u will make gate 2019 civil response sheet evaluator sir
User Avatar
1 1 vote
1 1 answer
1.0k
1.0k views
Gate 2019
Hello people, Which are the questions you think were ambiguous in paper and should not be included in the final gate evaluation.Please mention your views.
User Avatar
0 0 votes
0 0 answers
854
854 views
MadeEasy Test Series: Databases - Sql
I got why query 2 is wrong. How do I approach to understand Query 1, is there a generic approach for solving questions like these which have no tables given?
User Avatar
0 0 votes
0 0 answers
1.2k
1.2k views
DBMS:SQL
Consider the following ORACLE relations:One (x, y) = {<2, 5>, <1, 6>, <1, 6>, <1, 6>, <4, 8>, <4, 8>}Two (x, y) = {<2, 55>, <1, 1>, <4, 4>, <1, 6>, <4, 8>, <4, 8>, <9, 9>...
User Avatar
1 1 vote
0 0 answers
2.1k
2.1k views
Unsafe TRC Query
Consider a database that has the relation schemas EMP(EmpId, EmpName, DeptId), and DEPT(DeptName, DeptId). Note that the DeptId can be permitted to be NULL in the relatio...
User Avatar
1 1 vote
1 1 answer
2.5k
2.5k views
Ace Test Series: DBMS - Correlated Sql Query
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
User Avatar
0 0 votes
0 0 answers
1.2k
1.2k views
SQL Query
Suppose there are two tuples in Animals relation with different IDs but of same type and in Adoption table there is a tuple with an ID that matches with the ID of first ...
User Avatar
0 0 votes
1 1 answer
1.7k
1.7k views
Doubt UGC NET
https://gateoverflow.in/13365/ugcnet-dec2014-iii-24i’ve a small doubt in the solution of this questionhow is (a+b)*ba(a+b)* complement of the given language?
User Avatar
0 0 votes
1 1 answer
1.3k
1.3k views
gfg dbms quiz
Consider the following relational schema : Employee ( Empid, Deptid, Salary ) Department ( Deptid, DeptName ) What does the following query return ?Query_1 :- S...
User Avatar
0 0 votes
0 0 answers
796
796 views
sql doubt
Given a Relation POSITION (Posting-No, Skill), then query to retrieve all distinct pairs of posting-nos requiring skill is1.Select p1.posting-No, p2.posting-No from posit...
User Avatar
1 1 vote
0 0 answers
648
648 views
Database-TRC and RA
Consider two relation schemas$R(A,B,C)$ and $S(D,E,F)$Give an expression in the tuple relational calculus that is equivalent to each of the following.(a)$\pi_A(r)$ ->$\{t...
User Avatar
1 1 vote
1 1 answer
893
893 views
made easy test series
User Avatar
0 0 votes
1 1 answer
842
842 views
SQL self doubt
In this question:-https://gateoverflow.in/8225/gate2015-1-27I am not understanding how the query is returning 2 .I think DISTINCT must be there to give the correct answer...
User Avatar
0 0 votes
1 1 answer
1.6k
1.6k views
dbms sql
i don't know the actual answer for the questionaccording to me answer should be A please confirm it
User Avatar
0 0 votes
1 1 answer
467
467 views
TANCET 2017 SQL JOINS
User Avatar
0 0 votes
0 0 answers
363
363 views
TANCET 2016 SQL
User Avatar
0 0 votes
0 0 answers
1.2k
1.2k views
SQL query with NOT IN connective.
a) 0 b) 1 c) 2 d) 3
User Avatar
0 0 votes
1 1 answer
2.1k
2.1k views
sql query
User Avatar
0 0 votes
2 2 answers
1.6k
1.6k views
SQL Query
User Avatar
1 1 vote
1 answers 1 answer
1.6k
1.6k views
TRC Database
$(e.Fname$|$ EMPLOYEE(e)\ AND\ ((\forall_{d})[ (DEPENDENT(d)\ AND\ d.ssn= e.ssn \ AND\ (d.sex='M'))\rightarrow (d.age>30))] )$ EMPLOYEE FnameSSnSexRam1MShyam2MRavi3MSita...
User Avatar
1 1 vote
1 answers 1 answer
1.2k
1.2k views
SQL Query
Consider relational schema $R(A,B,C)$ and $S(A,B,C)$$1)$ Select * from $R$ where $(A,B,C)$ in (Select * from $S$)$2)$ Select * from $R$ where exists ( Select * from $S$ w...
User Avatar
20 20 votes
2 answers 2 answers
6.5k
6.5k views
GATE CSE 1997 | Question: 76-b
Consider the following relational database schema:EMP (eno name, age)PROJ (pno name)INVOLVED (eno, pno)EMP contains information about employees. PROJ about projects and i...
User Avatar
Page: