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

Hot questions in Databases

1 votes
1 answer
4081
database explain
User Avatar
0 votes
1 answer
4082
#normalization
Q)Suppose we are given the set ofFD's A->B,B->C,C->D,D->E .E->A.Of the 10 subsets of three attribute out of 5 attributes ABCDE how many of them are in BCNF wrt above FD? I am getting 10.Am I correct?
Q)Suppose we are given the set ofFD's A->B,B->C,C->D,D->E .E->A.Of the 10 subsets of three attribute out of 5 attributes ABCDE how many of them are in BCNF wrt above FD?I...
User Avatar
3 votes
0 answers
4084
Concurrency Control
In Rigorous Two Pase Locking, If tansaction T1 holds a shared lock on X and T2 also requests for lock on X in shared mode.Will T2 will be granted?
In Rigorous Two Pase Locking, If tansaction T1 holds a shared lock on X and T2 also requests for lock on X in shared mode.Will T2 will be granted?
User Avatar
2 votes
1 answer
4086
check the question
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.
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.
User Avatar
1 votes
1 answer
4087
normalization
Is there any reason to design a database schema that is in 2NF,but is in no higher-order normal form?
Is there any reason to design a database schema that is in 2NF,but is in no higher-order normal form?
User Avatar
1 votes
1 answer
4088
How to check the given schedule is serlizable or not ???
User Avatar
1 votes
0 answers
4089
http://gateoverflow.in/39703/gate-2016-1-51
If lock is shared what will happen?deadlock or not?
If lock is shared what will happen?deadlock or not?
User Avatar
2 votes
2 answers
4090
Tuple Relational Calculus
I believe since the variable 't' is a free variable, so option three should also be right. Second option is also correct?
I believe since the variable 't' is a free variable, so option three should also be right. Second option is also correct?
User Avatar
0 votes
1 answer
4091
A context model of a software system can be shown by drawing
User Avatar
2 votes
2 answers
4092
Sql group by clause?
How does group by works. ya it make groups of the data . and what i know it will group the data. what what i found on running on the online tutorials is that , the group by only shows me one entry for every distinct entry, can someone plz explain the way this group by works??
How does group by works. ya it make groups of the data . and what i know it will group the data. what what i found on running on the online tutorials is that , the group ...
User Avatar
0 votes
0 answers
4093
natural join and equi join
is natural join is same as equijoin or innerjoin or natural join is defined as the caresian product followed by selection/projection
is natural join is same as equijoin or innerjoin or natural join is defined as the caresian product followed by selection/projection
User Avatar
0 votes
0 answers
4094
Normalisation
User Avatar
2 votes
2 answers
4095
madeeasy
A B C 3 5 NULL 6 NULL 10 NULL 10 5 12 NULL NULL SELECT * FROM R WHERE (A>=5) AND (B>C OR C>=5); NO OF TUPLES RESULTED BY QUERY?
A B C3 5 NULL6 NULL 10NULL 10 512 NULL NULLSELECT * FROM R WHERE (A>=5) AND (B>C OR C>=5);NO OF TUPLES RESULTED BY QUERY?
User Avatar
0 votes
2 answers
4097
ACID PROPERTIES
ATOMICITY IS MANAGED BY a) Programmer b) Recovery Management Component c) Concurrency Control Component d) None of it
ATOMICITY IS MANAGED BY a) Programmerb) Recovery Management Component c) Concurrency Control Componentd) None of it
User Avatar
1 votes
2 answers
4098
dbms
User Avatar
2 votes
1 answer
4099
B+ tree
Consider a B+ tree with order 15, what is the max no of records that can be indexed with 3 levels ?
Consider a B+ tree with order 15, what is the max no of records that can be indexed with 3 levels ?
User Avatar
Page: