Latest Oracle 1z1-148 Actual Free Exam Questions & Community Discussion, Page 1

Question #1

Examine this code:

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

A. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) ASTYPE cv_pordtyp IS REF CURSOR;cv cv_prodtyp;v_prodname prod_info.name%TYPE;v_listprice prod_info.price%TYPE;v_bind VARCHAR2 (400);BEGINv_bind := '%' | | p_product_name | |
'%';OPEN cv FOR 'SELECT name, price FROM prod_info WHERE name LIKE ' | | v_bind;LOOPFETCH 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;

B. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) ASTYPE cv_pordtyp IS REF CURSOR;cv cv_prodtyp;v_prodname prod_info.name%TYPE;v_listprice prod_info.price%TYPE;v_bind VARCHAR2 (400);BEGINv_bind := '''%' | | p_product_name | |
'%''';OPEN cv FOR 'SELECT name, price FROM prod_info WHERE name LIKE ' | | v_bind;LOOPFETCH 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;

D. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) ASTYPE cv_pordtyp IS REF CURSOR;cv cv_prodtyp;v_prodname prod_info.name%TYPE;v_listprice prod_info.price%TYPE;v_bind VARCHAR2 (400);BEGINv_bind := DBMS_ASSERT.ENQUOTE_LITERAL ('%' | | p_product_name | | '%');OPEN cv FOR 'SELECT name, price FROM prod_info WHERE name LIKE ' | | v_bind;LOOPFETCH 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;

E. CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) ASTYPE cv_pordtyp IS REF CURSOR;cv cv_prodtyp;v_prodname prod_info.name%TYPE;v_listprice prod_info.price%TYPE;v_bind VARCHAR2 (400);BEGINv_bind := '%' | | p_product_name | |
'%';OPEN cv FOR 'SELECT name, price FROM prod_info WHERE name LIKE :b' USING v_bind;LOOPFETCH 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;

Discussion 0

Correct Answer: A,C Vote an answer

Question #2

Examine these program units:

Which two blocks will execute successfully?

A. BEGINpkg2.proc3;END;

B. BEGINMy_proc;END;

C. BEGINpkg2.proc2;END;

D. BEGINpkg1.proc1b;END;

E. BEGINpkg1.proc1a;END;

Discussion 0

Correct Answer: A,C Vote an answer

Question #3

Which codes executes successfully?

A. DECLARETYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER);1_rec
rec-typ;PROCEDURE calc_price (price_rec IN OUT rec_typ) ASBEGINprice_rec.price := price-rec.price+ (price_rec.price * price_rec.inc_pct)/100;END;BEGIN1_rec_price :=100;1_rec.inc_pct
:=50;EXECUTE IMMEDIATE 'BEGIN calc_price (:rec); END;' USING IN OUT 1_rec;END;

B. CREATE PACKAGE pkg ASTYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER);END pkg;/CREATE PROCEDURE calc_price (price_rec IN OUT pkg. rec_typ) ASBEGINprice_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;END/DECLARE1_rec pkg.rec_typ;BEGINEXECUTE IMMEDIATE 'BEGIN calc_price (:rec); END;' USING IN OUT 1_rec (100, 50);END;

C. CREATE PACKAGE pkg ASTYPE rec_typ IS RECORD (price NUMBER, inc_pct
NUMBER);PROCEDURE calc_price (price_rec IN OUT rec_typ);END pkg;/CREATE PACAKGE BODY pkg ASPROCEDURE calc_price (price_rec IN OUT rec_typ) ASBEGINprice_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;END calc_price;END pkg;/DECLARE1_rec pkg. rec_typ;BEGIN1_rec_price :=100;1_rec.inc_pct :=50;EXECUTE IMMEDIATE 'BEGIN pkg.
calc_price (:rec); END;' USING IN OUT 1_rec;END;

D. CREATE PACKAGE pkg ASTYPE rec_typ IS RECORD (price NUMBER, inc_pct NUMBER);END pkg;/CREATE PROCEDURE calc_price (price_rec IN OUT pkg. rec_typ) ASBEGINprice_rec.price := price_rec.price + (price_rec.price * price_rec.inc_pct)/100;END ;/DECLARE1_rec pkg.
rec_typ;BEGIN1_rec_price :=100;1_rec.inc_pct :=50;EXECUTE IMMEDIATE 'BEGIN calc_price (1_rec); END;';END;

Discussion 0

Correct Answer: C Vote an answer

Question #4

Which two statements are true about inlining PL/SQL subprograms? (Choose two.)

A. Programs making use of large helper subroutines are good candidates for inlining.

B. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2.

C. PRAGMA INLINE must be specified.

D. PLSQL_OPTIMIZE_LEVEL must be set to 3 to inline external subroutines.

E. Only local subroutines can be inlined.

Discussion 0

Correct Answer: A,B Vote an answer

Question #5

Examine this block:

Which two will be correct after line 5?

A. va. LAST and va. LIMIT will return the same value.

B. va. NEXT (199) will return NULL.

C. va. LIMIT and va. COUNT will return the same value.

D. va. LIMIT and va. NEXT (199) will return the same value.

E. va. LAST and va. COUNT will return the same value.

F. va. LAST will return 200.

Discussion 0

Correct Answer: B,E Vote an answer

Question #6

Examine this code:

Assuming the default edition is ORA$BASE, what is the result of the last execution of hello?

A. An exception is raised.

B. Hello, edition 2.

C. Hello, edition 1.
Hello, edition 2.

D. Hello, edition 1.

E. Hello, edition 2.
Hello, edition 1.

Discussion 0

Correct Answer: D Vote an answer

Question #7

Examine this code:
CREATE TYPE list_typ IS TABLE OF NUMBER;
/
DECLARE
l_list list_typ := list_typ ();
Which two executable sections will display the message TRUE?

A. BEGINl_list.EXTEND;IF l_list.PRIOR (1_list.FIRST) IS NULL THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;

B. BEGINIF l_list.LIMIT IS NOT NULL THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;

C. BEGINIF l_list.FIRST IS NULL THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;

D. BEGINIF l_list.FIRST =1 THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;

E. BEGINl_list.EXTEND;IF l_list IS EMPTY THENDBMS_OUTPUT.PUT_LINE ('TRUE');END IF;END;

Discussion 0

Correct Answer: A,C Vote an answer

Question #8

Which data dictionary view includes information about the parameters of procedures and functions that you can call?

A. ALL_PACKAGES

B. ALL_OBJECTS

C. ALL_PROCEDURES

D. ALL_ARGUMENTS

Discussion 0

Correct Answer: B Vote an answer

Question #9

You are connected as SCOTT who has an EMP table with this structure:

Examine this code:

Assuming the default edition is ORA$BASE, which is correct?

A. The query will return records pertaining to department 20.

B. The query will return records pertaining to department 30.

C. The query will return records pertaining to department 30 with SAL and COMM values displayed as NULL.

D. The query will return records pertaining to department 20 with SAL and COMM values displayed as NULL.

Discussion 0

Correct Answer: C Vote an answer

Oracle 1z1-148 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z1-148 Demo