Online Access Free 1z1-148 Practice Test

Examine these program units:

Which two blocks will execute successfully?

• A.BEGINpkg2.proc3;END;
• B.BEGINpkg2.proc2;END;
• C.BEGINpkg1.proc1b;END;
• D.BEGINMy_proc;END;
• E.BEGINpkg1.proc1a;END;

You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table.
Under which two circumstances will the cache for this function not be used and the function body be executed instead?

• A.When the maximum amount of server result cache memory that can be used for a single result is set to 0.
• B.When the amount of memory allocated for the result cache is increased
• C.When the database administrator disables the result cache during ongoing application patching
• D.When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same session
• E.When the function is executed in a session frequently with the same parameter value

Examine this code executed in the ORA1 schema:

Examine this code executed by DBA_USER who has been granted the DBA role:
REVOKE INHERIT PRIVILEGES ON USER dba_user FROM PUBLIC;
Examine this query:
SELECT return_date (1) FROM dual;
What is the result of executing this query in the DBA_USER schema?

• A.It will execute successfully, return the date and the DBA role will be granted to ORA1.
• B.It will execute successfully and return the date but the DBA role will not be granted to ORA1.
• C.It will fail with a compile-time error.
• D.It will fail with a runtime error complaining of insufficient INHERIT PRIVILEGES.

Examine the incomplete code:

Which three lines of code must be added for it to successfully compile?

• A.curid NUMBER;
• B.curid SYS_FEFCURSOR;
• C.src_cur SYS_REFCURSOR;
• D.src_cur := DBMS_SQL.TO_REFCURSOR (curid);
• E.curid := DBMS_SQL.TO_CURSOR_NUMBER (src_cur);
• F.src_cur= NUMBER;

Which codes executes successfully?

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