Free 1Z0-146 Braindumps


  • Exam Number: 1Z0-146
  • Provider: Oracle
  • Questions: 136
  • Updated On: 17-Nov-2018

QUESTION: 1
Which two types of metadata can be retrieved by using the various procedures in the
DBMS_METADATA PL/SQL package? (Choose two.)

A. report of invalidated objects in a schema
B. report of statistics of an object in the database
C. DDL for all object grants on a table in the database
D. data definition language (DDL) for all objects in a schema

Answer(s): C, D
QUESTION: 2
The database instance was recently started up. Examine the following parameter settings for
the database instance:
NAME TYPE VALUE
------------------------------------ ----------- ---------------------------- .........
result_cache_max_result integer 5
result_cache_max_size big integer 0
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
.........
You reset the value for the result_cache_max_size parameter by issuing the following
command:
SQL> ALTER SYSTEM SET result_cache_max_size = 1056k SCOPE = BOTH; System altered.
Which statement is true in this scenario?

A. 1056 KB is allocated for the result cache and the result cache is enabled.
B. 1056 KB is allocated for the result cache, but the result cache is disabled.
C. The results for only the queries that have the RESULT_CACHE hint are cached.
D. The results for all the queries except those having the NO_RESULT_CACHE hint are
cached.

Answer(s): B
QUESTION: 3
In a user session, tracing is enabled as follows:
SQL> EXECUTE
DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ENABLED_LINES); PL/SQL
procedure successfully completed.
You executed the procedure as follows:
SQL> EXECUTE PROC10
PL/SQL procedure successfully completed.
When you examine the PLSQL_TRACE_EVENTS table, you find that no trace information was
written into it.
View the Exhibit.

Get The Premium Version

Allbraindumps.com
 Test Questions PDF from Myitguides.com

 Test Questions PDF from Myitguides.com