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{2022} & \textbf{2021-1}&\textbf{2021-2}&\textbf{2020}&\textbf{2019}&\textbf{2018}&\textbf{2017-1}&\textbf{2017-2}&\textbf{2016-1}&\textbf{2016-2}&\textbf{Minimum}&\textbf{Average}&\textbf{Maximum}
\\\hline\textbf{1 Mark Count} & 3 &2&1&2&2&2&2&2&3&2&1&2.1&3
\\\hline\textbf{2 Marks Count} & 2&3&3&3&3&2&3&3&1&2&1&2.5&3
\\\hline\textbf{Total Marks} & 7 &8&7&8&8&6&8&8&5&6&\bf{6}&\bf{7.1}&\bf{8}\\\hline
\end{array}}}$$

Recent questions in Databases

1 votes
1 answer
4111
1 votes
1 answer
4113
1 votes
1 answer
4114
1 votes
2 answers
4115
db
1 votes
3 answers
4116
1 votes
2 answers
4117
A block can hold either $12$ records or $42$ key pointers .A database contains $96$ records , then how many blocks are required to hold the data file and the dense Index?...
27 votes
3 answers
4118
3 votes
4 answers
4120
6 votes
4 answers
4122
Consider the following instance $R$.A1234BNull122The number of tuples returned by the following SQL query is select * from $R$ as $R1$where not exists (select * from $R$...
2 votes
2 answers
4123
.WHAT IS TRIPLES????
1 votes
2 answers
4124
1 votes
1 answer
4126
1 votes
1 answer
4127
1 votes
2 answers
4128
R1(p,q,r) and R2(r,s,t) with the primary key P and R respectively.the relation R1 contain 200 tuple and R2 contain 250 tuple then minimum and maximum size find right ou...
4 votes
5 answers
4130
If the order of a B-Tree is $20$, then the number of levels needed to store $15,998$ keys are ______.