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

0 votes
1 answer
2941
# gate cse 1998 1mark question
plz explain why the answer is occupation ????
plz explain why the answer is occupation ????
User Avatar
1 votes
1 answer
2943
# gate cse 1998 2 marks
Plz explain the answer of ques no. 4 a) 2NF b) 3NF
Plz explain the answer of ques no. 4a) 2NFb) 3NF
User Avatar
1 votes
1 answer
2945
Dependency Preserving or Not ?
R(ABCD) F={ A→B, B→C, C→D, D→A } Now Decompose this into D={ AB, BC, CD } Dependency is preserved or Not ? Source : http://www.gatecrack.in/following-decomposition-dependency-preserving-not/
R(ABCD)F={ A→B, B→C, C→D, D→A }Now Decompose this into D={ AB, BC, CD }Dependency is preserved or Not ?Source : http://www.gatecrack.in/following-decomposition-d...
User Avatar
0 votes
1 answer
2947
left outer join
Find the equivalent Tuple Relational Calculus query for the following: R ⟕ S , where R(A, B) and S(A, C) are the relations and ⟕ is the left outer join symbol in Relational Algebra.
Find the equivalent Tuple Relational Calculus query for the following:R ⟕ S , where R(A, B) and S(A, C) are the relations and ⟕ is the left outer join symbol in Relat...
User Avatar
1 votes
1 answer
2948
Mock Test
Is statement 1 true for all safe expressions ?
Is statement 1 true for all safe expressions ?
User Avatar
0 votes
0 answers
2949
MadeEasy Subject Test: Databases - Joins
Maximum no. of possible records in the result of the following expression is?
Maximum no. of possible records in the result of the following expression is?
User Avatar
0 votes
1 answer
2950
Database Lossless Join
User Avatar
0 votes
0 answers
2951
ER Model
User Avatar
0 votes
2 answers
2956
Which statement is wrong about SQL?
Which statement is wrong about SQL? 1. Some SQL versions will not allow HAVING clause without GROUP BY 2. Some SQL versions will allow HAVING clause without GROUP BY 3. Some SQL versions allow only ONE null for UNIQUE key 4. Some SQL versions allow multiple NULLs for UNIQUE Key
Which statement is wrong about SQL?1. Some SQL versions will not allow HAVING clause without GROUP BY2. Some SQL versions will allow HAVING clause without GROUP BY3. Som...
User Avatar
0 votes
1 answer
2957
made-easy mock test2
User Avatar
1 votes
1 answer
2958
MadeEasy Subject Test: Databases - Transactions
Consider the following schedule S : r1(A) w2(A) r3(A) w4(A) r5(A) w6(A) The number of schedules equal to given schedule(s) which not conflict equal to schedule(s) are _______.
Consider the following scheduleS : r1(A) w2(A) r3(A) w4(A) r5(A) w6(A)The number of schedules equal to given schedule(s) which not conflict equal toschedule(s) are ______...
User Avatar
1 votes
0 answers
2959
er model
according to me answer should be 3 as all are true plz verify
according to me answer should be 3 as all are true plz verify
User Avatar
1 votes
1 answer
2960
Gateforum Test
1-In self referential relation we alwasy need 1 table. 2-If there is a total participation of one entity with the relation,we can can merge E1,the relation and E2 into a single table. Which of the above given statements are true?
1-In self referential relation we alwasy need 1 table.2-If there is a total participation of one entity with the relation,we can can merge E1,the relation and E2 into a ...
User Avatar
Page: