1z1-148 무료 덤프문제 온라인 액세스

Which two statements are true about the DBMS_ LOB package?

• A.DBMS_LOB.COMPARE returns the size difference of the compared LOBs.
• B.Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist.
• C.If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB.
• D.DBMS_LOB.COMPARE can compare parts of two LOBs.
• E.DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs.

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

• A.The IN parameters must not include BLOB, CLOB, collection or record data types.
• B.The function must be created with invoker's rights or in an anonymous block.
• C.The function must be declared as a pipelined table function.
• D.The function must have an OUT or an IN OUT parameter.

Your company's executive team voted to give a one-time special bonus, the amount of which is to be based on number of years of service. The bonus table will be updated using a procedure called update_bonus().
Examine this PL/SQL block which shows the logic to calculate the bonus:

Consider these possible optimization actions:
1.Remove the service_days calculation statement.
2.Move bonus1 and bonus2 initializations out of the loop.
3.Inline the update_bonus() subprogram.
4.Call update_bonus(), passing the literal bonus amount instead of the bonus1 or bonus2 variables.
Which set of optimizations will be performed if this block is compiled with PLSQL_OPTIMIZE_LEVEL = 2?

• A.1 and 2 only
• B.3 and 4 only
• C.1 and 3 only
• D.1, 2, 3, and 4
• E.1, 2, and 4 only

Which two statements are correct about the collections before v3. DELETE is executed?

• A.The values of v3(31) (2) and v3 (33) (2) are identical.
• B.The value of v3 (31) (1) is "hello".
• C.The value of v3 (31) (3) is 6.
• D.The value of v3 (31) (1) and v3 (33) (3) are identical,
• E.The values of v3 (32) (2) and v1 (2) are identical.

A products TABLE exists with a PROD_ID column.
Examine this PL/SQL block:

Which statement is true?

• A.It executes successfully only if v_ref_cur: = DBMS_SQL.TO_CURSOR_NUMBER (v_cur); is added before the FETCH statement.
• B.It executes successfully only if the FETCH statement is replaced by DBMS_SQL.FETCH_ROWS (v_cur);
• C.It executes successfully only if the FETCH statement is replaced by DBMS_SQL.RETURN_RESULT (v_ref_cur);
• D.It executes successfully.
• E.It executes successfully only if v_ref_cur := DBMS_SQL.TO_REFCURSOR (V_CUR); is added before the FETCH statement.