Question $10/1$ point

Which of the following queries creates a Cartesian join?

Question options:

SELECT title, authorid

FROM books, bookauthor;

SELECT title, name

FROM books

CROSS JOIN publisher;

SELECT title, gift

FROM books

NATURAL JOIN promotion;

all of the above

Question $20/1$ point

Given the following

query:

SELECT title, gift

FROM books CROSS JOIN promotion;

Which of the following queries is equivalent?

Question options:

SELECT title, gift

FROM books NATURAL JOIN promotion;

SELECT title

FROM books INTERSECT

SELECT gift

FROM promotion;

SELECT title

FROM books UNION ALL

SELECT gift

FROM promotion;

all of the above

Question $30/1$ point

Which of the following

queries contains a non$-$equality join?

Question options:

SELECT title,authorid

FROM books, bookauthor

WHERE books.isbn $=$ bookauthor.isbn

AND retail $>20$;

SELECT title, name

FROM books

JOIN publisher

USING $($pubid$)$;

SELECT title, gift

FROM books, promotion

WHERE retail $>=$ minretail

AND retail $<=$ maxretail;

none of the above

Question $40/1$ point

Given the following

query:

SELECT zip, order#

FROM customers NATURAL JOIN orders;

Which of the following queries is equivalent?

Question options:

SELECT zip, order#

FROM customers JOIN orders

WHERE customers.customer# $=$ orders.customer#;

SELECT zip, order#

FROM customers, orders

WHERE customers.customer# $=$ orders.customer#;

SELECT zip, order#

FROM customers, orders

WHERE customers.customer# $=$ orders.customer# $(+)$;

none of the above

Question $50/1$ point

Given

the following query:

SELECT lastname, firstname, order# FROM customers LEFT

OUTER JOIN orders

USING $($customer#$)$ ORDER BY customer#;

Which of the following queries returns the same results?

Question options:

SELECT lastname, firstname, order#

FROM customers c

OUTER JOIN orders o

ON c$.$customer# $=$ o$.$customer#

ORDER BY c$.$customer#;

SELECT lastname, firstname, order#

FROM orders o

RIGHT OUTER JOIN customers c

ON c$.$customer# $=$ o$.$customer#

ORDER BY c$.$customer#

SELECT lastname, firstname, order#

FROM customers c$,$ orders o

WHERE c$.$customer# $=$ o$.$customer# $(+)$

ORDER BY c$.$customer#;

none of the above

Question $90/1$ point

Which line in the following SQL statement raises an error?

$1$ SELECT name, title

$2$ FROM books b$,$ publisher p

$3$ WHERE books.pubid $=$ publisher.pubid

$4$ AND

$5($retail $>25$ OR retail$-$cost $>18\mathrm{.}95)$;

Question options:

line $1$

line $3$

line $4$

line $5$

Question $100/1$ point

Which of the following

operators is not allowed in an outer join?

Question options:

AND

$=$

OR

$>$