Dark Mode

Recent questions tagged databases

1 vote

1 answer

91

MADE EASY TEST SERIES
Unique not null is equivalent to primary key. Relational Algebra and SQL has same expressive power. Which of the above statements are False?

Sajal Mallick asked in Databases Nov 5, 2023

by Sajal Mallick

350 views

0 votes

0 answers

92

Hamburg University Exercise 4.1 Sizes of Relations
Given two relations R1 and R2 where R1 contains N1 tuples and R2 contains N2 tuples, give the minimum and maximum possible sizes (in tuples) for the relation produced by each of the following relational algebra expressions. Try to be as accurate as possible (i.e., formulate ... - (πB(R1) - πB(R2))| ≤ N1 (10): 0 ≤ |σA>B(R1) ∪ σA<B(R1)| ≤ N1

beginner asked in Databases Nov 1, 2023

200 views

0 votes

0 answers

93

Ace Academy Bits and Bytes
Assertion(a) : A relation R(ABC) is having 3 rows and results in 3 rows. Reason(r) : Natural Join join two tables based on all common columns with equality conditions. A . both 'a' and 'r' are true and 'r' is the correct ... 'a'. C. both 'a' and 'r' are false. D. 'a' is true but 'r' is false .

jaydip74 asked in Databases Oct 29, 2023

226 views

0 votes

0 answers

94

ER Diagram
Can someone please provide me with the correct explanation for this question

practicalmetal asked in Databases Oct 26, 2023

by practicalmetal

363 views

0 votes

1 answer

95

nihal_chourasiya asked in Databases Oct 14, 2023

by nihal_chourasiya

222 views

0 votes

0 answers

96

Database.
T1: R1(A), W1(A), R1 (B). W1(B); T2: R2(A), W2(A), R2(B). W₂(B) S1: R2(A), W2(A), R1 (A), W1(A), R1 (B), W1(B), R2(B), W2(B) Find out whether S1 is conflict serializable. 2) S1 R2(A), W2(A), R2(B). W1 (A), R1 (B), W1 ... (Y) W₁(X) Find out whether S1 and S2 are conflict serializable schedules. S1 R1(x) R3(y) W1(x) W2(y) R3(x) W2(x) Find out whether S₁ is conflict serializable schedules.

khushwant2 asked in Databases Oct 10, 2023

346 views

–1 vote

1 answer

97

Çșȇ ʛấẗẻ asked in Algorithms Oct 10, 2023

by Çșȇ ʛấẗẻ

127 views

Page:

« prev
1
2
3
4
5
6
7
8
9
...
97
next »

Recent questions tagged databases