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

2 votes
0 answers
2461
normalization and decomposition
User Avatar
4 votes
1 answer
2462
Normalization
Given the following set of FD's find the minimum set of 3 NF relations. A->B A->C B->C B->D D->B ABE->F E->J EJ->H H->G
Given the following set of FD's find the minimum set of 3 NF relations.A->B A->CB->CB->DD->BABE->FE->JEJ->HH->G
User Avatar
1 votes
1 answer
2463
#Indexing #DBMS
User Avatar
2 votes
1 answer
2464
#DBMS #Indexing
User Avatar
1 votes
1 answer
2465
#DBMS #FileOragnization
User Avatar
2 votes
0 answers
2467
Ullman, The Complete Book
Consider a file of 1,000,000 records, with a field F that has m different values. a) As a function of m, how many bytes does the bitmap index for F have?
Consider a file of 1,000,000 records, with a field F that has m different values.a) As a function of m, how many bytes does the bitmap index for F have?
User Avatar
1 votes
1 answer
2468
#SQL #TestBook
Plzz explain
Plzz explain
User Avatar
3 votes
1 answer
2469
#DBMS #Normalization
User Avatar
–2 votes
0 answers
2470
gate 2017
User Avatar
3 votes
1 answer
2471
abelian
Every matrix is abelian under multiplication operation where all elements are real numbers true or false
Every matrix is abelian under multiplication operation where all elements are real numberstrue or false
User Avatar
2 votes
1 answer
2472
B + tree
Following parameters to construct B+ tree search key - 15B block size - 512B record pointer - 9B block pointer - 8B Max num of keys that can be accomodated in each non leaf node of the tree is
Following parameters to construct B+ treesearch key - 15Bblock size - 512Brecord pointer - 9Bblock pointer - 8BMax num of keys that can be accomodated in each non leaf no...
User Avatar
0 votes
0 answers
2473
Doubt-05
For secondary key processing which of the following file organizations is preferred? Give a one line justification: Indexed sequential file organization. Two-way linked list. Inverted file organization. Sequential file organization.
For secondary key processing which of the following file organizations is preferred? Give a one line justification:Indexed sequential file organization.Two-way linked lis...
User Avatar
1 votes
1 answer
2474
Polygraph
Can anyone please share the resource to study polygraph for checking view serializability?
Can anyone please share the resource to study polygraph for checking view serializability?
User Avatar
1 votes
1 answer
2476
test series
User Avatar
2 votes
2 answers
2480
Practice
All Conflict serializable schedule are also view serializable but reverse is not true . True or False
All Conflict serializable schedule are also view serializable but reverse is not true . True or False
User Avatar
Page: