Register

Recent questions tagged relational-algebra

1 votes
1 answer
63
ISI 2021 | PCB CS | Question: 9
In relational algebra, for any pair of relations $R_{1}$ and $R_{2}$, the standard division operation is denoted by $\div$ ...
In relational algebra, for any pair of relations $R_{1}$ and $R_{2}$, the standard division operation is denoted by $\div$ and defined as follows: $$ R_{1} \div R_{2}=\pi...
User Avatar
0 votes
0 answers
64
HCU PHD 2018 JUNE
Suppose there are three relations as given below: (x) R(a,b)= (0,1),(4,5),(8,9). (y) S(b,c )=(1,2),(5,2),(5,6),(5,10),(13,10). (z) T( c,d)=(2,3),(6,7)(10,11),(10,3) the number of tuples in (R * S) * T, where * is the full natural outer join, is: (a) 5 (b) 8 (c) 13 (d) 60
Suppose there are three relations as given below:(x) R(a,b)= (0,1),(4,5),(8,9).(y) S(b,c )=(1,2),(5,2),(5,6),(5,10),(13,10).(z) T( c,d)=(2,3),(6,7)(10,11),(10,3)the numbe...
User Avatar
0 votes
1 answer
65
HCU PHD 2019 May
if E1 and E2 are relational algebra expressions then which of the following is NOT a relational algebra expression (a) E1 U E2 (b) E1 X E2 (c) E1 - E2 (d) E1 / E2
if E1 and E2 are relational algebra expressions then which of the following is NOT a relational algebra expression(a) E1 U E2(b) E1 X E2(c) E1 - E2(d) E1 / E2
User Avatar
0 votes
2 answers
66
KVS Dec 2018
in relational databases, the natural join of two tables is (a) cartesian product always (b) combination of union and filtered cartesian product (c) combination of selection and filtered cartesian product (d) combination of projection and filtered cartesian product
in relational databases, the natural join of two tables is(a) cartesian product always(b) combination of union and filtered cartesian product(c) combination of selection ...
User Avatar
0 votes
1 answer
67
KVS Part B 2018
______ operation preserves those tuples that would be lost in____ (a) Natural join, Outer join (b) Outer join, Natural join (c) Left Outer Join, Right Outer Join (d) Left Outer Join, Natural Join
______ operation preserves those tuples that would be lost in____(a) Natural join, Outer join(b) Outer join, Natural join(c) Left Outer Join, Right Outer Join(d) Left Out...
User Avatar
0 votes
2 answers
68
NIELIT 2016
a tuple in relation DBMS is a equivalent to (a) Record (b) Field (c) File (d) Database
a tuple in relation DBMS is a equivalent to(a) Record(b) Field(c) File(d) Database
User Avatar
0 votes
1 answer
69
TNPSC 2017
the materialization approach of query evaluation includes (from root to leaf) : (a) π, ∞, σ (b) π, σ, ∞ (c) σ, π, ∞ (d) σ, ∞, π
the materialization approach of query evaluation includes (from root to leaf) :(a) π, ∞, σ(b) π, σ, ∞(c) σ, π, ∞(d) σ, ∞, π
User Avatar
0 votes
2 answers
70
TNPSC 2017
___________ operator is used to retain the unmatched rows of relations when they joined. (a) Outer Join (b) Inner Join (c) Natural Join (d) Self Join
___________ operator is used to retain the unmatched rows of relations when they joined.(a) Outer Join(b) Inner Join(c) Natural Join(d) Self Join
User Avatar
0 votes
2 answers
71
CIL
which of the following is a unary operation? (a) intersection (b) projection (c) join (d) cartesian Product
which of the following is a unary operation?(a) intersection(b) projection(c) join(d) cartesian Product
User Avatar
0 votes
1 answer
72
CIL 2020
the ____ defines a set of operations on relations, paralleling the usual algebraic operations such as addition, subtraction or multiplication, which operates on numbers. (a) Relational Calculas (b) Referential Integrity (c) Relational Algebra (d) Relations
the ____ defines a set of operations on relations, paralleling the usual algebraic operations such as addition, subtraction or multiplication, which operates on numbers.(...
User Avatar
0 votes
1 answer
73
CIL
relations and fields can be renamed in relational algebra using the renaming operator (a) ρ (b) σ (c) ∅ (d) ⟕
relations and fields can be renamed in relational algebra using the renaming operator(a) ρ(b) σ(c) ∅(d) ⟕
User Avatar
0 votes
1 answer
75
CIL, UPPCL AE CS 2019
Consider the relation schemas R(A, B, C, D) and S(D, E, F). What will be the degree of the resultant schema R * S, where star (*) symbol represents the natural join operation? (A) 3 (B) 4 (C) 6 (D) 5
Consider the relation schemas R(A, B, C, D) and S(D, E, F). What will be the degree of the resultant schema R * S, where star (*) symbol represents the natural join opera...
User Avatar
1 votes
2 answers
83
UGC NET CSE | October 2020 | Part 2 | Question: 64
Match $\text{List I}$ with $\text{List II}$ Let $R_1=\{(1,1), (2,2), (3,3)\}$ and $R_2=\{(1,1), (1,2), (1,3), (1,4)\}$ ... $A-I, B-II, C-IV, D-III$ $A-I, B-IV, C-III, D-II$ $A-I, B-III, C-II, D-IV$ $A-I, B-IV, C-II, D-III$
Match $\text{List I}$ with $\text{List II}$Let $R_1=\{(1,1), (2,2), (3,3)\}$ and $R_2=\{(1,1), (1,2), (1,3), (1,4)\}$$\begin{array}{llll} & \text{List I} & & \text{List I...
User Avatar
Page: