Oracle 1z0-148 問題集

質問 1：
A products TABLE exists with a PROD_ID column.
Examine this PL/SQL block:

Which statement is true?
A. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.FETCH_ROWS (v_cur);
B. It executes successfully only if v_ref_cur: = DBMS_SQL.TO_CURSOR_NUMBER (v_cur); is added before the FETCH statement.
C. It executes successfully only if v_ref_cur := DBMS_SQL.TO_REFCURSOR (V_CUR); is added before the FETCH statement.
D. It executes successfully only if the FETCH statement is replaced by DBMS_SQL.RETURN_RESULT (v_ref_cur);
E. It executes successfully.
正解：B,D

質問 2：
The EMPLOYEES table exists in your schema and has columns LAST_NAME of data type VARCHAR2 and DEPARTMENT_ID of data type NUMBER.
There are six employees in DEPARTMENT_ID, 20. Examine this code:

What will be the outcome on execution?
A. The execution of this code will fail with an invalid cursor error and not display either output message.
B. The number of employees will be displayed as six for the first output message and an invalid cursor error will be thrown instead of displaying the second output message.
C. The number of employees will be displayed as six for the first output message and zero for the second output message.
D. The number of employees will be displayed as six for both output messages.
正解：B

質問 3：
Examine the following SQL statement:
ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;
What is the result of executing this statements?
A. The PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result.
B. The PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled.
C. This statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level,
D. The PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled.
正解：D

質問 4：
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. Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function.
B. Set the RESULT_CACHE_MAX_RESULT parameter to 0.
C. Add a parameter, fmt, and change the RETURN statement to:RETURN TO_CHAR (date_hired, fmt);
D. Set the RESULT_CACHE_MODE parameter to FORCE.
E. Increase the value for the RESULT_CACHE_MAX_SIZE parameter.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which statement is true about the DBMS_PARALLEL_EXECUTE package?
A. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
B. Users with CREATE TASK privilege can create or run parallel execution tasks.
C. No specific system privileges are required to create or run parallel execution tasks.
D. Only DBAs can create or run parallel execution tasks.
E. To execute chunks in parallel, users must have CREATE JOB system privilege.
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two statements are true regarding edition-based redefinition (EBR)?
A. When you change an editioned object, all of its dependents remain valid.
B. EBR does not let you upgrade the database components of an application while in use.
C. You never use EBR to copy the database objects and redefine the copied objects in isolation.
D. There is no default edition defined in the database.
E. Editions are non-schema objects.
F. Tables are not editionable objects.
正解：A,F