Create Next App

Question 67 🔥

In which situation will cached results become invalid?

Which database solution meets these requirements?

A. When the memory allocated to the server result cache is increased using the RESULT_CACHE_MAX_SIZE initialization parameter

Highly voted

B. When a session executes an insert, update, or delete statement on a table or view that is queried by the result-cached function

Highly voted

C. When a session on this database instance invokes the function with the same parameter values

Highly voted

D. When the RESULT_CACHE_MODE parameter is set to FORCE.

Highly voted

E. When a new session is opened to invoke the function which is already cached

Highly voted

Discussion of the question

Question 68 🔥

Which PRAGMA statement may enable associated PL/SQL functions to run more efficiently when called from SQL?

Which database solution meets these requirements?

A. PRAGMA SERIALLY_REUSABLE;

Highly voted

B. PRAGMA UDF;

Highly voted

C. PRAGMA INLINE (‘<function_name>’, ‘YES’);

Highly voted

D. PRAGMA AUTONOMOUS_TRANSACTION;

Highly voted

Discussion of the question

Question 69 🔥

Examine the structure and data in the CUSTOMERS table:Examine this code:What is the outcome on execution with SERVEROUTPUT enabled?

Which database solution meets these requirements?

A. It throws a NO_DATA_FOUND exception.

Highly voted

B. It displays 3 for both the row count and the total.

Highly voted

C. It throws a PL/SQL: numeric or value error: NULL index table key value exception.

Highly voted

D. It displays 3 for the row count and 2 for the total.

Highly voted

Discussion of the question

Question 70 🔥

Examine this code (all compiled into schema HR):Execute this code:SET SERVEROUTPUT ON;EXEC test_pkg.do_stuff -What is the correct output?

Which database solution meets these requirements?

A. LexDepth Dynamic Depth Name ----------- ------------------- ------------------------------------------- 0 6 ___anonymous_block 1 5 package body HR.TEST_PKG 2 4 package body HR.TEST_PKG 3 3 package body HR.TEST_PKG 4 2 package body HR.TEST_PKG 0 1 procedure HR. FORMAT_CALL_STACK_12C

Highly voted

B. LexDepth Dynamic Depth Name ----------- ------------------- ------------------------------------------- 0 6 ___anonymous_block 1 5 TEST_PKG.DO_STUFF 2 4 TEST_PKG.DO_STUFF.NP1 2 3 TEST_PKG.DO_STUFF.NP1.NP2 2 2 TEST_PKG.DO_STUFF.NP1.NP2.NP3 0 1 FORMAT_CALL_STACK_12C

Highly voted

C. LexDepth Dynamic Depth Name ----------- ------------------- ------------------------------------------- 0 6 ___anonymous_block 1 5 TEST_PKG.DO_STUFF 2 4 TEST_PKG.DO_STUFF.NP1 3 3 TEST_PKG.DO_STUFF.NP1.NP2 4 2 TEST_PKG.DO_STUFF.NP1.NP2.NP3 0 1 FORMAT_CALL_STACK_12C

Highly voted

D. LexDepth Dynamic Depth Name ----------- ------------------- ------------------------------------------- 0 6 ___anonymous_block 1 5 DO_STUFF 2 4 NP1 3 3 NP2 4 2 NP3 0 1 FORMAT_CALL_STACK_12C

Highly voted

E. LexDepth Dynamic Depth Name ----------- ------------------- ------------------------------------------- 0 6 ___anonymous_block 1 5 package body HR.TEST_PKG 2 4 package body HR.TEST_PKG 2 3 package body HR.TEST_PKG 2 2 package body HR.TEST_PKG

Highly voted

Discussion of the question

Question 71 🔥

Examine this code:Which two are valid correlations to the code to avoid or mitigate SQL Injection?

Which database solution meets these requirements?

A. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) AS TYPE cv_pordtyp IS REF CURSOR; cv cv_prodtyp; v_prodname prod_info.name%TYPE; v_listprice prod_info.price%TYPE; v_bind VARCHAR2 (400); BEGIN v_bind := % | | p_product_name | | %; OPEN cv FOR SELECT name, price FROM prod_info WHERE name LIKE :b USING v_bind; LOOP FETCH cv INTO v_prodname, v_listprice; EXIT WHEN cv%NOTFOUND; DBMS_OUTPU.PUT_LINE (Product Info: | | v_prodname | | , | | v_listprice); END LOOP; CLOSE cv; END;

Highly voted

Highly voted

C. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) AS TYPE cv_pordtyp IS REF CURSOR; cv cv_prodtyp; v_prodname prod_info.name%TYPE; v_listprice prod_info.price%TYPE; v_bind VARCHAR2 (400); BEGIN v_bind := % | | p_product_name | | %; OPEN cv FOR SELECT name, price FROM prod_info WHERE name LIKE | | v_bind; LOOP FETCH cv INTO v_prodname, v_listprice; EXIT WHEN cv%NOTFOUND; DBMS_OUTPU.PUT_LINE (Product Info: | | v_prodname | | , | | v_listprice); END LOOP; CLOSE cv; END;

Highly voted

D. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) AS TYPE cv_pordtyp IS REF CURSOR; cv cv_prodtyp; v_prodname prod_info.name%TYPE; v_listprice prod_info.price%TYPE; v_bind VARCHAR2 (400); BEGIN v_bind := % | | p_product_name | | %; OPEN cv FOR SELECT name, price FROM prod_info WHERE name LIKE | | v_bind; LOOP FETCH cv INTO v_prodname, v_listprice; EXIT WHEN cv%NOTFOUND; DBMS_OUTPU.PUT_LINE (Product Info: | | v_prodname | | , | | v_listprice); END LOOP; CLOSE cv; END;

Highly voted

E. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) AS TYPE cv_pordtyp IS REF CURSOR; cv cv_prodtyp; v_prodname prod_info.name%TYPE; v_listprice prod_info.price%TYPE; v_bind VARCHAR2 (400); BEGIN v_bind := DBMS_ASSERT.ENQUOTE_LITERAL (% | | p_product_name | | %); OPEN cv FOR SELECT name, price FROM prod_info WHERE name LIKE | | v_bind; LOOP FETCH cv INTO v_prodname, v_listprice; EXIT WHEN cv%NOTFOUND; DBMS_OUTPU.PUT_LINE (Product Info: | | v_prodname | | , | | v_listprice); END LOOP; CLOSE cv;

Highly voted

Discussion of the question

Question 72 🔥

Which three statements are correct with reference to intra unit inlining?

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

C. You cannot inline an external subroutine.

Highly voted

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

Highly voted

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

Highly voted

F. You cannot inline local subroutines.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_148

Exam contains 75 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us