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|c|c|c|c|c|c|}\hline \textbf{Year}& \textbf{2026 - 1}& \textbf{2026 - 2}& \textbf{2025 - 1}& \textbf{2025 - 2}& \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}&2&2&1&1&4&4&1&3&2&1&1&2.1&4\\\hline \textbf{2 Marks Count}&2&2&3&4&2&2&2&2&3&3&2&2.5&4\\\hline \textbf{Total Marks}&6&6&8&9&8&8&5&7&8&7&\bf{5}&\bf{7.2}&\bf{9}\\\hline \end{array}}}$$

Filter

Recent questions in Databases

0 0 votes
1 1 answer
459
459 views
UGC NET CSE | June 2008 | Part 2 | Question: 17
Which of the following set of keywords constitutes a mapping in $\text{SQL}$?$\text{SELECT, FROM, TABLE}$$\text{SELECT, FROM, WHERE}$$\text{CONNECT, TABLE, CREATE}$$\text...
User Avatar
1 1 vote
2 2 answers
440
440 views
UGC NET CSE | June 2008 | Part 2 | Question: 18
If a relation is in $2 \mathrm{NF}$ then :every candidate key is a primary keyevery non-prime attribute is fully functionally dependent on each relation keyevery attribut...
User Avatar
1 1 vote
3 3 answers
465
465 views
UGC NET CSE | June 2008 | Part 2 | Question: 19
Which of the following is true?A relation in $3 \mathrm{NF}$ is always in $\text{BCNF}$A relation in $\text{BCNF}$ is always in $\text{3NF}$$\mathrm{BCNF}$ and $3 \mathrm...
User Avatar
0 0 votes
1 1 answer
565
565 views
UGC NET CSE | June 2008 | Part 2 | Question: 20
Consider the query: SELECT student_name FROM student_data WHERE rollno (SELECT rollno FROM student_marks WHERE SEM1_MARK=SEM2_MARK); Which of the following is true?It giv...
User Avatar
0 0 votes
1 1 answer
693
693 views
made-easy
Consider the following relational schemas, and an SQL query Q below:Sailors (Sid, Sname, rating, age)Boats (Bid, Bname, color)Reserves (Sid, Bid, day)SELECT S.sname FROM ...
User Avatar
2 2 votes
2 answers 2 answers
1.2k
1.2k views
Gate cse Ace test series
User Avatar
0 0 votes
0 0 answers
398
398 views
testbook
Can you help me understand the last 2 options
User Avatar
1 1 vote
1 1 answer
1.0k
1.0k views
Let a relation in DBMS is given as R(A, B, C, D, E) and candidate keys are {A} and {BC}. Total number of possible super keys are:
User Avatar
1 1 vote
1 1 answer
1.4k
1.4k views
Number of Conflict Serializable Schedules
How many total $Conflict$ $Serializable$ $Schedules$ are possible that can be formed by $T1$ and $T2?$$T1:$ $r_1(A)$ $r_1(B)$ $w_1(B)$$T2:$ $r_2(B)$ $r_2(A)$ $w_2(B)$
User Avatar
1 1 vote
0 0 answers
276
276 views
#self doubt
The following key values are inserted into a B+ tree, where order of the internal node is 5 and order of leaf node is 4. The order of the internal node is the maximum num...
User Avatar
1 1 vote
1 1 answer
369
369 views
#Applied Course
Consider the below-given statements about the transactions whereL-Si(X) indicates that transaction Ti acquires a shared lock on X.L-Xi(X) indicates that transaction Ti ac...
User Avatar
1 1 vote
1 answers 1 answer
1.2k
1.2k views
MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right?For example, in the...
User Avatar
0 0 votes
1 1 answer
455
455 views
self doubt
@Deepak Poonia sir how many of the following points are correct?The schedule has (RW, WW (lost update), WR, and uncommitted read problems)and schedule is not recoverable ...
User Avatar
4 4 votes
1 answers 1 answer
1.1k
1.1k views
Can someone please explain how to solve this type of questions?
Consider the following E-R diagram.The min no. of foreign keys in the relational model of above ER diagram is $\qquad$ .
User Avatar
4 4 votes
1 1 answer
1.1k
1.1k views
Made Easy
Amy and Bob are working on a project vehicle rental system, they have a file consisting of 10000 records, having block size 1024 bytes, record size 100 bytes. Search key ...
User Avatar
0 0 votes
0 0 answers
590
590 views
Made easy DBMS
User Avatar
0 0 votes
0 0 answers
445
445 views
Made easy DBMS
User Avatar
0 0 votes
0 0 answers
301
301 views
#foreign key#normalization
If in a relationship an entity totally participates, and if it contains a foreign key then the foreign key can not be null in relation table format?
User Avatar
0 0 votes
0 0 answers
482
482 views
madeeasy ots
User Avatar
0 0 votes
0 0 answers
440
440 views
madeeasy workbook
According to me answer is 2.Is it right? Suggestion is needed how to approach this if it is given in more complexity.Q. 32 Consider the following schedule\[\begin{array}{...
User Avatar
Page: