O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Image Chapter 6 Mastery Check

1. Where is PL/SQL executed?

2. Which type of PL/SQL statement would you use to increase the price values by 15 percent for items with more than 1500 in stock and by 20 percent for items with fewer than 500 in stock?

A. A cursor FOR loop

B. An IF-THEN-ELSE command

C. An insert statement

D. An update statement

3. What is the fetch command used for?

4. What will the following command perform?

V_PRICE_TOLERANCE:= 500;

5. What is wrong with this function definition?

CREATE OR REPLACE FUNCTION raise_price
   (original_price IN NUMBER)
RETURN number
IS
BEGIN
   RETURN (original_price * 1.25);
END lower_price;

6. What is the advantage ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required