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

Questions without answers in Databases

0 votes
0 answers
31
ER Diagram
Can someone please provide me with the correct explanation for this question
Can someone please provide me with the correct explanation for this question
User Avatar
0 votes
0 answers
36
Databases
Show that the two phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.
Show that the two phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.
User Avatar
0 votes
0 answers
37
Applied root course
User Avatar
0 votes
0 answers
38
Database ER model
Consider the following relation (capitalized letters are attributes and lower letters are values). X: From the given FDs find the dependencies that seems to apply on X and identify a possible key (Candidate key) for X. A→C,D→E,C→A,E→B E→A,C→B,B→D,B→A
Consider the following relation (capitalized letters are attributes and lower letters are values).X:From the given FDs find the dependencies that seems to apply on X and ...
User Avatar
0 votes
0 answers
40
Ace workbook dbms
User Avatar
0 votes
0 answers
42
Databases
Please explain option c.
Please explain option c.
User Avatar
1 votes
0 answers
43
SQL | Not Exist
User Avatar
0 votes
0 answers
44
SQL
consider following relation How many number of records resulted by following SQL query? Select $T_{1}.A$ From R Where Exists (Select Count (*) From S Where R .C<S.F and S. E > 10 ); A 3 B 2 C 1 D 0
consider following relation How many number of records resulted by following SQL query?Select $T_{1}.A$From RWhere Exists (Select Count (*) From S Where R .C<S.F and S....
User Avatar
0 votes
0 answers
45
Entity-relationship and Relational Model:el:Convert the following entity-relationship diagram into tables of relational model
Entity-relationship and Relational Model:el:Convert the following entity-relationship diagram into tables of relational model
User Avatar
0 votes
0 answers
46
Unacademy AIMT -1
the answer is 28
the answer is 28
User Avatar
1 votes
0 answers
47
DRDO CSE 2022 Paper 2 | Question: 15 (a)
Answer the following. __________ is the operation that reverses the normalization to denormalization form.
Answer the following.__________ is the operation that reverses the normalization to denormalization form.
User Avatar
1 votes
0 answers
48
DRDO CSE 2022 Paper 2 | Question: 15 (c)
Answer the following. Which of the following are not keys in the database? Compliment * Agreement Construct Supplement
Answer the following.Which of the following are not keys in the database?Compliment *AgreementConstructSupplement
User Avatar
2 votes
0 answers
49
Since it is already in 3NF, why decompose further?
Since the schema is already in 3NF we can keep the relations to 1, cant we? If you think the answer is different please explain how
Since the schema is already in 3NF we can keep the relations to 1, cant we? If you think the answer is different please explain how
User Avatar
1 votes
0 answers
50
self doubt
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attribute True or false
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
User Avatar
0 votes
0 answers
51
Databases
How to identify many to many relationship. Can R2 be one to one.
How to identify many to many relationship.Can R2 be one to one.
User Avatar
0 votes
0 answers
53
selfdoubt
can a relationship have a degree of one if both the entities are same and participating in one form? ex: employee helps employee
can a relationship have a degree of one if both the entities are same and participating in one form?ex: employee helps employee
User Avatar
6 votes
0 answers
54
5. Consider a multi-dimensional array A [90][30]40] with base address start at 1000, calculate the address of A[10][20][3] in row major order and column major order. Assume the first element is stored at A [2][2][2] and each element take 2 byte.
Consider a multi-dimensional array A [90][30]40] with base address start at 1000, calculate the address of A[10][20][3] in row major order and column major order. Assume ...
User Avatar
0 votes
0 answers
55
DBMS -- Book Confusion
which is best book for DBMS korth or navathe ? since i know that both book is great but i wanted to follow 1 particular book that is easy to understand and simple language for all topics. please suggest .
which is best book for DBMS korth or navathe ?since i know that both book is great but i wanted to follow 1 particular book that is easy to understand and simple language...
User Avatar
0 votes
0 answers
56
Serializability
What is Proof/Explanation for complexity to test if a schedule is conflict serializable is O(n^2) whereas for view serializable is O(2^n)-Exponential ?
What is Proof/Explanation for complexity to test if a schedule is conflict serializable is O(n^2) whereas for view serializable is O(2^n)-Exponential ?
User Avatar
0 votes
0 answers
57
Fanout ratio in indexing
What is fanout ratio
What is fanout ratio
User Avatar
1 votes
0 answers
58
dbms igate test series
what is multiversion time stamp protocol?
what is multiversion time stamp protocol?
User Avatar
0 votes
0 answers
59
Database: Minimum number of tuples
Consider a relation schema r(A, B, C). Number of elements in domain of attributes A, B and C are 4, 10 and 17 respectively. “ Minimum ” number of tuples possible in an instance of relation r is ________.
Consider a relation schema r(A, B, C). Number of elements in domain of attributes A, B and C are 4, 10 and 17 respectively. “ Minimum ” number of tuples possible in a...
User Avatar
To see more, click for the full list of questions or popular tags.