You created a SQL Tuning Set (STS) containing resource-intensive SQL statements. You plan to run the SQL Tuning Advisor. Which two types of recommendations can be provided by the SQL Tuning Advisor? A. Semantic restructuring for each SQL statement B.…
In Your Database, The Cursor_Shareing Parameter is set to EXACT. In the Employees table, the data is significantly skewed in the DEPTNO column. The value 10 is found in 97% of rows. Examine the following command and out put. Which…
An application accessing your database got the following error in response to SQL query: ORA-12827: insufficient parallel query slaves available View the parallel parameters for your instance: No hints are used and the session use default parallel settings. What four…
Examine the Exhibit 1 to view the structure of and indexes for EMPLOYEES and DEPARTMENTS tables. Which three statements are true regarding the execution plan? Exhibit: A. The view operator collects all rows from a query block before they can…
Which two are benefits of In-Memory Parallel Execution? A. Reduction in the duplication of block images across multiple buffer caches B. Reduction in CPU utilization C. Reduction in the number of blocks accessed D. Reduction in physical I/O for parallel…
You plan to bulk load data INSERT INTO . . . SELECT FROM statements. Which two situations benefit from parallel INSERT operations on tables that have no materialized views defined on them? A. Direct path insert of a million rows…
Which are the two prerequisites for enabling star transformation on queries? A. The STAR_TRANSFORMATION_ENABLED parameter should be set to TRUE or TEMP_DISABLE. B. A B-tree index should be built on each of the foreign key columns of the fact table(s),…
Which two statements about In-Memory Parallel Execution are true? A. It can be configured using the Database Resource Manager. B. It increases the number of duplicate block images in the global buffer cache. C. It requires setting PARALLEL_DEGREE_POLICY to LIMITED.…
Which four statements are correct about communication between parallel execution process? A. The number of logical pathways between parallel execution producers and consumers depends on the degree parallelism. B. The shared pool can be used for parallel execution messages buffers.…
You have enabled DML by issuing: ALTER session ENABLE PARALLEL DML; The PARELLEL_DEGREE_POLICY initialization parameter is set to AUTO. Which two options true about DML statements for which parallel execution is requested? A. Statements for which PDML is requested will…