Home » Other » Training & Certification » 1Z0-001 Check wrong or true
1Z0-001 Check wrong or true [message #181737] Tue, 11 July 2006 05:52 Go to next message
nghiant
Messages: 38
Registered: July 2006
Location: Viet Nam
Member
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.

I think it must be:
UPDATE emp
SET values job = 'Administrative Clerk'
WHERE job = 'Clerk';
Because in C clause, it will update all job (CLErk, CLErK, ...)
Please help me explain it
Re: 1Z0-001 Check wrong or true [message #181743 is a reply to message #181737] Tue, 11 July 2006 06:46 Go to previous message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
C is correct. There is no deference between a "Clerk" and a "CLerk". They are both Clerks.

Anyway, you are supposed to choose the best answer - again, it will be C.

So, however you look at the question, the answer remains C!
Previous Topic: DBA JOB
Next Topic: 10g DBA and Apps DBA FROM ORACLE (India)
Goto Forum:
  


Current Time: Wed Jun 16 16:19:35 CDT 2021