Pass with 1z1-148 Practice Materials 100% for sure

Examine this code:

The anonymous block fails this error stack:

Which two changes, when separately applied, would prevent these errors from occurring?

• A. Define v1 as employees%ROWTYPE.
• B. Nothing because using the function TABLE (V1) is prohibited.
• C. Initialize v1 and v2 with appropriate constructor functions.
• D. Define v2 as pkg. rec.
• E. Define v2 as employees%ROWTYPE.

Examine the incomplete code:

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

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

Examine this function header:
FUNCTION calc_new_sal (emp_id NUMBER) RETURN NUMBER;
You want to ensure that whenever this PL/SQL function is invoked with the same parameter value across active sessions, the result is not recomputed.
If a DML statement is modifying a table which this function depends upon, the function result must be recomputed at that point in time for all sessions calling this function.
Which two actions should you perform?

• A. Enable the result cache by using DBMS_RESULT_CACHE.BYPASS (FALSE).
• B. Ensure RESULT_CACHE_MAX_SIZE is greater than 0.
• C. Add the RELIES_ON clause to the function definition.
• D. Add the deterministic clause to the function definition.
• E. Add the RESULT_CACHE clause to the function definition.

Examine this function:

Execute the query:
SELECT remap_schema FROM dual;
Which is the correct output from the query?

• A. CREATE TABLE "EMP" ("EMPNO" NUMBER (4,0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4,0), "HIREDATE"DATE, "SAL" NUMBER (7, 2) , "COMM" NUMBER (7, 2), "DEPTNO" NUMBER (2,0),CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255STORAGE (INITIAL
  65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2417483645PCTINCREASE 0 FREELISTS
  1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CHACHE DEFAULT
  CELL_FLASH_CACHE DEFAULT)TABLESPACE "SYSAUX" ENABLE,CONSTRAINT
  "FK_DEPTNO" FOREIGN KEY ("DEPTNO")REFERENCES "DEPT" ("DEPTNO") ENABLE)
  SEGMENT CREATION IMMEDIATEPCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
  255NOCOMPRESS LOGGINGSTORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1
  MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS
  1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE
  DEFAULT)TABLESPACE "SYSAUX"
• B. CREATE TABLE "EMP" ("EMPNO" NUMBER (4, 0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4, 0), "HIREDATE" DATE, "SAL" NUMBER (7, 2), "COMM" NUMBER (7, 2), "DEPTNO" NUMBER (2, 0),CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")USING INDEX ENABLE,CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")REFERENCES "DEPT" ("DEPTNO") ENABLE)
• C. CREATE TABLE "EMP" ("EMPNO" NUMBER (4,0), "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4,0), "HIREDATE"DATE, "SAL" NUMBER (7,2) , "COMM" NUMBER (7,2), "DEPTNO" NUMBER (2,0),CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255STORAGE (INITIAL
  65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2417483645PCTINCREASE 0 FREELISTS
  1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CHACHE DEFAULT
  CELL_FLASH_CACHE DEFAULT)TABLESPACE "USERS" ENABLE,CONSTRAINT
  "FK_DEPTNO" FOREIGN KEY ("DEPTNO")REFERENCES "DEPT" ("DEPTNO") ENABLE)
  SEGMENT CREATION IMMEDIATEPCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
  255NOCOMPRESS LOGGINGSTORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1
  MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS
  1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE
  DEFAULT)TABLESPACE "USERS"
• D. CREATE TABLE "SCOTT". "EMP" ("EMPNO" NUMBER (4, 0), "ENAME" VARCHAR2 (10),
  "JOB" VARCHAR2 (9), "MGR" NUMBER (4, 0), "HIREDATE" DATE, "SAL" NUMBER (7, 2),
  "COMM" NUMBER (7, 2), "DEPTNO" NUMBER (2, 0),CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")USING INDEX ENABLE,CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")REFERENCES "DEPT" ("DEPTNO") ENABLE)

Examine this function body:

Which two headers will allow this function to compile successfully and take advantage of both invoker's rights and function result caching?

• A. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2AUTHID
  DEFINERISdate_hired DATE;
• B. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE RELIES_ON (employees)AUTHID CURRENT_USERISdate_hired DATE;
• C. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
  VARCHAR2RESULT_CACHEAUTHID DEFINERISdate_hired DATE;
• D. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN
  VARCHAR2RESULT_CACHEAUTHID CURRENT_USERISdate_hired DATE;
• E. CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE RELIES_ON (departments)AUTHID CURRENT_USERISdate_hired DATE;