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
4111
SQL
Q1: (Select eno from emp where deptno=10) union(Select eno from emp where deptno=20) Q2:(Select eno from emp where deptno=10 or deptno=20) Which one is true? 1)Q1⊆Q2 2)Q2⊆Q1 3)Q1=Q2 4)data inefficient
Q1: (Select eno from emp where deptno=10) union(Select eno from emp where deptno=20)Q2:(Select eno from emp where deptno=10 or deptno=20)Which one is true?1)Q1⊆Q22)Q2�...
User Avatar
2 votes
2 answers
4113
referential integrity
select true statements: foreign key may be null. primary key may be null. none
select true statements:foreign key may be null.primary key may be null.none
User Avatar
0 votes
1 answer
4115
Procedure to Delete Nodes from B+ Tree ?
User Avatar
0 votes
2 answers
4117
b tree
what are b trees..explain in simplest way
what are b trees..explain in simplest way
User Avatar
0 votes
2 answers
4119
er diagram
The E-R model is expressed in term of I. Entities II. The relationship among entities. III. The attributes of the entities. IV. Functional relationship. (A) I, II (B) I, II, IV (C) II, II, IV (D) I, II, III
The E-R model is expressed in term of I. Entities II. The relationship among entities. III. The attributes of the entities. IV. Functional relationship. (A) I, II (B) I, ...
User Avatar
1 votes
1 answer
4120
Unrepeatable read problem
User Avatar
0 votes
2 answers
4121
Normalization
benefit of normalization? performance is improved insertion anomalies are avoided. none
benefit of normalization?performance is improvedinsertion anomalies are avoided.none
User Avatar
0 votes
1 answer
4124
.The data dictionary tells the DBMS
A. what files are in the database B. what attribute are possessed by the data C. what these files contain D. All of the above
A. what files are in the databaseB. what attribute are possessed by the dataC. what these files containD. All of the above
User Avatar
0 votes
2 answers
4125
Database Views
Views are useful for _____ unwanted information, and for collecting together information from more than one relation into a single view. A. Hiding B. Deleting C. Highlighting D. All of the above
Views are useful for _____ unwanted information, and for collecting together information from more than one relation into a single view.A. HidingB. DeletingC. Hi...
User Avatar
0 votes
3 answers
4126
Super key
R (A, B, C) Functional dependency= { A -> B, B -> C , C -> A } No of super keys are...??
R (A, B, C)Functional dependency= { A - B, B - C , C - A }No of super keys are...??
User Avatar
0 votes
1 answer
4127
that defines valid values
……………….. contains information that defines valid values that are stored in a column or data type. A) View B) Rule C) Index D) Default
……………….. contains information that defines valid values that are stored in a column or data type.A) ViewB) RuleC) IndexD) Defaul...
User Avatar
1 votes
2 answers
4129
Database
Consider the given below 2 statements s1 : Every ternary relationship can be expresses as combination of 2 or more binary relationship . s2: Evert ternary relationship can be expressed with the help of aggreation concept . 1) both are true 2) both are false 3) s1 is true s2 is false 4) s1 is false s2 is true
Consider the given below 2 statementss1 : Every ternary relationship can be expresses as combination of 2 or more binary relationship .s2: Evert ternary relationship can...
User Avatar
0 votes
0 answers
4130
navathe,FD #inference rules for functional dependency
User Avatar
Page: