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

0 votes
1 answer
4172
Bank(bname,city)Travel(pname,city)select T1.pname from Travel T1 where not exists(select B.city from Bank B where B.bname='SBI' except select T2.city from Travel T2 where...
1 votes
3 answers
4173
Suppose we have a schedule containing two transactions  as shown-$\begin{bmatrix} T1 & T2 \\ R(A) & \\ W(A) & \\ & R(A) \\  & W(A) \\ R(B)& \\ W(B)& \\ & R(B) \\  & W(...
0 votes
2 answers
4176
The physical location of a record determined by a formula that transforms a file key into a record location isa)Hashed fileb)B-Tree filec)Indexed filed)Sequential file
0 votes
1 answer
4177
0 votes
2 answers
4178
Find the minimum no of tables requires for representing the above relational model? 
0 votes
2 answers
4182
The maximum number of nodes in a B+ tree with order 4 and height 6 are ____________I think it should be $1+4+4^{2}+4^{3}+4^{4}+4^{5}+4^{6}$= >$\frac{4^{7}-1}{4-1}$=>5461
1 votes
1 answer
4183
0 votes
2 answers
4184
Consider unspanned blocking with 20 byte blocks. A file contains records of sizes 2,5,3,7,4,20 bytes. The percentage of space wasted if blocks are allocated for file is ...
0 votes
2 answers
4185
I think conservative 2PL prevents deadlock also. What should be the answer? 
0 votes
3 answers
4186
7 votes
1 answer
4188
Every time the attribute A appears, it is matched with the same value of attribute B but not the same value of attribute C. Which of the following is true?A - (B,C) ...
0 votes
3 answers
4189
What is the difference between the following two expressions, conceptually and  in terms of relational algebra ?1. names of girl students with more marks than some boy s...