The Gateway to Computer Science Excellence
For all GATE CSE Questions
Toggle navigation
Facebook Login
or
Email or Username
Password
Remember
Login
Register

I forgot my password
Activity
Questions
Unanswered
Tags
Subjects
Users
Ask
Prev
Blogs
New Blog
Exams
First time here? Checkout the
FAQ
!
x
×
Close
Use the google search bar on side panel. It searches through all previous GATE/other questions. For hardcopy of previous year questions please see
here
Recent questions tagged gb2019dbms1
+1
vote
1
answer
1
GATEBOOK2019DBMS11
Given two relations $R_1$ and $R_2,$ where $R_1$ contains $N_1$ tuples, $R_2$ contains $N_2$ tuples, and $N_2 > N_1 > 0,$ give the minimum possible sizes (in tuples) for the resulting relation produced by each of the following relational algebra expressions. In each case, state any assumptions ... $(1)  N_2; (2)  0; (3)  0; (4)  N_1 \times N_2; (5)  N_1$
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

230
views
gb2019dbms1
relationalalgebra
0
votes
1
answer
2
GATEBOOK2019DBMS12
Suppliers(sid: integer, sname: string, address: string) Parts(pid: integer, pname: string, color: string) Catalog(sid: integer, pid: integer, cost: real) Suppose we want to find names of those suppliers who supply all the parts. Consider the following ... .sid) Which of the following query is the correct implementation of above requirement ? Only Q1 Only Q2 Both Q1 and Q2 None
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

91
views
gb2019dbms1
+1
vote
1
answer
3
GATEBOOK2019DBMS13
Suppose that two relations $R(A, B)$ and $S(A, B)$ have exactly the same schema. Consider the following equalities in relational algebra? $R \cap S = R  (R  S)$ $R \cap S = S  (S  R)$ $R \cap S = R \text{ NATURALJOIN }S$ $R \cap S = R \times S$ Which of the equalities hold in relational algebra? I only I and II only I, II and III I, II, III and IV
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

145
views
gb2019dbms1
+1
vote
1
answer
4
GATEBOOK2019DBMS14
The table Arc(x,y) currently has the following tuples (note there are duplicates): $(1,2), (1,2), (2,3), (3,4), (3,4), (4,1), (4,1), (4,1), (4,2).$ Compute the result of the query: SELECT a1.x, a2.y, COUNT(*) FROM Arc a1, Arc a2 WHERE a1.y = a2.x GROUP BY a1 ... following tuples is in the result? $(1,3,2)$ $(2,4,6)$ $(3,1,4)$ $(3,1,6)$ I and III I and II I and IV II and III
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

85
views
gb2019dbms1
sql
+1
vote
1
answer
5
GATEBOOK2019DBMS15
The relation $R(a,b)$ may have duplicate tuples. Which of the following queries has a result that is guaranteed not to have duplicates, regardless of what tuples $R$ contains? SELECT a FROM R WHERE a = 1 SELECT MAX(b) FROM R GROUP BY a SELECT a, b FROM R GROUP BY a, b SELECT a FROM R WHERE a NOT IN (SELECT a FROM R) III and IV I and II III only I and III
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

86
views
gb2019dbms1
+3
votes
1
answer
6
GATEBOOK2019DBMS16
Consider the following database schema: Frequents(kid, store) Sells(store, candy) Likes(kid, candy) Table Frequents indicates what candy stores a kid likes to visit. Table Sells shows which candy each store sells. Table Likes tells which candy a kid likes. ... candies are all sold by the store 'Starbucks'. the kids whose liked candies are sold by stores other than 'Starbucks'
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

133
views
gb2019dbms1
sql
+4
votes
1
answer
7
GATEBOOK2019DBMS17
Consider a relation $R(A,B)$, and the following two sequences of queries. Q1: UPDATE R SET B = 3 WHERE B = 2; Q2: INSERT INTO R SELECT A, 3 FROM R WHERE B = 2; DELETE FROM R WHERE B = 2; Which of the following statements is TRUE? Q1 ... produce the same answer. The answer to Q1 is always contained in the answer to Q2 The answer to Q2 is always contained in the answer to Q1.
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

