1.You are coding a PL/SQL block. PROC_A calls PROC B, which then calls PRoC C, and PROC B has no exception handler. If you wanted to prevent the PROC A procedure from failing due to a situation in PROC_B where the divisor in a division statement was zero, how would you address this in your code?
A .Use an if %zero_divide statement immediately following the math operation.
B. Code a when zero divide exception handler in PROC C.
C .Code a when others exception handler in PROC A.
C.ode a when others exception handler in PROC_C.
- You are developing SQL statements for the application. Which of the following SQL operations requires the use of a subquery
第一题没判断出来,第二题是A么。