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

Examine these two columns:

Which set of paired items is valid with respect to the DBMS_PARALLEL_EXECUTE package?

• A.1-c, 2-a, 3-b, 4-e, 5-d
• B.1-e, 2-a, 3-c, 4-b, 5-d
• C.1-c, 2-d, 3-b, 4-e, 5-a
• D.1-b, 2-d, 3-c, 4-e, 5-a
• E.1-c, 2-b, 3-e, 4-a, 5-d

Examine the structure of the DEPT table which exists in both BRANCH1 and BRANCH2 schemas:

Examine this code:

Which three modifications must be done to endure the anonymous block displays the output form the BRANCH2.DEF DEPT table?

• A.Add BEQUEATH DEFINER to the EMP_COUNT_VW view.
• B.Add BEQUEATH CURRENT_USER to the EMP_COUNTS_VW view.
• C.Change the IF condition in the anonymous block to 1_dept IS EMPTY.
• D.Change the IF condition in the anonymous block to CARDINALITY (1_dept) IS NULL.
• E.Add AUTHID CURRENT_USER to the EMP_COUNT function.
• F.IN BRANCH2 execute GRANT INHERIT PRIVILEGES ON USER branch2 TO branch1;

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 :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;
• C.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;
• D.CREATE PROCEDURE list_products_dynamic (p_product_name VARCHAR2 DEFAULT NULL) ASv_bind VARCHAR2 (400);BEGINv_bind := '%' | | p_prodname | | '%';FOR rec IN ('SELECT name, price FROM prod_info WHERE name like ' | | v_bind) LOOPDBMS_OUTPUT.PUT_LINE ('Product Info: ' | | rec.name | | ',' | | rec.price);END LOOP;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 ' | | 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;

Which codes executes successfully?

• A.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;
• 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);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;
• D.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;

Examine this code:

Examine this query:
SELECT ename, d.dname, job, sal, comm FROM emp e, dept d WHERE d.deptno = e.deptno; Which statement is correct regarding the execution of this SQL query?

• A.The query will only fetch records pertaining to department 30 with SAL and COMM data replaced by
  "xxxxx".
• B.The query will only fetch records pertaining to department 30 with SAL and COMM displaying the actual data from the table.
• C.The query will only fetch records pertaining to department 30 with SAL and COMM values displayed as NULL.
• D.The query will fetch records from all departments with SAL and COMM values displayed as NULL for all records other than department 30.