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
3642
UGC NET CSE | June 2016 | Part 2 | Question: 16
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: Referential integrity Multi-valued dependency Entity integrity Functional dependency
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:Referential integrityMulti-valued dependencyEntity integrityFunctional dependency
User Avatar
1 votes
1 answer
3643
E-R model
What is the type of relationship between Weak Entity Set and Strong Entity Set (A) 1:1 (B) 1:M (C) M:1 (D) M:N Explain??
What is the type of relationship between Weak Entity Set and Strong Entity Set(A) 1:1 (B) 1:M(C) M:1 (D) M:NExplain??
User Avatar
1 votes
2 answers
3644
Self made
Are Expressive powers of Domain Relational Calculus, Tuple Relational Calculus and Relational Algebra same???
Are Expressive powers of Domain Relational Calculus, Tuple Relational Calculus and Relational Algebra same???
User Avatar
1 votes
1 answer
3645
Weak Entity set
Why For a weak entity set to be meaningful, it must be part of a one-to-many relationship set. This relationship set should have no descriptive attributes?
Why For a weak entity set to be meaningful, it must be part of a one-to-many relationship set. This relationship set should have no descriptive attributes?
User Avatar
3 votes
1 answer
3646
Made easy
Consider following set of FDs on R(A,B,C,D,E,F) A $\rightarrow$ BCD B $\rightarrow$ DE B $\rightarrow$ D D $\rightarrow$ A Compute the canonical cover.
Consider following set of FDs on R(A,B,C,D,E,F)A $\rightarrow$ BCDB $\rightarrow$ DEB $\rightarrow$ DD $\rightarrow$ ACompute the canonical cover.
User Avatar
2 votes
2 answers
3647
datebase
Consider an empty relation R (AB) where A is primary key and B is a foreign key referring the same relation R. Which of the following row sequence can be inserted into R ? (A) (1,2) (2,3) (3,4) (4, 5) (B) (1, NULL) (2,1) (4,3) (3,2) (C) (1, NULL) (2,1) (3,2) (3,2) (D) None
Consider an empty relation R (AB) where A is primary key and B is a foreign key referring the same relation R. Which of the following row sequence can be inserted into R...
User Avatar
2 votes
2 answers
3648
UGC NET CSE | December 2015 | Part 3 | Question: 63
Consider the following three tables $R, S$ and $T.$ In this question, all the join operations are natural joins $(\bowtie )$. $(\pi )$ ... (a) (b) (c) (d)
Consider the following three tables $R, S$ and $T.$ In this question, all the join operations are natural joins $(\bowtie )$. $(\pi )$ is the projection operation of a re...
User Avatar
1 votes
3 answers
3653
No of rows
What B=2 return means? How is it returning the tuple? and How many number of rows return here?
What B=2 return means? How is it returning the tuple? andHow many number of rows return here?
User Avatar
1 votes
1 answer
3654
UGC NET CSE | December 2015 | Part 2 | Question: 19
A data which improves the performance and accessibility of the database are called: Indexes User Data Application Metadata Data Dictionary
A data which improves the performance and accessibility of the database are called:IndexesUser DataApplication MetadataData Dictionary
User Avatar
1 votes
1 answer
3657
Ace Page# 13, Q# 37
User Avatar
1 votes
4 answers
3659
Ace Page# 09, Q# 04
What does the double arrow in options 2 & 4 mean ?
What does the double arrow in options 2 & 4 mean ?
User Avatar
1 votes
1 answer
3660
Ace Page# 11, Q# 16
User Avatar
Page: