최신Oracle database 11g:advanced pl/sql - 1Z0-146무료샘플문제
문제1
In which two situations is the body of a result-cached function executed? (Choose two.)
In which two situations is the body of a result-cached function executed? (Choose two.)
정답: A,B
문제2
View Exhibit1 and examine the structure of the EMPLOYEES table.

View Exhibit2 and examine the code in the PL/SQL block.
The PL/SQL block fails to execute.
What could be the reason?
View Exhibit1 and examine the structure of the EMPLOYEES table.

View Exhibit2 and examine the code in the PL/SQL block.
The PL/SQL block fails to execute.
What could be the reason?
정답: C
문제3
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.)
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.)
정답: B,C
문제4
You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?
You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?
정답: D
문제5
Which two statements are true about the SQL Query Result Cache? (Choose two.)
Which two statements are true about the SQL Query Result Cache? (Choose two.)
정답: B,D
문제6
You created an application context successfully. The user OE was granted the EXECUTE privilege on the DBMS_SESSION package. The user receives this error while setting the value for an attribute within the context: SQL> EXECUTE DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); BEGIN DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); END; * ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SESSION", line 94
ORA-06512: at line 1
What is the reason for this error?
You created an application context successfully. The user OE was granted the EXECUTE privilege on the DBMS_SESSION package. The user receives this error while setting the value for an attribute within the context: SQL> EXECUTE DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); BEGIN DBMS_SESSION.SET_CONTEXT('SALES_ORDERS_CTX','ACCOUNT_MGR','OE'); END; * ERROR at line 1: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SESSION", line 94
ORA-06512: at line 1
What is the reason for this error?
정답: A
문제7
View the Exhibit and examine the code in the PL/SQL block.

The PL/SQL block generates an error on execution. What is the reason?
View the Exhibit and examine the code in the PL/SQL block.

The PL/SQL block generates an error on execution. What is the reason?
정답: A
문제8
Which two types of query results cannot be stored in the query result cache? (Choose two.)
Which two types of query results cannot be stored in the query result cache? (Choose two.)
정답: C,D