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
4081
________ index is denseA) Primary indexB) clustered indexC) secondary index on candidate keyD) all
3 votes
2 answers
4082
Use the following tables for the below queries wherever table $1$ and table $2$ are used:Select *From Table 1Where not exists (Select $T_{2}B$ From Table 2 where $T_{2}B ...
0 votes
2 answers
4084
Given answer: DPlease explain
0 votes
2 answers
4085
ABC52110NULL21523In the above relation T the output of query:select * from T group by B;ABC10NULL2521Can anyone explain why this is the output?
0 votes
1 answer
4086
Given answer: BI don't know how to deal with NULL in such query operations. Please explain.
0 votes
1 answer
4087
Given answer: BI don't know how to deal with NULL in such query operations. Please explain.
0 votes
0 answers
4088
Given answer: BI don't know what are closed set in databases. Please give some references for explaining it.
1 votes
1 answer
4089
Given answer is 2, but I think that for each multivalue attribute we need a relation and one for the main entity, therefore 3 should be the answer. Please correct me if I...
1 votes
3 answers
4090
2 votes
2 answers
4093
1 votes
1 answer
4094
In Laymann terms, what is Multivalued Dependency?
1 votes
1 answer
4095
find multivalued dependency in this table?
2 votes
1 answer
4097
Given a data file with 100 records per pages and on index page capacity of 512 index entries, how deep should be the B++ tree to index this file.
2 votes
0 answers
4099
2 votes
2 answers
4100