Barney Learns That the Phone Number for His Friend Lacey

question 31

Multiple Choice

Barney learns that the phone number for his friend Lacey in his ADDRESS_BOOK table has been disconnected; thus, her number is now unknown to him. Which SQL statement should Barney use to update the table so as to reflect this unknown value?

• A) SELECT PHONE_NO FROM ADDRESS_BOOK WHERE (NAME = 'Lacey') SET NULL;
• B) ALTER ADDRESS_BOOK SET PHONE_NO = NULL WHERE (NAME = 'Lacey');
• C) UPDATE ADDRESS_BOOK SET PHONE_NO = 'NULL' WHERE (NAME = 'Lacey');
• D) UPDATE ADDRESS_BOOK SET PHONE_NO = NULL WHERE (NAME = 'Lacey');

---

Definitions:

Moral Sense

An innate or developed capacity to distinguish right from wrong and to feel empathy and duty toward others.

The Mean

In philosophy, particularly Aristotelian ethics, it refers to the desirable middle ground or moderation between two extremes.

Courage

The ability to do something that frightens one or the strength in the face of pain or grief.

Practical Wisdom

The ability to make the right decisions in everyday life by applying moral values and rational thought.