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

8 votes
1 answer
3761
Question on Join
Let us consider 3 relations R1(ABD), R2(BCE) and R3(CF). The primary keys of R1 , R2 and R3 are A, B and C respectively. The number of tuples in R1, R2 and R3 are 50,40,80 respectively. Maximum size of R1*R2*R3 where * denotes natural join.
Let us consider 3 relations R1(ABD), R2(BCE) and R3(CF). The primary keys of R1 , R2 and R3 are A, B and C respectively. The number of tuples in R1, R2 and R3 are 50,4...
User Avatar
0 votes
2 answers
3762
3NF
Consider the following F.D. ab -> cd ; e->c ; b->ef Which options show the relations normalized to 3NF of R(A,B,C,D,E,F) 1) R(A,B,C,D) , R(C,E) , R(E,F,B) 2) R(A,B,D) , R(E,C) , R(B,E,F) 3) R(A,B,C,D) , R(C,E) , R(B,E,F) 4) R(A,B,C,D,E,F) , R(E,C) , R(B,E,F) Ans is C
Consider the following F.D.ab - cd ; e->c ; b->efWhich options show the relations normalized to 3NF of R(A,B,C,D,E,F)1) R(A,B,C,D) , R(C,E) , R(E,F,B)2) R(A,B,D) , R(E...
User Avatar
–1 votes
0 answers
3763
what is the output of following c program
User Avatar
1 votes
2 answers
3764
E-R and Relational Model
Which of the following are true for relational database? Number of rows is cardinality, number of columns is degree Tuple is an entity, column is a relation Relation is an entity, tuple is a relationship Row is a tuple, column is an attribute b & d a & d b & c c & d
Which of the following are true for relational database?Number of rows is cardinality, number of columns is degreeTuple is an entity, column is a relationRelation is an e...
User Avatar
0 votes
1 answer
3765
find the number of execution of inner query????
Find the number of times the inner query will executed for the following query, if the number of tuples in R(A,B) and S(D,E) contains 10 and 20 respectively. Select * From R Where exists ( select * From S Where A=D);
Find the number of times the inner query will executed for the following query, if the number of tuples in R(A,B) and S(D,E) contains 10 and 20 respectively.Select *From ...
User Avatar
5 votes
4 answers
3766
ISRO2011-46
Which $\textsf{RAID}$ level gives block level striping with double distributed parity? $\textsf{RAID 10}$ $\textsf{RAID 2}$ $\textsf{RAID 6}$ $\textsf{RAID 5}$
Which $\textsf{RAID}$ level gives block level striping with double distributed parity?$\textsf{RAID 10}$$\textsf{RAID 2}$$\textsf{RAID 6}$$\textsf{RAID 5}$
User Avatar
0 votes
1 answer
3768
Sql DBMS
User Avatar
12 votes
4 answers
3770
ISRO2011-15
What is the equivalent serial schedule for the following transactions? $\text{T}_1 - \text{T}_2 - \text{T}_3$ $\text{T}_3 - \text{T}_1 - \text{T}_2$ $\text{T}_2 - \text{T}_1 - \text{T}_3$ $\text{T}_1 - \text{T}_3 - \text{T}_2$
What is the equivalent serial schedule for the following transactions? $\text{T}_1 - \text{T}_2 - \text{T}_3$$\text{T}_3 - \text{T}_1 - \text{T}_2$$\text{T}_2 - \text{T}_...
User Avatar
2 votes
1 answer
3771
B+ tree
Consider a B+ tree with order 15, what is the max no of records that can be indexed with 3 levels ?
Consider a B+ tree with order 15, what is the max no of records that can be indexed with 3 levels ?
User Avatar
0 votes
0 answers
3773
consider a b
User Avatar
0 votes
2 answers
3774
what is the time complexity of construction of B & B+ tree??
User Avatar
–1 votes
7 answers
3777
BCNF
Every BCNF decomposition is A)Dependency preserving B)not a dependency preserving C)Need not be dependency preserving D)None of the above
Every BCNF decomposition is A)Dependency preservingB)not a dependency preservingC)Need not be dependency preservingD)None of the above
User Avatar
7 votes
3 answers
3778
ISRO2015-39
If a node has $K$ children in $B$ tree, then the node contains exactly _____ keys. $K^2$ $K-1$ $K+1$ $\sqrt{K}$
If a node has $K$ children in $B$ tree, then the node contains exactly _____ keys.$K^2$$K-1$$K+1$$\sqrt{K}$
User Avatar
0 votes
2 answers
3779
super key / candidate key
R (A, B, C ,D ,E ) F={ A->B, BC-> D, D->BC, B->E, B->A } Check whether BD is C.Key or S.key . Also find the candidate key.
R (A, B, C ,D ,E )F={ A->B, BC- D, D->BC, B->E, B->A }Check whether BD is C.Key or S.key . Also find the candidate key.
User Avatar
0 votes
0 answers
3780
isro 2011 15
User Avatar
Page: