Question 106
Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)
Question 107
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.
Examine the following steps:
1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS ('SH', 'CUSTOMERS') FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, 'SH', 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE ('SH', 'CUSTOMERS') FROM dual statement.
Identify the correct sequence of steps.
Examine the following steps:
1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS ('SH', 'CUSTOMERS') FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, 'SH', 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE ('SH', 'CUSTOMERS') FROM dual statement.
Identify the correct sequence of steps.
Question 108
Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:
And then grant OPS$GUEST_USER the CREATE SESSION privilege.
Which two statements are true? (Choose two.)
OS_AUTHENT_PREFIX = OPS$
You execute the following command:
And then grant OPS$GUEST_USER the CREATE SESSION privilege.
Which two statements are true? (Choose two.)
Question 109
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)
Question 110
Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)