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
53
votes
3
answers
241
GATE CSE 2014 Set 3 | Question: 30
Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at least one associated dependent in the dependent relation. employee (empId, ... is greater than that of some dependent. all dependents. some of his/her dependents. all of his/her dependents.
go_editor
asked
in
Databases
Sep 28, 2014
by
go_editor
10.1k
views
gatecse-2014-set3
databases
relational-algebra
normal
36
votes
3
answers
242
GATE CSE 2014 Set 3 | Question: 21
What is the optimized version of the relation algebra expression $\pi_{A1}(\pi_{A2}(\sigma_{F1}(\sigma_{F2}(r))))$, where $A1, A2$ are sets of attributes in $r$ with $A1 \subset A2$ and $F1,F2$ are Boolean expressions based on the attributes in $r$ ... $\pi_{A2}(\sigma_{(F1 \wedge F2)}(r))$ $\pi_{A2}(\sigma_{(F1 \vee F2)}(r))$
go_editor
asked
in
Databases
Sep 28, 2014
by
go_editor
8.6k
views
gatecse-2014-set3
databases
relational-algebra
easy
29
votes
10
answers
243
GATE CSE 1998 | Question: 27
Consider the following relational database schemes: COURSES (Cno, Name) PRE_REQ(Cno, Pre_Cno) COMPLETED (Student_no, Cno) COURSES gives the number and name of all the available courses. PRE_REQ gives the information about which courses are pre- ... relational algebra: List all the courses for which a student with Student_no 2310 has completed all the pre-requisites.
Kathleen
asked
in
Databases
Sep 26, 2014
by
Kathleen
5.6k
views
gate1998
databases
relational-algebra
normal
descriptive
21
votes
1
answer
244
GATE CSE 1998 | Question: 1.33
Given two union compatible relations $R_1(A, B)$ and $R_2 (C, D)$, what is the result of the operation $R_1 \Join_{ A = C \wedge B = D} R_2$? $R_1 \cup R_2$ $R_1 \times R_2$ $R_1 – R_2$ $R_1 \cap R_2$
Kathleen
asked
in
Databases
Sep 26, 2014
by
Kathleen
5.6k
views
gate1998
normal
relational-algebra
31
votes
1
answer
245
GATE CSE 1999 | Question: 1.18, ISRO2016-53
Consider the join of a relation $R$ with a relation $S$. If $R$ has $m$ tuples and $S$ has $n$ tuples then the maximum and minimum sizes of the join respectively are $m+n$ and $0$ $mn$ and $0$ $m+n$ and $|m-n|$ $mn$ and $m+n$
Kathleen
asked
in
Databases
Sep 23, 2014
by
Kathleen
14.2k
views
gate1999
databases
relational-algebra
easy
isro2016
41
votes
5
answers
246
GATE CSE 2005 | Question: 30
Let r be a relation instance with schema R = (A, B, C, D). We define $r_1 = \pi_{A, B, C} (R)$ and $r_2=\pi_{A, D} (r)$. Let $s =r_1 \: * \: r_2$ where $*$ denotes natural join. Given that the decomposition of $r$ into $r_1$ and $r_2$ is lossy, which one of the following is TRUE? $s \subset r$ $r \cup s =r$ $r \subset s$ $r*s=s$
Kathleen
asked
in
Databases
Sep 22, 2014
by
Kathleen
12.4k
views
gatecse-2005
databases
relational-algebra
natural-join
normal
57
votes
7
answers
247
GATE CSE 2004 | Question: 51
Consider the relation Student (name, sex, marks), where the primary key is shown underlined, pertaining to students in a class that has at least one boy and one girl. What does the following relational algebra expression produce? (Note: $\rho$ ... of girl students with marks not less than some boy student names of girl students with more marks than all the boy students
Kathleen
asked
in
Databases
Sep 19, 2014
by
Kathleen
13.3k
views
gatecse-2004
databases
relational-algebra
normal
38
votes
4
answers
248
GATE CSE 2003 | Question: 30
Consider the following SQL query Select distinct $a_1, a_2, , a_n$ from $r_1, r_2, , r_m$ ... $\Pi_{a_1, a_2, a_n} \sigma_p \left(r_1 \cap r_2 \cap \dots \cap r_m \right)$
Kathleen
asked
in
Databases
Sep 16, 2014
by
Kathleen
7.0k
views
gatecse-2003
databases
relational-algebra
normal
28
votes
5
answers
249
GATE CSE 2002 | Question: 15
A university placement center maintains a relational database of companies that interview students on campus and make job offers to those successful in the interview. The schema of the database is given below: ... students were offered jobs, the name of the degree and the average offered salary of students in this degree program.
Kathleen
asked
in
Databases
Sep 16, 2014
by
Kathleen
4.0k
views
gatecse-2002
databases
normal
descriptive
relational-algebra
sql
43
votes
3
answers
250
GATE CSE 2001 | Question: 1.25
Let r and s be two relations over the relation schemes R and S respectively, and let A be an attribute in R. The relational algebra expression $\sigma_{A=a}(r \bowtie s)$ is always equal to $\sigma_{A=a}(r)$ $r$ $\sigma_{A=a}(r) \bowtie s$ None of the above
Kathleen
asked
in
Databases
Sep 14, 2014
by
Kathleen
5.4k
views
gatecse-2001
databases
relational-algebra
46
votes
3
answers
251
GATE CSE 2001 | Question: 1.24
Suppose the adjacency relation of vertices in a graph is represented in a table Adj $(X,Y).$ Which of the following queries cannot be expressed by a relational algebra expression of constant length? List all vertices adjacent to a given ... self loops List all vertices which belong to cycles of less than three vertices List all vertices reachable from a given vertex
Kathleen
asked
in
Databases
Sep 14, 2014
by
Kathleen
5.8k
views
gatecse-2001
databases
relational-algebra
normal
40
votes
3
answers
252
GATE CSE 2000 | Question: 1.23, ISRO2016-57
Given the relations employee (name, salary, dept-no), and department (dept-no, dept-name,address), Which of the following queries cannot be expressed using the basic relational algebra operations ... whose name is the same as their department name The sum of all employees' salaries All employees of a given department
Kathleen
asked
in
Databases
Sep 14, 2014
by
Kathleen
12.1k
views
gatecse-2000
databases
relational-algebra
easy
isro2016
58
votes
4
answers
253
GATE CSE 2008 | Question: 68
Let R and S be two relations with the following schema $R(\underline{P,Q}, R1, R2, R3)$ $S(\underline{P,Q}, S1, S2)$ where $\left\{P, Q\right\}$ is the key for both schemas. Which of the following queries are equivalent? $\Pi_P \left(R \bowtie S\right)$ ... Only I and II Only I and III Only I, II and III Only I, III and IV
Kathleen
asked
in
Databases
Sep 12, 2014
by
Kathleen
13.5k
views
gatecse-2008
databases
relational-algebra
normal
Page:
« prev
1
...
4
5
6
7
8
9
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
POWER GRID CORPORATION OF INDIA LIMITED
INSTITUTE OF BANKING PERSONNEL SELECTION
GATE Overflow books for TIFR, ISRO, UGCNET and NIELIT
RECRUITMENT IN OIL AND GAS CORPORATION LIMITED
Aptitude Overflow Book
Subjects
All categories
General Aptitude
(2.4k)
Engineering Mathematics
(9.1k)
Digital Logic
(3.2k)
Programming and DS
(5.8k)
Algorithms
(4.5k)
Theory of Computation
(6.6k)
Compiler Design
(2.3k)
Operating System
(4.9k)
Databases
(4.5k)
CO and Architecture
(3.7k)
Computer Networks
(4.5k)
Non GATE
(1.3k)
Others
(2.4k)
Admissions
(647)
Exam Queries
(841)
Tier 1 Placement Questions
(17)
Job Queries
(74)
Projects
(9)
Unknown Category
(855)
Recent questions tagged relational-algebra
Recent Blog Comments
@abir_banerjee Thanks Abir. I'm third year...
@nolan_keats Currently I am in third year...
@abir_banerjee thank you Abir.Supposing you...
@nolan_keats just a suggestion as I also...
@abir_banerjee Hope I can do this in span of one...