Oracle 1Z0-146 Online Practice Questions and Exam Preparation

Oracle 1Z0-146 Online Questions & Answers

• Question 131:

  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.
  B. 1056 KB is allocated for the result cache, but the result cache is disabled.

• Question 132:

  Which statements are true about internal LOBs? (Choose all that apply.)

  A. They cannot use redo logging.
  B. They can be used as attributes of a user-defined data type.
  C. They cannot be passed as parameters to PL/SQL subprograms.
  D. They can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column.
  B. They can be used as attributes of a user-defined data type.
  D. They can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column.

• Question 133:

  Which two types of query results cannot be stored in the query result cache? (Choose two.)

  A. subquery results
  B. results of a query having the SYSDATE function
  C. results of a query having the GROUP BY clause
  D. results of a query having the DATE data type in the WHERE clause
  A. subquery results
  B. results of a query having the SYSDATE function

• Question 134:

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

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

• Question 135:

  Which two statements are true about the query results stored in the query result cache? (Choose two.)

  A. If any of the tables used to build a query is modified by an ongoing transaction in the current session, the query result is not cached.
  B. A query result based on a read-consistent snapshot of data that is older than the latest committed version of the data is not cached.
  C. Adding the RESULT_CACHE hint to inline views enables optimizations between the outer query and the inline view, and the query result is cached.
  D. A query result for a query that has a bind variable is stored in the cache and is reused if the query is equivalent even when the bind variable has a different value.
  A. If any of the tables used to build a query is modified by an ongoing transaction in the current session, the query result is not cached.
  B. A query result based on a read-consistent snapshot of data that is older than the latest committed version of the data is not cached.

• Question 136:

  Which two statements correctly describe the features of SecureFiles? (Choose two.)

  A. Compression does not entail table or index compression and vice-versa.
  B. Encryption stores the encryption keys for the LOB columns inside the database.
  C. Encryption stores the encryption keys for the LOB columns outside the database.
  D. Compression stores identical data occurring two or more times in the same LOB column as a single copy for the table.
  A. Compression does not entail table or index compression and vice-versa.
  C. Encryption stores the encryption keys for the LOB columns outside the database.