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

49 votes
4 answers
4286
Consider the following relation:$$\overset{\text{Student}}{\begin{array}{|c|c|}\hline\\\underline{\textbf{Roll_No}}& \textbf{Student_Name}\\\hline1& \text{Raj} \\...
49 votes
4 answers
4287
A file is organized so that the ordering of the data records is the same as or close to the ordering of data entries in some index. Then that index is calledDenseSparseCl...
0 votes
1 answer
4292
Is there any SQL command which belongs to both DDL and DML?
0 votes
1 answer
4293
Implementation of an inverted list to maintain the record list for each value for a given attribute can be done by-1) Sequential File2) Direct File3) Indexed File4) Index...
–1 votes
1 answer
4294
what will be its output if S(x,y) is a relation?
2 votes
4 answers
4295
5 votes
2 answers
4297
6 votes
3 answers
4298
0 votes
2 answers
4299
S1 is true and S3 is False as secondary index is dense...Please explain whether S2 is true or false
0 votes
1 answer
4300