Recent questions tagged sql

dbms sql
i don't know the actual answer for the question according to me answer should be A please confirm it

560 views

Shivani gaikawad asked Nov 3, 2018

0 votes

1 answer

185

i don't know the actual answer for the questionaccording to me answer should be A please confirm it

dbms sql
i don't know the actual answer for the question according to me answer should be A please confirm

673 views

Shivani gaikawad asked Nov 3, 2018

0 votes

0 answers

186

i don't know the actual answer for the questionaccording to me answer should be A please confirm

dbms sql
i don't know the actual answer for the question according to me answer should be 5

378 views

Shivani gaikawad asked Nov 3, 2018

0 votes

0 answers

187

i don't know the actual answer for the questionaccording to me answer should be 5

dbms sql
i don't know the actual answer for the question

573 views

Shivani gaikawad asked Nov 3, 2018

0 votes

1 answer

188

i don't know the actual answer for the question

dbms questions sql
i don't know the actual answer for the question according to me answer should be 127

493 views

Shivani gaikawad asked Nov 3, 2018

0 votes

0 answers

189

i don't know the actual answer for the questionaccording to me answer should be 127

Gateforum Test Series: Databases - Sql
What will be the result of this query? Select item from inventory i where (Select count(*) from inentory j where j.stock>i.stock)<3; Bottom 3 items of the stock Top 3 items of the stock Top 2 items of the stock Bottom 2 items of the stock Isn't the answer A? But B is provided as an answer.

1.4k views

Shivani gaikawad asked Nov 3, 2018

1 votes

1 answer

190

What will be the result of this query?Select item from inventory i where (Select count(*) from inentory j where j.stock>i.stock)<3;Bottom 3 items of the stockTop 3 items ...

Gateforum Test Series: Databases - Sql

516 views

Gupta731 asked Nov 3, 2018

0 votes

0 answers

191

Gateforum Test Series: Databases - Sql

696 views

Gupta731 asked Nov 3, 2018

0 votes

1 answer

192

DBMS (2nd Ed.) By RaghuramKrishnan
SELECT sname FROM s WHERE NOT EXISTS ( SELECT * FROM b WHERE NOT EXISTS ( SELECT * FROM r WHERE r.sid=s.sid AND r.bid=b.bid)) how to understand these query please explain

239 views

Gupta731 asked Nov 1, 2018

1 votes

0 answers

193

SELECT sname FROM s WHERE NOT EXISTS ( SELECT * FROM b WHERE NOT EXISTS ( SELECT * FROM r WHERE r.sid=s.sid AND r.bid=b.bid))how to understand these query please explain

Prince Sindhiya

581 views

Prince Sindhiya asked Oct 27, 2018

0 votes

0 answers

194

GateForum Test Series: Databases - Sql
The answer should be D, but C is provided as the answer.

The answer should be D, but C is provided as the answer.

test series
Question: 11 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>, < ... respectively i'm not getting the second query. what does except all will make a difference from except? according to me both will give the same answer. please explain.

645 views

Gupta731 asked Oct 24, 2018

1 votes

0 answers

195

Question: 11 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>, ...

aambazinga

1.2k views

aambazinga asked Oct 24, 2018

0 votes

1 answer

196

SQL sub query

Anand Yadav

423 views

Anand Yadav asked Oct 17, 2018

0 votes

0 answers

197

Assertions in SQL-Self Doubt
Whenever Assertions are created, the predicate that the Assertion specifies must hold true at the time of assertion creation. Now Whenever we make changes to any table in the database, do all the assertions present in the database are checked ... all Assertions are checked and executed (Even when some assertions are not related to the tables which have been changed)?

Whenever Assertions are created, the predicate that the Assertion specifies must hold true at the time of assertion creation.Now Whenever we make changes to any table in ...

Ayush Upadhyaya

259 views

Ayush Upadhyaya asked Oct 14, 2018

0 votes

1 answer

198

Test Series
From the following statements which of them is/are true about SQL a) All attributes used in the group by clause must appear in the select clause b) An SQL query can contain a having clause only if it has a group by clause c) An SQL query can contain a having ... if it does not have a group by clause d) Not all attributes used in the group by clause need to appear in the select clause

From the following statements which of them is/are true about SQLa) All attributes used in the group by clause must appear in the select clauseb) An SQL query can contain...

Manas Mishra

2.7k views

Manas Mishra asked Oct 14, 2018

0 votes

0 answers

199

DBMS doubt
Can someone derive it with table https://gateoverflow.in/242014/dbms-raghu-ramakrishnan?show=243128 I am still unable to get proper answer by hand

Can someone derive it with tablehttps://gateoverflow.in/242014/dbms-raghu-ramakrishnan?show=243128I am still unable to get proper answer by hand

srestha

362 views

srestha asked Oct 6, 2018

0 votes

0 answers

200

Database system concepts 3rd chapter question 3.6
Consider the sql query Select p.a1 From p,r1,r2 Where p.a1 = r1.a1 or p.a1 = r2.a1 Under what conditions does the preceding query select values of p.a1 that are either in r1 or in r2?Examine carefully the cases where one of r1 or r2 may be empty.

Consider the sql querySelect p.a1 From p,r1,r2 Where p.a1 = r1.a1 or p.a1 = r2.a1Under what conditions does the preceding query select values of p.a1 that are either in r...

sid2601678

1.5k views

sid2601678 asked Oct 4, 2018

0 votes

0 answers

201

ISI2016-PCB-CS-4
Commodity items have some positive or negative changes in their prices each week. Each trading company picks a portfolio of commodity items, that is, they have one or more items and they own some non-zero quantity of each one. The database table for this problem ... and there exists at least one company selling that item only. (i.e., not selling any other item) in that week.

Commodity items have some positive or negative changes in their prices each week. Each trading company picks a portfolio of commodity items, that is, they have one or mor...

go_editor

264 views

go_editor asked Sep 18, 2018

0 votes

0 answers

202

SQL query with NOT IN connective.
a) 0 b) 1 c) 2 d) 3

a) 0 b) 1 c) 2 d) 3

Nirmal Gaur

571 views

Nirmal Gaur asked Sep 15, 2018

0 votes

1 answer

203

nptel assingnment sql

385 views

mukul maurya asked Sep 1, 2018

0 votes

1 answer

204

286 views

mukul maurya asked Sep 1, 2018

0 votes

1 answer

205

531 views

mukul maurya asked Sep 1, 2018

0 votes

1 answer

206

1.1k views

mukul maurya asked Sep 1, 2018

0 votes

1 answer

207

339 views

mukul maurya asked Sep 1, 2018

0 votes

1 answer

208

NPTEL assignment sql