QUESTION 63
You need to change the job title Clerk to Administrative Clerk
for all Clerks.
Which statement does this?
A. UPDATE emp
SET job = 'Administrative Clerk';
B. UPDATE emp
Job := 'Administrative Clerk'
WHERE UPPER (job) = 'Clerk';
C. UPDATE emp
SET job = 'Administrative Clerk'
WHERE UPPER (job) = 'CLERK';
D. UPDATE emp
SET values job = 'Administrative Clerk'
WHERE UPPER (job) = 'Clerk';
Answer: C
Explanation:
Answer C is correct because function UPPER will convert all letters in JOB column to
uppercase and compare it to 'CLERK', identifying all Clerks. Command UPDATE ... SET
will set new value to 'Administrative Clerk' for these records.
Incorrect Answers:
A: Statement will change job to 'Administrative Clerk' for ALL records in the table.
B: Statement will not change job to 'Administrative Clerk' for any record in the table
because function UPPER will convert all letters in JOB column to uppercase and
comparison of its result with string 'Clerk' will return no records to change.
D: The statement contains syntax error : SET values.