PostgreSQL_CE
PGCES-02 · Question #10
PGCES-02 Question #10: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #10. The question stem and answer options stay visible for context.
Question
In the "customer" table, you want to change the "email" values which have an "id" value of 10000 or less, to NULL. Select the correct SQL statement to achieve this task.
Options
- AUPDATE email = NULL FROM customer WHERE id <= 10000;
- BUPDATE customer SET email IS NULL WHERE id < 10001;
- CUPDATE customer SET email = NULL WHERE id <= 10000;
- DDELETE FROMcustomer.email WHERE id < 10001;
- EUPDATE FROM customer SET email = NULL WHERE id <= 10000;
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.