Register

Web Page

ER‐model. Relational model:Relational algebra, Tuple calculus, SQL. Integrity constraints, Normal forms. File organization, Indexing (e.g., B and B+ trees). Transactions and concurrency control.

$$\scriptsize{\overset{{\large{\textbf{Mark Distribution in Previous GATE}}}}{\begin{array}{|c|c|c|c|c|c|c|c|}\hline
\textbf{Year}& \textbf{2024-1}& \textbf{2024-2} &\textbf{2023} &\textbf{2022} & \textbf{2021-1}&\textbf{2021-2}&\textbf{Minimum}&\textbf{Average}&\textbf{Maximum}
\\\hline\textbf{1 Mark Count} &4&4&1& 3 &2&1&1&2.5&4
\\\hline\textbf{2 Marks Count} &2&2&2& 2&3&3&2&2.33&3
\\\hline\textbf{Total Marks} & 8&8&5& 7 &8&7&\bf{5}&\bf{7.16}&\bf{8}\\\hline
\end{array}}}$$

Filter

Recent questions in Databases

0 votes
0 answers
221
Time Stamp Protocol
Need help in time stamp ordering .
Need help in time stamp ordering .
User Avatar
1 votes
0 answers
222
Thomas write rule
Need some help , In this question W3(B) , W2(B) is allowed in TWR bit confuse between option b and d . Plz help me which option is correct between b and d with proper justification.
Need some help , In this question W3(B) , W2(B) is allowed in TWR bit confuse between option b and d . Plz help me which option is correct between b and d with proper jus...
User Avatar
0 votes
1 answer
223
Databases
Somebody please verify the answer
Somebody please verify the answer
User Avatar
0 votes
0 answers
224
Databases
What is the meaning of first option
What is the meaning of first option
User Avatar
1 votes
1 answer
225
Databases
Someone Please Solve it​
Someone Please Solve it​
User Avatar
0 votes
0 answers
226
concurrency control
question about concurrency control methods
question about concurrency control methods
User Avatar
0 votes
0 answers
228
HCU PHD 2018 JUNE
Suppose there are three relations as given below: (x) R(a,b)= (0,1),(4,5),(8,9). (y) S(b,c )=(1,2),(5,2),(5,6),(5,10),(13,10). (z) T( c,d)=(2,3),(6,7)(10,11),(10,3) the number of tuples in (R * S) * T, where * is the full natural outer join, is: (a) 5 (b) 8 (c) 13 (d) 60
Suppose there are three relations as given below:(x) R(a,b)= (0,1),(4,5),(8,9).(y) S(b,c )=(1,2),(5,2),(5,6),(5,10),(13,10).(z) T( c,d)=(2,3),(6,7)(10,11),(10,3)the numbe...
User Avatar
0 votes
1 answer
229
HCU PHD 2019 May
if E1 and E2 are relational algebra expressions then which of the following is NOT a relational algebra expression (a) E1 U E2 (b) E1 X E2 (c) E1 - E2 (d) E1 / E2
if E1 and E2 are relational algebra expressions then which of the following is NOT a relational algebra expression(a) E1 U E2(b) E1 X E2(c) E1 - E2(d) E1 / E2
User Avatar
0 votes
2 answers
230
KVS Dec 2018
in relational databases, the natural join of two tables is (a) cartesian product always (b) combination of union and filtered cartesian product (c) combination of selection and filtered cartesian product (d) combination of projection and filtered cartesian product
in relational databases, the natural join of two tables is(a) cartesian product always(b) combination of union and filtered cartesian product(c) combination of selection ...
User Avatar
0 votes
1 answer
231
KVS Part B 2018
______ operation preserves those tuples that would be lost in____ (a) Natural join, Outer join (b) Outer join, Natural join (c) Left Outer Join, Right Outer Join (d) Left Outer Join, Natural Join
______ operation preserves those tuples that would be lost in____(a) Natural join, Outer join(b) Outer join, Natural join(c) Left Outer Join, Right Outer Join(d) Left Out...
User Avatar
0 votes
2 answers
233
NIELIT 2016
a tuple in relation DBMS is a equivalent to (a) Record (b) Field (c) File (d) Database
a tuple in relation DBMS is a equivalent to(a) Record(b) Field(c) File(d) Database
User Avatar
0 votes
1 answer
234
TNPSC 2017
the materialization approach of query evaluation includes (from root to leaf) : (a) π, ∞, σ (b) π, σ, ∞ (c) σ, π, ∞ (d) σ, ∞, π
the materialization approach of query evaluation includes (from root to leaf) :(a) π, ∞, σ(b) π, σ, ∞(c) σ, π, ∞(d) σ, ∞, π
User Avatar
0 votes
2 answers
235
TNPSC 2017
___________ operator is used to retain the unmatched rows of relations when they joined. (a) Outer Join (b) Inner Join (c) Natural Join (d) Self Join
___________ operator is used to retain the unmatched rows of relations when they joined.(a) Outer Join(b) Inner Join(c) Natural Join(d) Self Join
User Avatar
0 votes
2 answers
236
CIL
which of the following is a unary operation? (a) intersection (b) projection (c) join (d) cartesian Product
which of the following is a unary operation?(a) intersection(b) projection(c) join(d) cartesian Product
User Avatar
0 votes
1 answer
237
CIL 2020
the ____ defines a set of operations on relations, paralleling the usual algebraic operations such as addition, subtraction or multiplication, which operates on numbers. (a) Relational Calculas (b) Referential Integrity (c) Relational Algebra (d) Relations
the ____ defines a set of operations on relations, paralleling the usual algebraic operations such as addition, subtraction or multiplication, which operates on numbers.(...
User Avatar
0 votes
1 answer
238
CIL
relations and fields can be renamed in relational algebra using the renaming operator (a) ρ (b) σ (c) ∅ (d) ⟕
relations and fields can be renamed in relational algebra using the renaming operator(a) ρ(b) σ(c) ∅(d) ⟕
User Avatar
0 votes
1 answer
240
CIL, UPPCL AE CS 2019
Consider the relation schemas R(A, B, C, D) and S(D, E, F). What will be the degree of the resultant schema R * S, where star (*) symbol represents the natural join operation? (A) 3 (B) 4 (C) 6 (D) 5
Consider the relation schemas R(A, B, C, D) and S(D, E, F). What will be the degree of the resultant schema R * S, where star (*) symbol represents the natural join opera...
User Avatar
Page: