Online Access Free 1Z0-146 Practice Test

View the Exhibit to examine the PL/SQL code for the GET_METADATA function. Which statement is true about the metadata gathered by the function?

• A.The end result is the creation of DDL for all tables and associated indexes with all instances of the HR schema changed to SCOTT along with all physical, storage, logging, and other segment attributes.
• B.The end result is the creation of DDL for all tables with all instances of the HR schema changed to SCOTT along with all physical, storage, logging, and other segment attributes.
• C.The end result is the creation of DDL for the TIMECARDS table with all instances of the HR
  schema changed to SCOTT.
• D.The end result is the creation of an XML document for all tables with all physical, storage, logging, and other segment attributes.

You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which scenarios is the cached result bypassed? (Choose all that apply.)

• A.when the database administrator has disabled the use of the result cache during application patching
• B.when the function is executed in a session frequently with the same parameter value
• C.when the size for the memory allocated for the result cache is increased
• D.when a data manipulation language (DML) statement is executed in a session on a table or view that was specified in the RELIES_ON clause of a result-cached function

Which two statements are true about the SQL Query Result Cache? (Choose two.)

• A.Cached query results become invalid when the data accessed by the query is modified.
• B.It can store the query results for temporary tables.
• C.It can be set at the system, session, or query level.
• D.It is used only across statements in the same session.

Which two statements are true about cursor variables? (Choose two.)

• A.Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable.
• B.The query associated with a cursor variable cannot reference host variables and PL/SQL variables.
• C.The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set.
• D.The FETCH statement executes the query associated with a cursor variable and identifies the result set.
• E.Cursor variables can be parameterized like cursors.

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 class file has been loaded into the shared library.
• C.The loadjava command has been executed to load the Java source and class files.
• D.Java class methods in the Java class file have been published.