Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL exam question

PL/SQL exam question

From: <vsanker_at_yahoo.com>
Date: 2000/04/09
Message-ID: <8cq0ss$3hs$1@nnrp1.deja.com>#1/1

While practising with STS questions ,I happened to see this following question, which is abit confusing..

Evaluate this PL/SQL loop :

WHILE v_price < &&p_count LOOP
v_amount:=v_amount + 1;
v_price:=v_amount*&&p_pct_increase;
END LOOP; If V_PRICE is 45, P_COUNT is 75, and V_AMOUNT is 5, which P_PCT_INCREASE value would cause the loop to terminate ?

  1. 0
  2. 15
  3. 20
  4. 45
  5. 75

I think it is 15 but the answer is 20.

Can anybody please clarify??

Thanks & regards

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Apr 09 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US