97
views
gb2019dbms1
+1
vote
1
answer
8
GATEBOOK2019DBMS18
Suppose we have a relation declared by: CREATE TABLE R(name VARCHAR(50) PRIMARY KEY, salary INT CHECK(salary \leq 40000) ); Initially, the relation has three records: Name Salary Tom 10000 Joe 20000 Sue 30000 We execute the following sequence of modifications. Some of them may be ... , the sum of the salaries over all the tuples in $R$ is: $52,000$ $62,000$ $65,000$ $72,000$
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

67
views
gb2019dbms1
+2
votes
1
answer
9
GATEBOOK2019DBMS19
Suppose relation $R(A,B)$ has tuples $\{(1,2), (1,2), (3,4)\}$, and relation $S(B,C)$ has ${(2,5), (2,5), (4,6), (7,8)}$. What is the number of tuples in the result of the SQL query: SELECT * FROM R NATURAL RIGHT OUTER JOIN S; $2$ $3$ $5$ $6$
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

86
views
gb2019dbms1
+1
vote
1
answer
10
GATEBOOK2019DBMS110
Given two relations $R(A,B)$ and $S(C)$, consider two queries: Q1: SELECT A FROM R WHERE R.B > ALL (SELECT C FROM S); Q2: SELECT A FROM R WHERE R.B > ANY (SELECT C FROM S); Which of the following statements is TRUE? Q1 and Q2 ... . The answer to Q1 is always contained in the answer to Q2. The answer to Q2 is always contained in the answer to Q1. None of the above.
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

85
views
gb2019dbms1
0
votes
1
answer
11
GATEBOOK2019DBMS111
Consider a relation $R(A)$ and the following two queries. Q1: SELECT A FROM R r1 WHERE NOT EXISTS (SELECT * FROM R WHERE A > r1.A); Q2: SELECT MAX(A) FROM R; Let $\mid Q1 \mid$ and $\mid Q2 \mid$ be the number of the tuples in the results of Q1 and Q2, ... $\mid Q1 \mid \leq \mid Q2 \mid$ is always true. $\text{None of the above}$
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

56
views
gb2019dbms1
+5
votes
1
answer
12
GATEBOOK2019DBMS112
The SQL statement 'DELETE from R;' is guaranteed to remove all the tuples from R. may remove just some tuples from R. may also remove tuples in tables other than R. will drop table R from the database.
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

120
views
gb2019dbms1
+1
vote
0
answers
13
GATEBOOK2019DBMS113
It is not possible to capture which ER concept in a relational schema? Onetoone relationships. Onemany mandatory participation. Manymany mandatory participation. Ternary relationships.
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

146
views
gb2019dbms1
+2
votes
2
answers
14
GATEBOOK2019DBMS114
EMPLOYEE: ename, eid, dno, salary DEPARTMENT: dno, dname Consider the below tuple relational calculus query ... the employee with the highest salary among all employees. Who work in the department that has the employee with the lowest salary among all employees
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

87
views
gb2019dbms1
0
votes
0
answers
15
GATEBOOK2019DBMS115
Consider the relation employee(name, sex, supervisorName, salary) with name as the key, supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce? ... than salaries of their subordinates. Names of female employees whose salary is greater than the salaries of their subordinates.
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

35
views
gb2019dbms1
+1
vote
1
answer
16
GATEBOOK2019DBMS116
Which of the following tuple relational calculus query is unsafe query? $\{x\mid \exists x\in T(x.A\neq 500)\}$ $\{x\mid \forall x\in T(x.A\neq 500)\}$ $\{x\mid \neg (\forall x\in T(x.A\neq 500))\}$ Only III Only II and III Only I and III All of I,II and III
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

76
views
gb2019dbms1
+1
vote
1
answer
17
GATEBOOK2019DBMS117
Which of the following entity sets or relationships does not get converted to a relation? B C R S
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

