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

2 votes
3 answers
3722
UGC NET CSE | June 2012 | Part 3 | Question: 9
The problem that occurs when one transaction updates a database item and the transaction fails for some reason is Temporary Select Problem Temporary Modify Problem Dirty Read Problem None
The problem that occurs when one transaction updates a database item and the transaction fails for some reason isTemporary Select ProblemTemporary Modify ProblemDirty Rea...
User Avatar
2 votes
2 answers
3724
UGC NET CSE | June 2012 | Part 3 | Question: 4
What is Granularity? The size of database The size of data item The size of record The size of file
What is Granularity?The size of databaseThe size of data itemThe size of recordThe size of file
User Avatar
4 votes
2 answers
3726
ISRO2016-56
Goals for the design of the logical scheme include avoiding data inconsistency being able to construct query easily being able to access data efficiently All of the above
Goals for the design of the logical scheme includeavoiding data inconsistencybeing able to construct query easilybeing able to access data efficientlyAll of the above
User Avatar
2 votes
2 answers
3727
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
2 answers
3728
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
3729
Multi Valued Dependencies
Multi Valued Dependencies(MVD) satisfied by relation R(A,B,C) with tuples: (a1,b1,c1),(a1,b1.c2), (a2,b1,c1), (a2,b1,c3) A⇢⇢B B⇢⇢A, BC⇢⇢A, B⇢⇢AC
Multi Valued Dependencies(MVD) satisfied by relation R(A,B,C) with tuples: (a1,b1,c1),(a1,b1.c2), (a2,b1,c1), (a2,b1,c3)A⇢⇢BB⇢⇢A, BC⇢&#86...
User Avatar
0 votes
0 answers
3730
navathe,FD #inference rules for functional dependency
User Avatar
0 votes
1 answer
3731
UGC NET CSE | June 2012 | Part 2 | Question: 12
A Transaction Manager is which of the following? Maintains a log of transactions Maintains before and after database images Maintains appropriate concurrent control All of the above
A Transaction Manager is which of the following?Maintains a log of transactionsMaintains before and after database imagesMaintains appropriate concurrent controlAll of th...
User Avatar
1 votes
1 answer
3732
UGC NET CSE | June 2012 | Part 2 | Question: 7
In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by Jamming Password Documentation Record lock
In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so byJammingPasswordDocumentationRecord lock
User Avatar
0 votes
2 answers
3733
UGC NET CSE | June 2014 | Part 2 | Question: 50
Match the following $:$ ... $\text{a-ii; b-iii; c-i; d-iv}$ $\text{a-iv; b-i; c-ii; d-iii}$
Match the following $:$$\begin{array} {cIcI} & \textbf{List – I} && \textbf{List – II} \\ \text{a.} & \text{DDL} & \text{i.} & \text{LOCK TABLE} \\ \text{b.} & \tex...
User Avatar
2 votes
3 answers
3734
UGC NET CSE | June 2014 | Part 2 | Question: 49
Let $R =\{A, B, C, D, E, F\}$ be a relation schema with the following dependencies $C \rightarrow F$, $E \rightarrow A$, $EC \rightarrow D$, $A \rightarrow B$. Which of the following is a key for $R$ ? CD EC AE AC
Let $R =\{A, B, C, D, E, F\}$ be a relation schema with the following dependencies $C \rightarrow F$, $E \rightarrow A$, $EC \rightarrow D$, $A \rightarrow B$. Which of t...
User Avatar
3 votes
3 answers
3735
UGC NET CSE | June 2014 | Part 2 | Question: 48
A clustering index is created when _______. Primary key is declared and ordered No key ordered Foreign key ordered There is no key and no order
A clustering index is created when _______. Primary key is declared and ordered No key orderedForeign key orderedThere is no key and no order
User Avatar
0 votes
2 answers
3736
UGC NET CSE | June 2014 | Part 2 | Question: 46
Manager’s salary details are hidden from the employee. This is called as Conceptual level data hiding Physical level data hiding External level data hiding Local level data hiding
Manager’s salary details are hidden from the employee. This is called asConceptual level data hidingPhysical level data hidingExternal level data hiding Local level...
User Avatar
10 votes
4 answers
3737
ISRO2014-63
Consider the following table The table is in which normal form? First Normal Form Second Normal Form Third Normal Form but not BCNF Third Normal Form and BCNF
Consider the following tableThe table is in which normal form?First Normal FormSecond Normal FormThird Normal Form but not BCNFThird Normal Form and BCNF
User Avatar
1 votes
1 answer
3738
Sql DBMS
User Avatar
0 votes
2 answers
3739
IDENTIFYING RELATIONSHIP IN STRONG :WEAK ENTITY
Cardinality ratio ' string entity set : weak entity set' in their binary identifying relatoinship is one-to-one one-to-many many-to-one many-to-many
Cardinality ratio ' string entity set : weak entity set' in their binary identifying relatoinship isone-to-oneone-to-manymany-to-onemany-to-many
User Avatar
1 votes
2 answers
3740
dbms normalization
How many types of insertion anomalies: (a) 1 (b) 2 (c) 3 (d) 4
How many types of insertion anomalies:(a) 1 (b) 2 (c) 3 (d) 4
User Avatar
Page: