Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Recent questions tagged relational-algebra
0
votes
1
answer
1
DBMS relational algebra
Information about a collection of students is given by the relation studinfo (studid, name, sex). The relation enroll (studld, Courseld) gives which student has enrolled for (or taken) what course(s). Assume that every course is taken by at least one ... a proper subset of female students are enrolled (c) Courses in which only male students are enrolled (d) None of the above
rohitkaushal1
asked
in
Databases
Sep 25
by
rohitkaushal1
64
views
relational-algebra
databases
relations
gateforum-test-series
0
votes
0
answers
2
Best Open Video Playlist for Relational Algebra Topic | Databases
Please list out the best free available video playlist for Relational Algebra from Databases as an answer here (only one playlist per answer). We'll then select the best playlist and add to GO classroom video lists. You can ... standard ones are more likely to be selected as best. For the full list of selected videos please see here
makhdoom ghaya
asked
in
Study Resources
Aug 20
by
makhdoom ghaya
29
views
missing-videos
go-classroom
free-videos
video-links
relational-algebra
0
votes
0
answers
3
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$ ...
Lakshman Patel RJIT
asked
in
Databases
Aug 8
by
Lakshman Patel RJIT
27
views
isi2021-pcb-cs
descriptive
databases
relational-algebra
0
votes
0
answers
4
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
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
85
views
databases
relational-algebra
0
votes
1
answer
5
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
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
174
views
databases
relational-algebra
0
votes
1
answer
6
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
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
97
views
databases
relational-algebra
0
votes
1
answer
7
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
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
74
views
databases
relational-algebra
0
votes
2
answers
8
NIELIT 2016
a tuple in relation DBMS is a equivalent to (a) Record (b) Field (c) File (d) Database
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
69
views
databases
relational-algebra
0
votes
0
answers
9
TNPSC 2017
the materialization approach of query evaluation includes (from root to leaf) : (a) π, ∞, σ (b) π, σ, ∞ (c) σ, π, ∞ (d) σ, ∞, π
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
46
views
databases
relational-algebra
0
votes
2
answers
10
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
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
58
views
databases
relational-algebra
0
votes
2
answers
11
CIL
which of the following is a unary operation? (a) intersection (b) projection (c) join (d) cartesian Product
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
65
views
databases
relational-algebra
0
votes
1
answer
12
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
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
56
views
databases
relational-algebra
0
votes
1
answer
13
CIL
relations and fields can be renamed in relational algebra using the renaming operator (a) ρ (b) σ (c) ∅ (d) ⟕
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
37
views
databases
relational-algebra
0
votes
0
answers
14
CIL Part B
Consider the following relation schema R and S along with their tuple sets. R(A, B) = { <a1, b1 >, <a2, b1>, <a3, b1>, <a4, b1>, <a1, b2>, <a3, b2>, <a2, b3>, <a3, b3>, <a4, b3>, <a1, b4>, <a2, b4>, <a3, b4> } S(A) = ... operation? A. T(B) = {b1, b2, b4} B. T(B) = {b1, b3, b4} C. T(B) = {b1, b4) D. T(B) = {b1, b3}
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
36
views
databases
relational-algebra
0
votes
0
answers
15
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
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
38
views
databases
relational-algebra
0
votes
0
answers
16
appsc-2012-DL CA
The number of tuples in the result of a left outer join operation will always be (A) greater than the number of tuples in the result of the corresponding join operation. (B) at least equal to the number of tuples in the result of the ... of the corresponding join operation. (D) greater than the number of tuples in the result of the corresponding right outer join operation.
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
93
views
databases
relational-algebra
0
votes
0
answers
17
Referential Integrity Constraints
Question: If we have two relation R(A,B,C) and S(D,E,F),where A and D are primary key and attribute C is working as Foreign key and referring to D.So is it possible to C have NULL in some rows?? Reference:: https://gateoverflow.in/2151/Gate-cse-2012-question-43?state=showcomments-2377&show=2377#a2377
lalitver10
asked
in
Databases
Apr 8
by
lalitver10
114
views
self-doubt
relational-algebra
databases
1
vote
2
answers
18
conditional join, DBMS, projection operator
why don't we use the projection operator in conditional join?
raginibhayana
asked
in
Databases
Feb 16
by
raginibhayana
238
views
databases
relational-algebra
natural-join
relations
2
votes
1
answer
19
GATE CSE 2022 | Question: 15
Consider the following three relations in a relational database. $\text{Employee} (\underline{\text{eId}},\text{Name}), \; \text{Brand}(\underline{\text{bId}},\text{bName}), \; \text{Own}(\underline{\text{eId}},\underline{\text{bId}})$ Which of the following relational ... $ \Pi_{eId} \left( (\Pi_{eId}(Own) \times \Pi_{bId} (Own)) / \Pi_{bId} (Brand) \right)$
Arjun
asked
in
Databases
Feb 15
by
Arjun
1.3k
views
gatecse-2022
databases
relational-algebra
multiple-selects
6
votes
3
answers
20
GATE CSE 2021 Set 1 | Question: 27
The following relation records the age of $500$ employees of a company, where $empNo$ (indicating the employee number) is the key: $empAge(\underline{empNo},age)$ ... Employee numbers of all employees whose age is not the minimum Employee numbers of all employees whose age is the minimum
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
2.8k
views
gatecse-2021-set1
databases
relational-algebra
Page:
1
2
3
4
5
6
...
9
next »
Subscribe to GATE CSE 2023 Test Series
Subscribe to GO Classes for GATE CSE 2023
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
RECRUITMENT IN OIL AND GAS CORPORATION LIMITED
Aptitude Overflow Book
Participate in Machine Learning benchmarking
GATE Overflow Tikz Templates
UPSC One Time Registration OTR Online Form 2022
Subjects
All categories
General Aptitude
(2.4k)
Engineering Mathematics
(8.9k)
Digital Logic
(3.2k)
Programming and DS
(5.7k)
Algorithms
(4.5k)
Theory of Computation
(6.5k)
Compiler Design
(2.2k)
Operating System
(4.8k)
Databases
(4.4k)
CO and Architecture
(3.6k)
Computer Networks
(4.4k)
Non GATE
(1.2k)
Others
(2.5k)
Admissions
(645)
Exam Queries
(839)
Tier 1 Placement Questions
(17)
Job Queries
(73)
Projects
(9)
Unknown Category
(851)
Recent questions tagged relational-algebra
Recent Blog Comments
"If you are dead tomorrow your GATE rank is not...
@saheb sarkar1997 Please check the Test...
Sir some test due date passed 1-2 months ago pls...
@lalitver10 There is no restriction in doing...
@GateOverflow04 link fixed now.