This certification validates practical skills in enterprise business systems, with emphasis on configuring processes, managing information, and supporting business outcomes. It is intended for professionals who implement or operate enterprise business systems.
You execute the following:
EXECUTE DBMS_AUTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?
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?