Oracle 1z0-148 問題集

質問 1：
Examine these statements regarding the DBMS_RESULT_CACHE package:
1.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by the PL/ SQL function result cache only.
2.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by both the PL/SQL function result cache and the SQL result cache.
3.DBMS_RESULT_CACHE package is owned by the SYS user.
4.RESULT_CACHE_MODE can be set using a subprogram defined in the DBMS_RESULT_CACHE package.
Which set of statements is correct?
A. 1 and 4
B. 2, 3 and 4
C. 2 and 4
D. 2 and 3
E. 1 and 3
正解：C

質問 2：
Identify the three options which make a PL/SQL function highly suitable for using the RESULT_CACHE clause in its definition. (Choose three.)
A. The value returned by the function is deterministic for a given set of input parameters.
B. The function has complex business logic depending on more than five tables to compute its return values.
C. The tables which are read in the function are very frequently updated.
D. The function involves highly computational logic with minimal or no database access.
E. The code in the function performs more write operations on the database when compared to the read operations.
F. The logic in the function accesses tables or uses package variables which are modified very rarely.
正解：A,D,F

質問 3：
Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?
A. ALL_PLSQL_OBJECT_SETTINGS
B. ALL_SOURCE
C. ALL_DEPENDENCIES
D. ALL_PROCEDURES
E. ALL_OBJECTS
正解：D

質問 4：
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. Add the RELIES_ON clause to the function definition.
C. Add the RESULT_CACHE clause to the function definition.
D. Ensure RESULT_CACHE_MAX_SIZE is greater than 0.
E. Add the deterministic clause to the function definition.
正解：D,E

質問 5：
Examine the EMPLOYEE_IDS table its data:

Examine this PL/SQL block:

What is the result of executing this PL/SQL block with SERVEROUTPUT enabled?
A. Compilation fails saying EMP_TAXID must be declared.
B. An exception is thrown at runtime saying EMP_TAXID is not visible.
C. It executes successfully and outputs:Fetched: 1011, JJONES, -1Fetched: 1012, SSMITH, -1
D. It executes successfully and outputs:Fetched: 1011, JJONES, 3789Fetched: 1012, SSMITH, -1
E. It executes successfully and outputs:Fetched: 1011, JJONES,Fetched: 1012, SSMITH,
正解：A

質問 6：
Examine this external function declaration:

Which C function does it publish?
A. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, int* p3);
B. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, OCINumber p3);
C. OCINumber compareAndSum (OCIExtProcContext *ctx, OCINumber p1, OCINumber p2, OCINumber p3);
D. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, int p3);
E. OCINumber compareAndSum (OCIExtProcContext *ctx, OCINumber p1, OCINumber p2, OCINumber
*p3);
F. int compareAndSum (OCIExtProcContext *ctx, int p1, int p2, OCINumber *p3);
G. OCINumber * compareAndSum (OCIExtProcContext *ctx, OCINumber *p1, OCINumber *p2, OCINumber *p3);
正解：A