최신Oracle database 11g:advanced pl/sql - 1Z0-146무료샘플문제

A. if the first time a session on this database instance invokes the function with a parameter value

B. 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

C. if the memory allocated for the result cache is increased

D. if a session on this database instance invokes the function with the same parameter values

A. Nested tables cannot be returned by a function.

B. The NEWNAMES nested table has not been initialized.

C. LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection types are not allowed in SQL statements.

D. The third element of OLDNAMES cannot be assigned to the third element of GROUP1 because they are of inconsistent data types.

E. The assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2.

A. Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in your query.

B. All query results are stored in the result cache if possible.

C. Query results that are bigger than the available space in the result cache are not cached.

D. Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query.

A. The existing extproc process is terminated and a new extproc is started.

B. The corresponding shared library is also removed from the system.

C. PL/SQL subprograms can be used to invoke the external C procedure.

D. The PL/SQL subprogram that depends on the external C program becomes invalid.

A. It is used only across statements in the same session.

B. It can be set at the system, session, or query level.

C. It can store the query results for temporary tables.

D. Cached query results become invalid when the data accessed by the query is modified.

A. The attribute can be set only in the package associated with the context.

B. The value for an attribute of a user-defined context can be set only by the ALTER SESSION command.

C. The context was created with a package name in the USING clause.

D. The package associated with the context did not exist at the time of creation of the context.

A. The DELETE(n) method cannot be used with varrays.

B. The NEXT method cannot be used with a nested table from which an element has been deleted.

C. The DELETE(n) method cannot be used with nested tables.

D. The NEXT method cannot be used with an associative array with VARCHAR2 key values.

A. results of a query having the GROUP BY clause

B. results of a query having the DATE data type in the WHERE clause

C. results of a query having the SYSDATE function

D. subquery results