Free Oracle 1Z0-146 Exam Dumps Questions & Answers

DATA_FILES is a directory object that contains the DETAILS.TXT text file.
You have the required permissions to access the directory object.
You create a table using the following command:
CREATE TABLE clob_tab(col2 CLOB);
View the Exhibit and examine the PL/SQL block that you execute for loading the external text file
into the table that currently has no rows. The PL/SQL block results in an error.

What correction must be done to ensure the PL/SQL block executes successfully?

• A.  The L_OUT variable has to be declared as a temporary LOB.
• B.  The L_OUT variable must be initialized to an empty locator.
• C.  The A_CLOB variable has to be declared as a temporary LOB.
• D.  The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly initialize the locator.

Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into database tables.

• A.  the trace file component
• B.  the data collection component
• C.  the shared library component
• D.  the analyzer component

View the Exhibit and examine the output.

Which statement is an inference from the output?

• A.  The class file is pinned into the Java pool.
• B.  The loadjava command has been executed to load the Java source and class files.
• C.  Java class methods in the Java class file have been published.
• D.  The class file has been loaded into the shared library.

You enabled PL/SQL tracing in a user session using the following command:
SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS);
View Exhibit1 to examine the output. After some time, the query produces a different result as
shown in Exhibit2.

What is the cause for the change?

• A.  The FOO procedure has been executed more than once.
• B.  The PLSQL_DEBUG parameter is set to FALSE for the user session.
• C.  The FOO procedure has been compiled with the DEBUG option, and executed.
• D.  Schema level statistics have been gathered by the database administrator (DBA).

In which two situations is the body of a result-cached function executed? (Choose two.)

• A.  if the memory allocated for the result cache is increased
• B.  if a session on this database instance invokes the function with the same parameter values
• C.  if the first time a session on this database instance invokes the function with a parameter value
• D.  if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function