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{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}}}$$

Filter

Recent questions in Databases

6 votes
6 answers
2851
Databases
A Clustered index A) is a dense index always. B) is a sparse index always. C) can be either dense index or a sparse index,but not both. D) can be both dense index and sparse index.
A Clustered indexA) is a dense index always.B) is a sparse index always.C) can be either dense index or a sparse index,but not both.D) can be both dense index and sparse ...
User Avatar
2 votes
3 answers
2852
databases
Which of the following statements is TRUE ? A) Every primary index is also a clustered index. B) Every clustered index is also a primary index. C) Both primary index and clustered index are one and the same, D) An index can be either primary or clustered but not both.
Which of the following statements is TRUE ?A) Every primary index is also a clustered index.B) Every clustered index is also a primary index.C) Both primary index and clu...
User Avatar
0 votes
0 answers
2853
databases
This index is a dense index ...right ...???
This index is a dense index ...right ...???
User Avatar
2 votes
0 answers
2854
databases
State TRUE or FALSE. "In Indexing,the number of ordering field (field based on which records in data file and its corresponding index file are sorted) should always be 1". Please support your answer with explanations ...
State TRUE or FALSE."In Indexing,the number of ordering field (field based on which records in data file and its corresponding index file are sorted) should always be 1"....
User Avatar
9 votes
2 answers
2855
# DBMS #Normalization
IF a relation R(A,B,C,D,E) where AB is the key and ADE->C so is this in 2NF or not? Do Partial dependency exist??? because C is derived from ADE (A is part of key AB)
IF a relation R(A,B,C,D,E) whereAB is the key andADE->Cso is this in 2NF or not?Do Partial dependency exist??? because C is derived from ADE (A is part of key AB)
User Avatar
0 votes
0 answers
2856
decomposition is lossy or lossless
R Decomposed into R1(BCD) and R2(CA)
R Decomposed into R1(BCD) and R2(CA)
User Avatar
2 votes
2 answers
2857
databases
what is the difference between a "Block" and "Sector" in Hard disk ..??? Are they both same ???
what is the difference between a "Block" and "Sector" in Hard disk ..??? Are they both same ???
User Avatar
0 votes
1 answer
2860
Korth 5 th Edition
Please explain B and B+ tree Concept
Please explain B and B+ tree Concept
User Avatar
0 votes
1 answer
2862
Normalization
Is the following relation in 3NF or not ?
Is the following relation in 3NF or not ?
User Avatar
0 votes
0 answers
2865
what is the difference between Vertical and Horizontal fragmentations.If Data objects replicas are stored
what is the difference between Vertical and Horizontal fragmentations.If Data objects replicas are stored at multiple number of sites, Explain how the lock will be acquir...
User Avatar
2 votes
3 answers
2866
b+ tree
Construct B+ tree , order=4 ->1,4,7,10,17,21,31,25,19,20,28,42 find key value at root node a.7,17 b.17 c.31,42 d.42 please help me ,unable to do insertion in b+ tree
Construct B+ tree, order=4->1,4,7,10,17,21,31,25,19,20,28,42find key value at root nodea.7,17b.17c.31,42d.42 please help me ,unable to do insertion in b+ tree
User Avatar
4 votes
2 answers
2867
cil-2017 Q87
User Avatar
18 votes
3 answers
2870
Self doubt
The number of tables required in SELF-REFERENTIAL relation when different mappings(1: M, M:1, 1:1, M: N) are used with different participation (Partial Participation at both sides, Total Participation at both sides and partial participation at one side). (Tabular Format answer will be appreciated).
The number of tables required in SELF-REFERENTIAL relation when different mappings(1: M, M:1, 1:1, M: N) are used with different participation (Partial Participation at b...
User Avatar
Page: