Which three statements are true about adaptive SQL plan management?

• A.It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
• B.The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
• C.It adds new, bettor plans automatically as fixed plans to the baseline.
• D.The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
• E.The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Comment: *

Name: *

Email: *

Verification: *

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?

• A.SYSTEM
• B.SYSAUX
• C.EXAMPLE
• D.UNDO
• E.TEMP
• F.USERS

Comment: *

Name: *

Email: *

Verification: *

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

• A.Oracle Data Pump.
• B.An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
• C.An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
• D.Online Table Redefinition.
• E.Edition-Based Table Redefinition.

Comment: *

Name: *

Email: *

Verification: *

You are administering a database stored in Automatic Storage Management (ASM).
You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?

• A.Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
• B.Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
• C.Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
• D.Use the MKDG command to restore the disk group with the same configuration as the backed- up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
• E.Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
• F.Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

Comment: *

Name: *

Email: *

Verification: *

A redaction policy was added to the SAL columnof the SCOTT.EMP table:

All users have their default set of system privileges.
For which three situations will data not be redacted?

• A.SYS sessions, regardless of the roles that are set in the session
• B.SYSTEM sessions, regardless of the roles that are set in the session
• C.SCOTT sessions, only if the MGR role is set in the session
• D.SCOTT sessions, only if the MGR role is granted to SCOTT
• E.SCOTT sessions, because he is the owner of the table
• F.SYSTEM session, only if the MGR role is set in the session

Comment: *

Name: *

Email: *

Verification: *