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

1 votes
2 answers
3703
UGC NET CSE | September 2013 | Part 2 | Question: 43
Thoma’s-write rule is Two phase locking protocol Timestamp ordering protocol One phase locking protocol Sliding window protocol
Thoma’s-write rule isTwo phase locking protocolTimestamp ordering protocolOne phase locking protocolSliding window protocol
User Avatar
1 votes
2 answers
3704
UGC NET CSE | September 2013 | Part 2 | Question: 41
Cross_tab displays permit users to view ____ of multidimensional data at a time. One dimension Two dimensions Three dimensions Multidimensions
Cross_tab displays permit users to view ____ of multidimensional data at a time.One dimensionTwo dimensionsThree dimensionsMultidimensions
User Avatar
1 votes
2 answers
3705
UGC NET CSE | September 2013 | Part 2 | Question: 39
Views are useful for ____ unwanted information, and for collecting together information from more than one relation into a single view. Hiding Deleting Highlighting All of the above
Views are useful for ____ unwanted information, and for collecting together information from more than one relation into a single view.HidingDeletingHighlightingAll of th...
User Avatar
1 votes
1 answer
3706
UGC NET CSE | September 2013 | Part 2 | Question: 37
Usage of Preemption and Transaction Rollback prevents _____. Unauthorized usage of data file Deadlock situation Data manipulation File pre-emption
Usage of Preemption and Transaction Rollback prevents _____.Unauthorized usage of data fileDeadlock situationData manipulationFile pre-emption
User Avatar
4 votes
1 answer
3707
UGC NET CSE | December 2014 | Part 2 | Question: 20
Identify the minimal key for relational scheme $R(A, B, C, D, E)$ with functional dependencies $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$ $A$ $AE$ $BE$ $CE$
Identify the minimal key for relational scheme $R(A, B, C, D, E)$ with functional dependencies $F = \left\{A \rightarrow B, B \rightarrow C, AC \rightarrow D\right\}$ $A$...
User Avatar
4 votes
3 answers
3709
UGC NET CSE | December 2014 | Part 2 | Question: 18
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram Generalization Aggregation Specialization Adding suitable attributes
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagramGeneralization Aggregation Specia...
User Avatar
0 votes
2 answers
3717
UGC NET CSE | December 2012 | Part 3 | Question: 70
Referential integrity is directly related to Relation key Foreign key Primary key Candidate key
Referential integrity is directly related toRelation keyForeign keyPrimary keyCandidate key
User Avatar
3 votes
2 answers
3718
UGC NET CSE | December 2012 | Part 3 | Question: 63
The third normal form is based on the concept of_____ Closure Dependency Transitive Dependency Normal Dependency Functional Dependency
The third normal form is based on the concept of_____Closure DependencyTransitive DependencyNormal DependencyFunctional Dependency
User Avatar
Page: