Register

Recent questions tagged sql

4 votes
0 answers
241
DBMS query
User Avatar
3 votes
0 answers
242
SQL Query
Why this Query is illigal? i.e. Answer given is option C I tried this on W3school IDE it is giving result as option A.
Why this Query is illigal? i.e. Answer given is option CI tried this on W3school IDE it is giving result as option A.
User Avatar
2 votes
2 answers
243
SQL quary
User Avatar
1 votes
0 answers
245
SQL....
Why Q1 not correct? Because it is fetching any red part and not every red part,right?? Why Q2 is not correct query? It takes 2 tables and comparing. Is it not fetching single red value?
Why Q1 not correct? Because it is fetching any red part and not every red part,right??Why Q2 is not correct query? It takes 2 tables and comparing. Is it not fetching si...
User Avatar
1 votes
1 answer
246
Natural join
My answer is not matching with any of the option.so what is the correct answer
My answer is not matching with any of the option.so what is the correct answer
User Avatar
1 votes
0 answers
247
SQL Gateforum
A relation schema for a bus reservation is given below. Bus(BusNo, Bname, travel-agent) Passenger (Pid,pname,age) Reservation (Pid,class,travel-Agent)
A relation schema for a bus reservation is given below.Bus(BusNo, Bname, travel-agent)Passenger (Pid,pname,age)Reservation (Pid,class,travel-Agent)
User Avatar
3 votes
0 answers
249
safe query
Is the query below safe? {t | ∃u ∈ EMP(t[EmpName] = u[EmpName] ∧ ∀v ∈ DEPT(t[DeptId] == v[DeptId]))} Please explain why.
Is the query below safe? {t | ∃u ∈ EMP(t[EmpName] = u[EmpName] ∧ ∀v ∈ DEPT(t[DeptId] == v[DeptId]))}Please explain why.
User Avatar
1 votes
2 answers
250
TEST SERIES ( ALL Keyword)
what will be the output(how many tupples)
what will be the output(how many tupples)
User Avatar
3 votes
0 answers
251
SQL QUERY NOT EXISTS
How to solve this?
How to solve this?
User Avatar
1 votes
0 answers
253
Sql database
Provide the answer
Provide the answer
User Avatar
1 votes
1 answer
254
Sql query gate
Provide the correct answer
Provide the correct answer
User Avatar
0 votes
0 answers
255
Sql,gate
my answer is :: selection with cross Please explain the current answer
my answer is :: selection with cross Please explain the current answer
User Avatar
1 votes
1 answer
257
Virtual Gate Test Series: Databases - Sql query
Consider the following instance R. A 1 2 3 4 B Null 1 2 2 The number of tuples returned by the following SQL query is _____________. > select * from R as R1 where not exists (select * from R) where B = R1.A
Consider the following instance R.A1234BNull122The number of tuples returned by the following SQL query is _____________. select * from R as R1 where not exists (select...
User Avatar
1 votes
1 answer
259
SQL query
Found randomly somewhere: i think multiple answers possible?
Found randomly somewhere:i think multiple answers possible?
User Avatar
0 votes
0 answers
262
SQL and trc
How to solve SQL problems related to subqueries quickly? Though I have concepts still I face some difficulties in solving this problems
How to solve SQL problems related to subqueries quickly?Though I have concepts still I face some difficulties in solving this problems
User Avatar
5 votes
1 answer
264
ISRO-DEC2017-11
Consider the schema $\text{Sailors(sid,sname,rating,age) with the following data}$ ... $6$ $5$ $4$ $3$
Consider the schema$\text{Sailors(sid,sname,rating,age) with the following data}$$\begin{array}{|l|l|l|l|} \hline \textbf{sid} & \textbf{sname} & \textbf{rating} & \textb...
User Avatar
0 votes
0 answers
266
DBMS sql query on null
Student table ROLLNO NAME MARKS1 MARKS2 1 T 50 30 2 S 70 99 3 D NULL 10 NULL NULL 78 NULL NULL NULL NULL NULL a) select count(MARKS1) from student; b) select count(*) from student;
Student tableROLLNONAMEMARKS1MARKS21T50302S70993DNULL10NULLNULL78NULLNULLNULLNULLNULLa) select count(MARKS1) from student;b) select count(*) from student;
User Avatar
1 votes
0 answers
269
# FILE AND SQL
User Avatar
0 votes
0 answers
270
Ace Test Series: Databases - Sql
User Avatar
Page: