최신Oracle Database: Advanced PL/SQL - 1z0-148무료샘플문제

A. It will display the price increase by 1% only for all the products.

B. It will give an error because the calculated column in the cursor is not using a column alias in this block.

C. It will give an error because PDT_REC is not declared.

D. It will go into an endless loop because the loop exist condition is missing.

E. It will display the price increase by 1% only for the first product.

A. The query will only fetch records pertaining to department 30 with SAL and COMM displaying the actual data from the table.

B. The query will only fetch records pertaining to department 30 with SAL and COMM data replaced by
"xxxxx".

C. The query will fetch records from all departments with SAL and COMM values displayed as NULL for all records other than department 30.

D. The query will only fetch records pertaining to department 30 with SAL and COMM values displayed as NULL.

A. Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE, DBMS_LOB.SESSION);

B. pdatabuf (1) := NULL; should be added after line 4.

C. Rewrite the block as:DECLARETYPE databuf_arr IS TABLE OF CLOB INDEX BY BINATY_INTEGER;pdatabuf databuf_arr;PROCEDURE mytemplob (x OUT CLOB) ISBEGINDBMS_LOB.CREATETEMPORARY (x, TRUE, DBMS_LOB, SESSION);END;BEGINmytemplob (pdatabuf (1));END;/

D. Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOB.SESSION);

E. Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf (1), TRUE, DBMS_LOB.CALL);

A. EXEC get_tab_row_count (' "EMP" ');

B. EXEC get_tab_row_count ('emp');

C. EXEC get_tab_row_count ('DEPT, EMP')

D. EXEC get_tab_row_count ('DEPT');

E. EXEC get_tab_row_count ('SCOTT.EMP');

A. Programs that make use of smaller helper subroutines are good candidates for inlining.

B. Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.

C. You cannot inline an external subroutine.

D. Inlining will always decrease the size of a unit.

E. You cannot inline local subroutines.

F. Pragmas apply only to calls in the next statement following the pragma.

A. LexDepth Dynamic Depth Name----------- ------------------- -------------------------------------------0 6
___anonymous_block1 5 DO_STUFF2 4 NP13 3 NP24 2 NP30 1 FORMAT_CALL_STACK_12C

B. 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

C. 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

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

A. CREATE FUNCTION p4 (y pkg.tab_typ) RETURN pkg.tab_typ ISBEGINEXECUTE IMMEDIATE
'SELECT pdt_id, pdt_name FROM TABLE (:b)'BULT COLLECT INTO pkg.x USING y;RETURN pkg.x;END p4;

B. CREATE PROCEDURE p2 (v IN OUT VARCHAR2) ISBEGINEXECUTE IMMEDIATE 'SELECT f (:b) FROM DUAL' INTO v USING pkg.x;END p2;

C. CREATE FUNCTION p3 RETURN pkg. tab_typ ISBEGINEXECUTE IMMEDIATE 'SELECT f (:b) FROM DUAL' INTO pkg.x;END p3;

D. CREATE PROCEDURE p1 (y IN OUT pkg.tab_typ) ISBEGINEXECUTE IMMEDIATE 'SELECT f (:b) FROM DUAL' INTO y USING pkg.x;END p1;

E. CREATE PROCEDURE p5 (y pkg. rec_typ) ISBEGINEXECUTE IMMEDIATE 'SELECT pdt_name FROM TABLE (:b)' BULK COLLECT INTO y USING pkg.x;END p5;