1z0-148 試験問題を無料オンラインアクセス

This result cache is enabled for the database instance.
Examine this code for a PL/SQL function:

Which two actions would ensure that the same result will be consistently returned for any session when the same input value is passed to the function?

• A.Set the RESULT_CACHE_MAX_RESULT parameter to 0.
• B.Set the RESULT_CACHE_MODE parameter to FORCE.
• C.Add a parameter, fmt, and change the RETURN statement to:RETURN TO_CHAR (date_hired, fmt);
• D.Increase the value for the RESULT_CACHE_MAX_SIZE parameter.
• E.Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function.

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 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"
• C.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)
• D.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)

In your schema, the DEPARTMENTS table contains the columns DEPARTMENT_ID and DEPARTMENT_NAME.
You want to display the department name for existing department id 10.
With SERVEROUTPUT enabled, which two blocks of code will give the required output?

• A.DECLARETYPE names_t IS TABLE OF SYS_REFCURSOR INDEX BY PLS_INTEGER;cv1 names_t;v_dept_name departments.department_name%TYPE;BEGINOPEN cv1 FOR SELECT department_name FROM departments WHERE department_id=10;FETCH cv1 INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);CLOSE cv1;END;
• B.DECLAREcv1 SYS_REFCURSOR;v_dept_name
  departments.department_name%TYPE;BEGINEXECUTE IMMEDIATE 'BEGIN OPEN: cv1 FORSELECT department_name FROM departmnets WHERE department_id=10: END;'USING IN cv1;FETCH cv1 INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);CLOSE cv1;END;
• C.DECLARETYPE dept_cur IS REF CURSOR RETURN departments%ROWTYPE;cv1
  dept_cur;v_dept_name departments.department_name%TYPE;BEGINOPEN cv1 FOR SELECT * FROM departments WHERE department_id=10;FETCH cv1. department_name INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);CLOSE cv1;END;
• D.DECLARETYPE dept_cur IS REF CURSOR;cv1 dept_cur;v_dept_name departments.
  department_name%TYPE;BEGINOPEN cv1 FOR SELECT department_name FROM departments WHERE department_id=10;IF cv1 IS NOT NULL THENFETCH cv1 INTO v_dept_name;DBMS_OUTPUT.PUT_LINE (v_dept_name);END IFCLOSE cv1;END;

Examine this code:

The anonymous block fails this error stack:

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

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

Examine the DBMS_LOB.LOADCLOBFROMFILE procedure:

Which statement is true about DBMS_LOB.LOADCLOBFROMFILE?

• A.An exception will always be raised if amount plus src_offset exceeds the length of the BFILE.
• B.The amount parameter can be set to DBMS_LOB.LOBMAXSIZE to indicate to load to the end of the BFILE.
• C.If any error occurs when calling the procedure then it is written to the warning parameter and DBMS_LOB.LOADCLOBFROMFILE finishes successfully.
• D.The amount parameter can be set to NULL to indicate to load to the end of the BFILE.