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{2024-1}& \textbf{2024-2} &\textbf{2023} &\textbf{2022} & \textbf{2021-1}&\textbf{2021-2}&\textbf{Minimum}&\textbf{Average}&\textbf{Maximum}
\\\hline\textbf{1 Mark Count} &4&4&1& 3 &2&1&1&2.5&4
\\\hline\textbf{2 Marks Count} &2&2&2& 2&3&3&2&2.33&3
\\\hline\textbf{Total Marks} & 8&8&5& 7 &8&7&\bf{5}&\bf{7.16}&\bf{8}\\\hline
\end{array}}}$$

Filter

Recent questions in Databases

4 votes
1 answer
3683
UGC NET CSE | December 2013 | Part 3 | Question: 55
Consider the following ER diagram: The minimum number of tables required to represent $M, N, P, R_1, R_2$ is 2 3 4 5
Consider the following ER diagram:The minimum number of tables required to represent $M, N, P, R_1, R_2$ is2345
User Avatar
1 votes
1 answer
3685
How to check the given schedule is serlizable or not ???
User Avatar
1 votes
1 answer
3686
Database
Consider 3 relation R(A, B, C) WITH 20 TUPLES and S(A,D , E) With 30 tuples and T(D,F,G ) with 40 tuples. What is the max no. of tuples in natural joint of R S T Plz explain
Consider 3 relation R(A, B, C) WITH 20 TUPLES and S(A,D , E) With 30 tuples and T(D,F,G ) with 40 tuples.What is the max no. of tuples in natural joint of R S TPlz exp...
User Avatar
2 votes
1 answer
3689
UGC NET CSE | December 2013 | Part 2 | Question: 15
Data Integrity control uses Upper and lower limits on numeric data Passwords to prohibit unauthorized access to files Data dictionary to keep the data Data dictionary to find last access data
Data Integrity control usesUpper and lower limits on numeric dataPasswords to prohibit unauthorized access to filesData dictionary to keep the dataData dictionary to find...
User Avatar
1 votes
1 answer
3690
UGC NET CSE | December 2013 | Part 2 | Question: 14
Based on the cardinality ratio and participation ______ associated with a relationship type, choose either the Foreign Key Design, the Cross Referencing Design or Mutual Referencing Design. Entity Constraints Rules Keys
Based on the cardinality ratio and participation ______ associated with a relationship type, choose either the Foreign Key Design, the Cross Referencing Design or Mutual ...
User Avatar
3 votes
2 answers
3692
UGC NET CSE | December 2013 | Part 2 | Question: 12
GO BOTTOM and SKIP-3 commands are given one after another in a database file of 30 records. It shifts the control to 28-th record 27-th record 3-rd record 4-th record
GO BOTTOM and SKIP-3 commands are given one after another in a database file of 30 records. It shifts the control to28-th record27-th record3-rd record4-th record
User Avatar
2 votes
1 answer
3696
UGC NET CSE | September 2013 | Part 3 | Question: 48
Match the following $:$ ... $\text{(a)-(iii), (b)-(iv), (c)-(ii), (d)-(i)}$
Match the following $:$$\begin{array}{} \text{(a)} & \text{Create} & \text{(i)} & \text{The ER model} \\ \text{(b)} & \text{Select} & \text{(ii)} & \text{Relationship m...
User Avatar
3 votes
1 answer
3698
gate
Consider a relation R(ABCDE),with thd following functional dependencies: AB->C BC->D CD->E DE->A AE->B No. Of super keys(including keys ) of the relation R is
Consider a relation R(ABCDE),with thd following functional dependencies:AB->CBC->DCD->EDE->AAE->BNo. Of super keys(including keys ) of the relation R is
User Avatar
1 votes
2 answers
3699
dbms
User Avatar
1 votes
1 answer
3700
GateCseGroup
Here i was able to figure out all the attributes are prime attribute, so it will be in 3NF, How should i divide it for BCNF?
Here i was able to figure out all the attributes are prime attribute, so it will be in 3NF, How should i divide it for BCNF?
User Avatar
Page: