Oracle 1Z0-146 問題集

質問 1：
Which two reports can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)
A. DDL report for all objects dependent on a table
B. DDL report for all the objects stored in a tablespace
C. DDL report for all the invalidated objects in a schema
D. data definition language (DDL) report for all the tables in a schema
正解：A,D

質問 2：
View the Exhibit and examine the settings for the PLSQL_CODE_TYPE parameter.

After sometime, the user recompiles the procedure DISPLAY_SAL_INFO by issuing the following
command:
SQL> ALTER PROCEDURE display_sal_info COMPILE;
Which statement would be true in this scenario?
A. The command would produce an error and the procedure must be compiled using the PLSQL_CODE_TYPE attribute with value INTERPRETED.
B. The procedure would be changed to INTERPRETED code type.
C. The procedure would be invalidated.
D. The procedure would remain as NATIVE code type.
正解：B

質問 3：
The following command is executed to start tracing in a user session:
SQL> EXECUTE
DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_EXCEPTIONS);
Which statement is true about the effect of the command?
A. It allows tracing of system-defined exceptions raised by all subprograms executed in the session.
B. It allows tracing of user-defined exceptions raised by all subprograms executed in the session.
C. It allows tracing of exceptions raised by subprograms compiled with the DEBUG option and executed in the session.
D. It allows tracing of exceptions raised by all subprograms executed in the session.
正解：C

質問 4：
The result cache is enabled for the database instance.
Examine the following code for a PL/SQL function:
CREATE OR REPLACE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR
RESULT_CACHE RELIES_ON (HR.EMPLOYEES)
IS
date_hired DATE;
BEGIN
SELECT hire_date INTO date_hired
FROM HR.EMPLOYEES
WHERE EMPLOYEE_ID = emp_id;
RETURN TO_CHAR(date_hired);
END;
You notice that results for the functions are not used effectively. What do you recommend for
better utilization of the result cache? (Choose all that apply.)
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_MODE parameter to FORCE.
C. Increase the value for the RESULT_CACHE_MAX_SIZE parameter.
D. Add a format mask parameter, such as RETURN TO_CHAR(date_hired, fmt) to GET_HIRE_DATE.
正解：A,D

質問 5：
Examine the settings for a user session given below:
RESULT_CACHE_MODE= FORCE
What would be the implications of this setting on query execution? (Choose all that apply.)
A. All query results are stored in the result cache if possible.
B. Query results that are bigger than the available space in the result cache are not cached.
C. Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in your query.
D. Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query.
正解：A,B

質問 6：
Which two statements are true about the working of fine-grained access? (Choose two.)
A. User statements are dynamically modified by the Oracle server through a security policy function.
B. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.
C. Fine-grained access control policies always remain in effect until they are dropped from a table or view.
D. Security policies can be associated only with tables, but not with views.
正解：A,B

質問 7：
When do you use static SQL as a technique for avoiding SQL injection?
A. when the code contains data definition language (DDL) statements
B. when the SET clause values are unknown at the time of code compilation
C. when the WHERE clause values are unknown
D. when all Oracle identifiers are known at the time of code compilation
正解：D

質問 8：
Which two statements are true about associative arrays and varrays? (Choose two.)
A. Both associative arrays and varrays must use sequential numbers as subscripts.
B. Both associative arrays and varrays can be used as column types in database tables.
C. Only varrays must use sequential numbers as subscripts.
D. Only varrays can be used as column types in database tables.
正解：C,D

質問 9：
To examine the dependencies between all PL/SQL objects and the tables and views they
reference, you executed the following query as the user OE:
SQL> SELECT owner || '.' || NAME refs_table
, referenced_owner || '.' || referenced_name AS table_referenced
FROM all_dependencies
WHERE owner = USER
AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION')
AND referenced_type IN ('TABLE', 'VIEW')
AND referenced_owner NOT IN ('SYS', 'SYSTEM')
ORDER BY owner, NAME, referenced_owner, referenced_name;
Which statement is true about the output of the query?
A. It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.
B. It displays no rows because this query needs to be executed as the user SYS for required results.
C. It displays only those PL/SQL code objects created by the user OE that reference a table or view created by the user SYS.
D. It displays all PL/SQL code objects created by user OE that reference any table or view owned by other users except SYS and SYSTEM..
正解：D