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.)
For which two actions can SQL Performance Analyzer be used to assess the impact of changes to SQL performance? (Choose two.)
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.)
Multiple sessions are inserting data concurrently into a table that has an LOB column.At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.Which wait event will be raised in the other sessions that need space in the LOB column?
You manage a 19c database with default optimizer settings.This statement is used extensively as subquery in the application queries:SELECT city_id FROM sh2.sales WHERE city_id=:B1You notice the performance of these queries is often poor and, therefore, execute:SELECT city_id,COUNT(*) FROM sh2.sales GROUP BY city_id;Examine the results:There is no index on the CITY_ID column.Which two options improve the performance? (Choose two.)
The CURSOR_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an AWR report are due to a large number of hard parses because of several almost identical SQL statements.Which two actions could reduce the number of hard parses? (Choose two.)
