Register

Recent questions tagged goclasses-da-dpp-day-290

0 0 votes
1 1 answer
101
101 views
GO Classes DPP | GATE CS, DA | DBMS | Nested Query
Relevant relations are:$\mathrm{BUILDING(BID,\ BName,\ Address)}$$\mathrm{IN\_BUILDING(EID,\ BID)}$Which of the following queries correctly find the names of buildings wh...
User Avatar
0 0 votes
1 1 answer
81
81 views
GO Classes DPP | GATE CS, DA | DBMS | NOT IN Query Equivalence
Consider relations:$\mathrm{Product}$$\mathrm{Inventory}$where the underlined attributes in the original examination are primary keys.The following query returns product ...
User Avatar
0 0 votes
1 1 answer
69
69 views
GO Classes DPP | GATE CS, DA | DBMS | IN Subquery Equivalence
Consider,SELECT DISTINCT TBL1.COL1 FROM TBL1 WHERE COL1 IN (SELECT COL1 FROM TBL2);Which SQL statement produces the same result?SELECT DISTINCT TBL1.COL1 FROM TBL1 UNION ...
User Avatar
1 1 vote
2 2 answers
92
92 views
GO Classes DPP | GATE CS, DA | DBMS | Duplicate Tuples
Consider the relation $R(a,b)$. The relation may contain duplicate tuples.Which of the following queries are guaranteed not to contain duplicate tuples, regardless of the...
User Avatar
0 0 votes
1 1 answer
133
133 views
GO Classes DPP | GATE CS, DA | DBMS | Nested Query
Three relations with the same schema are maintained for three regions:$\mathrm{TokyoProduct}$, $\mathrm{NagoyaProduct}$, and $\mathrm{OsakaProduct}$$\mathrm{ProductNo}$ i...
User Avatar
To see more, click for the full list of questions or popular tags.