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

Most answered questions in Databases

39 votes
5 answers
83
GATE CSE 2019 | Question: 51
A relational database contains two tables Student and Performance as shown below: ... S, Performance P WHERE P.Marks >84 GROUP BY S.Student_name; The number of rows returned by the above SQL query is ________
A relational database contains two tables Student and Performance as shown below:$$\overset{\text{Table: student}}{\begin{array}{|l|l|} \hline \text{Roll_no} & \text{Stud...
User Avatar
1 votes
5 answers
84
MADE EASY TEST-SERIES
Consider R(A,B,C,D,E,F,G) be a relational schema with the following functional dependencies: AC->G, D->EG, BC->D, CG->BD, ACD->B, CE->AG The number of different minimal cover possible are___________?
Consider R(A,B,C,D,E,F,G) be a relational schema with the following functional dependencies:AC->G, D->EG, BC->D, CG->BD, ACD->B, CE->AGThe number of different minimal cov...
User Avatar
1 votes
5 answers
85
transaction cascadeless
is this is cascadeless? r1(X),w2(X),w1(X), abort2, commit1
is this is cascadeless?r1(X),w2(X),w1(X), abort2, commit1
User Avatar
0 votes
5 answers
86
UGC NET CSE | July 2018 | Part 2 | Question: 61
In RDBMS, which type of Join returns all rows that satisfy the join condition? Inner Join Outer Join Semi Join Anti Join
In RDBMS, which type of Join returns all rows that satisfy the join condition?Inner JoinOuter JoinSemi JoinAnti Join
User Avatar
0 votes
5 answers
87
UGC NET CSE | July 2018 | Part 2 | Question: 63
In a Hierarchical database, a hashing function is used to locate the ____ Collision Root Foreign Key Records
In a Hierarchical database, a hashing function is used to locate the ____CollisionRootForeign KeyRecords
User Avatar
4 votes
5 answers
91
If every Attribute of R is Prime Attribute then
R always in "3NF" but "may not BCNF" T/F and why?
R always in "3NF" but "may not BCNF"T/F and why?
User Avatar
0 votes
5 answers
93
database
If table is has only two coloumns,in which normal form would it be?
If table is has only two coloumns,in which normal form would it be?
User Avatar
31 votes
5 answers
94
GATE CSE 2017 Set 2 | Question: 49
In a B+ Tree , if the search-key value is $8$ bytes long , the block size is $512$ bytes and the pointer size is $2\;\text{B}$ , then the maximum order of the B+ Tree is ____
In a B+ Tree , if the search-key value is $8$ bytes long , the block size is $512$ bytes and the pointer size is $2\;\text{B}$ , then the maximum order of the B+ Tree is ...
User Avatar
52 votes
5 answers
95
GATE CSE 2017 Set 1 | Question: 46
Consider a database that has the relation schema CR(StudentName, CourseName). An instance of the schema CR is as given below. ... $T2 \leftarrow CR\div T1$ The number of rows in $T2$ is ______________ .
Consider a database that has the relation schema CR(StudentName, CourseName). An instance of the schema CR is as given below.$$\begin{array}{|c|c|} \hline \textbf{Student...
User Avatar
8 votes
5 answers
97
number of schedules conflict equivalent schedule
Consider the following schedule: S : w1(A) w1(B) r2(A) w2(B) r3(A) w3(B) The number of schedules conflict equivalent are __________ .
Consider the following schedule:S : w1(A) w1(B) r2(A) w2(B) r3(A) w3(B)The number of schedules conflict equivalent are __________ .
User Avatar
2 votes
5 answers
99
candidate key
Q1) R(A1,A2,A3,..................An) having A1A2 as its candidate key. Find the no of super key..? Q2) R(A1,A2,A3,..................An) having A1 and A2 as its candidate key. Find the no of super key..?
Q1) R(A1,A2,A3,..................An) having A1A2 as its candidate key. Find the no of super key..?Q2) R(A1,A2,A3,..................An) having A1 and A2 as its candid...
User Avatar
8 votes
5 answers
100
ISRO2007-52
Which operation is used to extract specified columns from a table? Project Join Extract Substitute
Which operation is used to extract specified columns from a table?ProjectJoinExtractSubstitute
User Avatar
Page: