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

You execute this PL/SQL block:

What will be the outcome?

• A.It will fail compile because of errors at lines 5 and 6.
• B.It will fail compile and execute successfully.
• C.It will fail compile because of error at line 7.
• D.It will fail compile because of errors at lines 6 and 12.
• E.It will fail compile because of errors at lines 11 and 12.

Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles?

• A.If a table was not created with compression specified in the store as securefile clause then DBMS_LOB.SETOPTIONS can be used to enable it later.
• B.DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.
• C.DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
• D.DBMS_LOB.GETOPTIONS can only be used for BLOB data types.

Examine this code (all compiled into schema HR):

Execute this code:
SET SERVEROUTPUT ON;
EXEC test_pkg.do_stuff
What is the correct output?

• A.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 TEST_PKG.DO_STUFF2 4 TEST_PKG.DO_STUFF.NP12 3
  TEST_PKG.DO_STUFF.NP1.NP22 2 TEST_PKG.DO_STUFF.NP1.NP2.NP30 1
  FORMAT_CALL_STACK_12C
• B.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 package body HR.TEST_PKG2 4 package body HR.TEST_PKG3 3 package body HR.TEST_PKG4 2 package body HR.TEST_PKG0 1 procedure HR.
  FORMAT_CALL_STACK_12C
• C.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 DO_STUFF2 4 NP13 3 NP24 2 NP30 1 FORMAT_CALL_STACK_12C
• D.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 package body HR.TEST_PKG2 4 package body HR.TEST_PKG2 3 package body HR.TEST_PKG2 2 package body HR.TEST_PKG0 1 procedure HR.
  FORMAT_CALL_STACK_12C
• E.LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
  ___anonymous_block1 5 TEST_PKG.DO_STUFF2 4 TEST_PKG.DO_STUFF.NP13 3
  TEST_PKG.DO_STUFF.NP1.NP24 2 TEST_PKG.DO_STUFF.NP1.NP2.NP30 1
  FORMAT_CALL_STACK_12C

Examine the following SQL statement:
ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;
What is the result of executing this statements?

• A.The PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled.
• B.This statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level,
• C.The PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled.
• D.The PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result.

Examine this declaration section:

Which two executable sections will display the message 'Summary is null'?

• A.BEGIN1_rec.emp_id :=1;1_rec.expr_summary := NULL;1_emp :=emp_typ (1_rec);IF
  1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END;
• B.BEGIN1_rec := NULL;1_emp := emp_typ (1_rec);IF 1_emp (1).expr_summary IS EMPTY THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END;
• C.BEGIN1_emp := emp_typ ();IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;
• D.BEGIN1_emp. EXTEND;IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;
• E.BEGIN1_rec.emp_id :=1;1_rec.expr_summary := EMPTY_CLOB ();1_emp := emp_typ (1_rec);IF
  1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;