Contents of BOOKS Table

question 29

Multiple Choice

Contents of BOOKS table
​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?

• A) ​SELECT * FROM books WHERE pubid LIKE "1";
• B) ​SELECT * FROM books WHERE pubid = 1;
• C) ​SELECT * FROM books WHERE pubid > 1;
• D) ​both a and b

---

Definitions:

Principle Parts

The essential components or sections of a mechanism or system that are critical to its functioning.

Atom

The smallest constituent unit of ordinary matter that constitutes a chemical element.

No Charge

A state or condition where an object does not have a net electrical charge, meaning it has an equal number of protons and electrons.

Neutron

One of the principal parts of an atom. The neutron has no charge and is part of the nucleus.