Multiple Choice
Structure of the BOOKS table
Structure of the PUBLISHER table
-Which of the following SQL statements will display the title of each book in the BOOKS table and the name of its publisher?
A) SELECT title, name
FROM publisher, books;
B) SELECT title, name
FROM publisher NATURAL JOIN books;
C) pubid;
D) SELECT title, name
FROM publisher, books
WHERE p.pubid =
E) both b and c
Correct Answer:

Verified
Correct Answer:
Verified
Q4: By default,use of the JOIN keyword creates
Q13: A join that is based upon data
Q18: Which of the following terms refers to
Q37: The <u>ON </u>clause can be used only
Q58: Which of the following types of joins
Q61: The _ JOIN keyword can be used
Q74: If a Cartesian join is used to
Q80: Which of the following will display all
Q96: A cross join between two tables,containing four
Q101: If a Cartesian join is used to