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:

Valued Resources

Those assets or materials considered of high importance or worth by a society or individual, often critical for survival or well-being.

Social Interactions

encompass the ways in which individuals or groups relate, communicate, and act with one another within a society.

Feminism

A range of political movements, ideologies, and social movements that share a common goal: to define, establish, and achieve political, economic, personal, and social equality of sexes.

Gender

The social, cultural, and psychological traits and behaviors that a given culture associates with an individual's biological sex.