Solved

Structure of the BOOKS Table

Question 81

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
Structure of the BOOKS table
   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
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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions