Recent questions tagged databases

5 votes
3 answers
2131
1 votes
1 answer
2132
5 votes
1 answer
2133
$1)$ Consider schedule below. Determine whether schedule is cascadeless or not ?r1(x); r2(z); r1(z); r3(x); r3(y); w1(x); c1; w3(y); c3; r2(y); w2(z); w2(y);c2
5 votes
3 answers
2140
Select SNAME from S Where SNOin (select SNO from SP where PNOin (select PNO from P Where COLOUR='BLUE'))What relations are being used in the above SQL query? Given at lea...
10 votes
3 answers
2141
Describe the relational algebraic expression giving the relation returned by the following SQL query.Select SNAME from S Where SNOin (select SNO from SP where PNOin (sele...
9 votes
1 answer
2145
What are the three axioms of functional dependency for the relational databases given by Armstrong.
0 votes
1 answer
2147
a) every column that appears in group by clause must appear in select statement.b) every column that appears in select statement must appear in group by clauseout of thes...
2 votes
2 answers
2148
Student (Sid,gender,marks,branch)Query: Retrieve Sid's who scored the highest mark?SELECT SID FROM Student EXCEPT SELECT T1.Sid FROM Student T1,Student T2 WHERE T1.marks ...
0 votes
1 answer
2149
0 votes
0 answers
2152
2 votes
1 answer
2153
A file is organized so that the ordering of data record is same as or close to the ordering of data block in some index. The that index is calleda. Denseb. Sparsec. CLust...
4 votes
2 answers
2154
What is the difference between record & block pointer and any resource with diagram to know more about it?Keys and records are same or not ?
18 votes
1 answer
2155
Difference between left biasing and right biasing in B+ tree insertion, Rules to be followed for left and right biasing , Kindly explain with an example ?
33 votes
4 answers
2157
2 votes
1 answer
2158
0 votes
2 answers
2159