Computer Certification

  1. Home
  2. Computing & Technology
  3. Computer Certification
OCP Practice Test
20 Free OCP Practice Questions for the 1Z0-001 Exam

Answer 12

Correct answer: c

Explanation:

The GoTo command is used for unconditional jumping to different portions of a PL/SQL block.

If-Then-Else statement will not allow you to jump to another section of a PL/SQL block. It first checks the condition, i.e., whether it is 'TRUE' OR 'FALSE' and accordingly executes the statement. Thus, choice A is incorrect.

Choice B is incorrect because all loops are simply iterative statements.

Choice D is incorrect because Decode function cannot be used in a PL/SQL block as it decodes an expression in an SQL statement similar to the IF-THEN-ELSE loop.

Next page > Question 13

Explore Computer Certification

About.com Special Features

Computer Certification

  1. Home
  2. Computing & Technology
  3. Computer Certification

©2009 About.com, a part of The New York Times Company.

All rights reserved.