Question 126
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:
i.Long-running queries are not affected.
ii.No extra space is used.
iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
i.Long-running queries are not affected.
ii.No extra space is used.
iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?
Question 127
Which three statements are true about Flashback Data Archive? (Choose three.)
Question 128
Identify three benefits of unified auditing.
Question 129
You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command. (Choose two.)
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command. (Choose two.)
Question 130
Which four are true about Consolidated Database Replay? (Choose four.)