Which of the Following SQL Statements Will Grant the SELECT

question 97

Multiple Choice

Which of the following SQL statements will grant the SELECT privilege for the ORDERS table to all database users?

• A) GRANT SELECT ON orders TO PUBLIC;
• B) GRANT SELECT ON orders TO EVERYONE;
• C) GRANT SELECT ON orders TO *;
• D) none of the above

---

Definitions:

Stop-Loss

An order placed with a broker to buy or sell once the stock reaches a certain price, designed to limit an investor's loss on a security position.

Shelf Registration

Advance registration of securities with the SEC for sale up to 2 years following initial registration.

Primary Market

The financial market for new issues of securities, where buyers purchase directly from the issuer.

Stop-Buy Order

An order to purchase a security once its price surpasses a particular point, typically to limit a loss or protect a profit on a short sale.