77
views
gb2019dbms1
erdiagram
+1
vote
2
answers
18
GATEBOOK2019DBMS118
Which of the following is not a property of ACID transactions ? Atomicity Concurrency Durability Isolation
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

56
views
gb2019dbms1
0
votes
0
answers
19
GATEBOOK2019DBMS119
Consider the following SQL queries: Q1: Select distinct a from R where b>0; Q2: Select distinct a from R where b>0 group by a; Q1 and Q2 produce the same answer. The answer to Q1 is always contained in the answer to Q2. The answer to Q2 is always contained in the answer to Q1. Q1 and Q2 produce different answers.
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

29
views
gb2019dbms1
+3
votes
0
answers
20
GATEBOOK2019DBMS120
Which of the following queries might produce different results when evaluated using set semantics and bag (multiset) semantics, even if the relations $R$ and $S$ are themselves sets (i.e., they contain no duplicate tuples)? $R−S$ $R\bowtie S − S \bowtie R$ $R \cup S$ $\sigma_{a=5}(R)$
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

89
views
gb2019dbms1
relationalalgebra
+1
vote
2
answers
21
GATEBOOK2019DBMS121
Which of the following tuple relational calculus expressions is equivalent to $\exists t \in r F(t)$ ? $\neg (\forall t \in r \neg F(t))$ $\neg (\forall t \in r F(t))$ $\exists t \in r \neg F(t))$ $\exists t \notin r F(t))$
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

58
views
gb2019dbms1
+1
vote
0
answers
22
GATEBOOK2019DBMS122
Graph $(V_i,V_j)$ is a relation which records adjacency information of an undirected graph. Tuple (a,b) represents the adjacency between vertices a and b. Consider the following statements There is a route from some vertex A to some vertex B in the ... of the above statements can be represented in Tuple Relational Calculus ? Only I Only II and III Only I and III Only III
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

65
views
gb2019dbms1
+2
votes
1
answer
23
GATEBOOK2019DBMS123
Consider a relation R(A,B) that contains r tuples, and a relation S(B,C) that contains s tuples. Assume $r>0, s>0.$ Make no assumptions about keys. Consider the below query. $\Pi_B(R)−(\Pi_B(R)−\Pi_B(S))$ Minimum and Maximum no of tuples above query can produce ? Max (r,s), r+s $0,r \times s$ 0, Min (r,s) r,r
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

56
views
gb2019dbms1
+2
votes
1
answer
24
GATEBOOK2019DBMS124
Consider the following relation: Family(parent, child, childDOB) The intent is that a tuple (p,c,d) means that parent p has child c, who was born on date d. You may assume that parents do not have two children of the same name, and that there are no ... of 'Raju.' Which of the above queries are expressible in relational algebra? I only I and II only III only I, II and III
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

97
views
gb2019dbms1
0
votes
1
answer
25
GATEBOOK2019DBMS125
Consider the following E/R diagram: Below are three possible relationship sets for this E/R diagram: $A$ $B$ $C$ $D$ $a_1$ $b_1$ $c_1$ $d_1$ $a_1$ $b_1$ $c_1$ $d_2$ $A$ $B$ $C$ $D$ $a_1$ $b_1$ $c_1$ $d_1$ $a_1$ $b_1$ $c_2$ $d_2$ ... not equal to $d_2$. Which of the above could not be the relationship set for the E/R diagram? I Only I and II Only II Only I,II and III
asked
Nov 30, 2018
in
Databases
by
GATEBOOK
Boss
(
11.4k
points)

90
views
gb2019dbms1
To see more, click for the
full list of questions
or
popular tags
.
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
IIITH Preparation and interview experience (M.Tech CSE)
My Journey To iiiTH Mtech Cse 2019
IIIT H INTERVIEW EXPERIENCE 2019
IIITH Interview Experience
Thanks GO!!
Follow @csegate
Recent questions tagged gb2019dbms1
Recent Blog Comments
Ordering is stopped for now. Will resume after a...
what?
how to buy these books sir??? can we buy from...
You all will get the email tonight.
Hi I have made the payment on
June...
49,576
questions
54,181
answers
187,498
comments
71,142
users