Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Week #10 Quiz - CIST1220-Structured Query Language-SQL

memorize.ai (lvl 286)

(0)

10 cards

()

Section 1

Preview this deck

The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column. A) True B) False

Front

1 / 10

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (10)

Section 1

(10 cards)

The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column. A) True B) False

Front

A) True

Back

An outer join operator consists of a minus sign enclosed in parentheses, (-). A) True B) False

Front

B) False

Back

A NATURAL JOIN is based on: A) Columns with the same name B) Columns with the same name and datatype C) olumns with the same datatype and width D) Tables with the same structure

Front

B) Columns with the same name and datatype

Back

In which of the following examples is the ORDERS table used as a column qualifier? A) o.order# B) orders.order# C) order#.o D) order#.orders

Front

B) orders.order#

Back

The NATURAL JOIN keywords can be used to create non-equality joins. A) True B) False

Front

B) False

Back

A(n) Cartesian Join replicates each row from the first table with every row from the second table. A) True B) False

Front

B) False

Back

Which of the following SQL statements will display the title of the books ordered by customer# 1003? A) SELECT title FROM customers NATURAL JOIN books WHERE customer# = 1003; B) SELECT title FROM customers JOIN orders USING (customer#) JOIN orderitems USING (order#) JOIN books USING (isbn) WHERE customer# = 1003; C) SELECT title FROM customers JOIN orders ON (customer#) JOIN orderitems ON (order#) JOIN books ON (isbn) WHERE customer# = 1003; D) both a and b

Front

B) SELECT title FROM customers JOIN orders USING (customer#) JOIN orderitems USING (order#) JOIN books USING (isbn) WHERE customer# = 1003;

Back

A(n) outer join can be created by not including a joining condition in a SELECT statement. A) True B) False

Front

B) False

Back

Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS? A) SELECT gift FROM promotion WHERE gift = minretail; B) SELECT gift FROM promotion, books WHERE retail >= minretail AND title = 'SHORTEST POEMS'; C) SELECT gift FROM promotion, books WHERE retail BETWEEN minretail AND maxretail AND title = 'SHORTEST POEMS'; D) none of the above

Front

C) SELECT gift FROM promotion, books WHERE retail BETWEEN minretail AND maxretail AND title = 'SHORTEST POEMS';

Back

A column qualifier indicates the column containing the data being referenced. A) True B) False

Front

B) False

Back