Question 66
In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.
Which statement is true about undo retention?
Which statement is true about undo retention?
Question 67
You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded during execution of a data manipulation language (DML) statement, the operation should abort and return an error.
However, queries should still be allowed, even if users have exceeded the undo space limitation.
How would you achieve this?
However, queries should still be allowed, even if users have exceeded the undo space limitation.
How would you achieve this?
Question 68
Which statement is true about the Log Writer process?
Question 69
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent
Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are
performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.
Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are
performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.
Question 70
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?