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
Database Management System
cidacoder
asked
in
Databases
Dec 8, 2018
retagged
Mar 11, 2019
by
Naveen Kumar 3
284
views
0
votes
0
votes
If NO ATTRIBUTES are common in both relations (R and S) then the result of natural join is ??
a. Empty relation.
b. Cartesian Product of the relations.
gate-preparation
databases
natural-join
rdbms
cidacoder
asked
in
Databases
Dec 8, 2018
retagged
Mar 11, 2019
by
Naveen Kumar 3
by
cidacoder
284
views
answer
comment
Follow
share this
share
1 comment
by
Shubhgupta
commented
Dec 8, 2018
reply
Follow
share this
If there is nothing common between two tables then natural join works as cartesian product.
0
0
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
0
Answers
← Previous
Next →
← Previous in category
Next in category →
Related questions
0
votes
0
votes
1
answer
1
anupamsworld
asked
in
Databases
Aug 7, 2022
386
views
DBMS Join | Test Series | MadeEasy
In relational databases, the natural join of two tables: Can be equivalent to cartesian product of these two tables Is combination of union and filtered cartesian product Is combination of selection and filtered cartesian product Is combination of projection and filtered cartesian product MSQ Please describe your choice(s).
anupamsworld
asked
in
Databases
Aug 7, 2022
by
anupamsworld
386
views
rdbms
databases
natural-join
joins
0
votes
0
votes
1
answer
2
tishhaagrawal
asked
in
Databases
Dec 16, 2023
360
views
MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right? For example, in the above question - The ... the same below) Can anyone please explain whether I am approaching this right, or if I am missing something?
tishhaagrawal
asked
in
Databases
Dec 16, 2023
by
tishhaagrawal
360
views
databases
sql
query
gate-preparation
rdbms
doubt
made-easy-test-series
4
votes
4
votes
4
answers
3
Tuhin Dutta
asked
in
Databases
May 27, 2019
2,453
views
Doubt on database normalization for relation having all prime attributes
In a relation, if every attribute is prime but key may not be simple then the relation is in ______. A. 1NF B. 2NF C. 3NF D. BCNF
Tuhin Dutta
asked
in
Databases
May 27, 2019
by
Tuhin Dutta
2.5k
views
databases
database-normalization
rdbms
0
votes
0
votes
1
answer
4
iarnav
asked
in
Databases
Nov 27, 2017
431
views
database self doubt
what does this line means - Let r and s be two relations over the relation schemes R and S respectively and R has attribute A.
iarnav
asked
in
Databases
Nov 27, 2017
by
iarnav
431
views
databases
rdbms
relational-algebra
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
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
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy