1z0-084

1z0-084 practice questions, page 2 of 5, with answer review and explanations.

Question 6

You execute the following: EXECUTE DBMS_AUTO_TASK_ADMIN.DISABLE; Which advisor remains enabled?

  1. Automatic SQL Tuning
  2. SQL Plan Management Evolve Advisor
  3. Optimizer Statistics Advisor
  4. Automatic Optimizer Statistics Collection
  5. Automatic Segment Advisor

Question 7

You must write a statement that returns the ten most recent sales. Examine this statement: Users complain that the query executes too slowly. Examine the statement's current execution plan: What must you do to reduce the execution time and why?

  1. Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.
  2. Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.
  3. Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.
  4. Enable Adaptive Plans so that Oracle can change the join method as well as the join order for this query.
  5. Create an index on SALES.CUST_ID to force an INDEX RANGE SCAN on this index followed by a NESTED LOOP join between CUSTOMERS and SALES.

Question 8

Which two statements are true about Data Pump import for objects that used the In Memory (IM) column store in their source database? (Choose two.)

  1. It always gives preference to the IM column store clause defined at the tablespace level over table-level definitions.
  2. It must always transport existing INMEMORY attributes.
  3. Its INMEMORY_CLAUSE of the Data Pump Export allows modifications to IM column store clause of a table with existing INMEMORY setting
  4. Its TRANSFORM clause can be used to add the INMEMORY clause to exported tables that lack them.
  5. It ignores the IM column store clause of the exporting objects.
  6. It can generate the INMEMORY clause that matches the table settings at export time.

Question 9

For which two actions can SQL Performance Analyzer be used to assess the impact of changes to SQL performance? (Choose two.)

  1. storage, network, and interconnect changes
  2. operating system upgrades
  3. changes to database initialization parameters
  4. database consolidation for pluggable databases (PDBs)
  5. operating system and hardware migrations

Question 10

You want to reduce the amount of db file scattered read that is generated in the database. You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result? (Choose two.)

  1. recommendations regarding the creation of additional indexes
  2. recommendations regarding rewriting the SQL statements
  3. recommendations regarding the creation of materialized views
  4. recommendations regarding the creation of SQL Patches
  5. recommendations regarding partitioning the tables