You are administering a database, where an application frequently executes identical SQL statements with the same syntax. How will you optimize the query results without retrieving data blocks from the storage? A. By setting the CURSOR_SHARING parameter to FORCE. B.…

Identify two situations in which full table scans will be faster than index range scans. A. A query with a highly selective filter fetching less than 5 percent of the rows from a table. B. A highly selective query on…

You identified some DSS queries that perform expensive join and aggregation operations. The queries access historical data from noncurrent partition of the fact tables. What three actions could you perform to improve the response time of the queries without modifying…

Examine the following command: Which query transformation technique is used by the optimizer in this case? A. View merging B. Filter push-down C. Predicate pushing D. Predicate move-around

Examine the parallelism parameters for your instance: Examine the Exhibit to view the query and its explain plan output. All sessions use default parallelism settings. What two steps could you take to make the query execute in parallel? Exhibit: A.…

See the code fragment You receive the following error message: ORA-12827: insufficient parallel query slaves available Which three parameter settings could you change to avoid this error? A. Decrease the value of PARALLEL_MIN_PERCENT B. Increase the value of PARALLEL_MAX_SERVERS C.…

Examine the Exhibit. Given two sets of parallel execution processes, SS1 and SS2, which is true? Exhibit: A. Each process SS1reads some of the rows from the CUSTOMERS table and sends all the rows it reads to each process in…

Your database supports a workload consisting of three categories of SQL statements: - Statements that should execute in less than one minute - Statement that may execute for up to 15 minutes - Statements that may be executed for more…

Which two statements are true about the use of the DYNAMIC_SAMPLING hint in a query? A. It estimates selectivity better for the filters. B. It is always used for flashback queries that contain the AS OF clause. C. It cannot…

Examine the Exhibit to view the structure of and indexes for the EMPLOYEES and DEPARTMENTS tables: EXAMINE the SQL statement and its execution plan: Which two statements are correct regarding the execution plan? Exhibit: A. Step 2 is performing nested…