Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CREATE TABLE DANCES (FName ANARCHAR(30) Name MARCHAR(30), MARCHAR (40), PRIMARY KEY (FName, LName, Dance) Dance 12. SELECT FName LName FROM DANCES WHERE Dance=Bachata' OR Dance=Salsa
CREATE TABLE DANCES (FName ANARCHAR(30) Name MARCHAR(30), MARCHAR (40), PRIMARY KEY (FName, LName, Dance) Dance 12. SELECT FName LName FROM DANCES WHERE Dance="Bachata' OR 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" ar "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 sl none of the above. 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" ar "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. sl 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. sl 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". sl 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