Question
13. SELECT FName,LName FROM DANCES WHERE Dance='Bachata' AND Dance='Salsa' query returns which one of the following a) First and Last names of People who can
13. SELECT FName,LName FROM DANCES
WHERE Dance='Bachata' AND Dance='Salsa'
query returns which one of the following
a) First and Last names of People who can dance "Bachata".
b) First and Last names of People who can dance "Salsa".
c) First and Last names of People who can dance "Bachata" or "Salsa".
d) First and Last names of People who can dance "Bachata" and "Salsa".
e) First and Last names of People who can dance "Bachata", but can not dance "Salsa".
f) First and Last names of People who can dance "Salsa", but can not dance "Bachata".
g) none of the above.
14. SELECT FName,LName FROM DANCES WHERE Dance='Bachata'
INTERSECT
SELECT FName,LName FROM DANCES WHERE Dance='Salsa'
query returns which one of the following
a) First and Last names of People who can dance "Bachata".
b) First and Last names of People who can dance "Salsa".
c) First and Last names of People who can dance "Bachata" or "Salsa".
d) First and Last names of People who can dance "Bachata" and "Salsa".
e) First and Last names of People who can dance "Bachata", but can not dance "Salsa".
f) First and Last names of People who can dance "Salsa", but can not dance "Bachata".
g) none of the above.
15. SELECT FName,LName FROM DANCES WHERE Dance='Bachata'
UNION
SELECT FName,LName FROM DANCES WHERE Dance='Salsa'
query returns which one of the following
a) First and Last names of People who can dance "Bachata".
b) First and Last names of People who can dance "Salsa".
c) First and Last names of People who can dance "Bachata" or "Salsa".
d) First and Last names of People who can dance "Bachata" and "Salsa".
e) First and Last names of People who can dance "Bachata", but can not dance "Salsa".
f) First and Last names of People who can dance "Salsa", but can not dance "Bachata".
g) none of the above.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Introduction To Database And Knowledge Base Systems
Authors: S Krishna
1st Edition
9810206208, 978-9810206208
