Online Access Free 1Z0-060 Exam Questions

Which two statements are true concerning Information Lifecycle Management (ILM) policies?

• A.ILM policy functions return a Boolean value.
• B.Multiple ILM policies may exist for the same table, if the action is compression and the scope is at the row level.
• C.Segment-level policies override row-level policies.
• D.Multiple ILM policies may exist for the same segment and any compression levels may be specified for any policy.
• E.Multiple ILM policies may exist for the same segment but greater compression levels must be specified at greater elapsed times.

You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions?

• A.Enable Flashback Data Archiving for the tables that require tracking.
• B.Create a Flashback Data Archive in any suitable tablespace.
• C.Create a Flashback Data Archive in the tablespace where the tables are stored.
• D.Enable supplemental logging for the database.
• E.Specify undo retention guarantee for the database.

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

• A.Implementing Database Resource Manager
• B.Decreasing the value of the IDLE_TIME resource limit in the default profile
• C.Setting a metric threshold
• D.Enabling resumable timeout for user sessions

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

• A.Tracking the most recent write timefor a table segmentin a usertablespace
• B.Tracking the most recent write time for a table segment in the SYSAUX tablespace
• C.Tracking the most recent read time for a table segment in the SYSAUX tablespace
• D.Tracking insert time by row for table rows
• E.Tracking the most recent read time for a table segment in a user tablespace
• F.Tracking the most recent write time for a table block

In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

• A.The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• B.The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• C.Setting the target tablespace to read-only after the segments are moved
• D.The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• E.Taking the target tablespace offline after the segments are moved