In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

• A.The partitions can be moved online to new tablespaces.
• B.Global indexes must be rebuilt manually after moving the partitions.
• C.The partitions can be compressed in the same tablespaces.
• D.The partitions can be compressed in the new tablespaces.
• E.Local indexes must be rebuilt manually after moving the partitions.

Comment: *

Name: *

Email: *

Verification: *

You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario?

• A.The database must be opened with the RESETLOGSoption after the flashback is complete.
• B.The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
• C.The database must use block change tracking for the flashback to succeed.
• D.The database must have multiplexed redo logs for the flashback to succeed.
• E.The database must be opened in restricted mode for the flashback to succeed.
• F.The database must be MOUNTED for the flashback to succeed.

Comment: *

Name: *

Email: *

Verification: *

In your Oracle 12c database, you create two roles: AUDITORand AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMINrole, you execute the following PL/SQLblock:

Which statement is correct about the procedure?

• A.It always captures the use of the CREATE VIEW and CREATE TABLE privileges.
• B.It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT PAYABLE module is used.
• C.It always captures the use of the privileges exercised through the AUDITORand AUDIT_ADMIN roles.
• D.It captures the use of the privileges used through the AUDIT_ADMIN and AUDITORroles when the ACCOUNT PAYABLEmodule is used.

Comment: *

Name: *

Email: *

Verification: *

What are three purposes of the RMAN "FROM SERVICE" clause?

• A.to support file restoration over the network in a Data Guard environment
• B.to support PUSH-based active database duplication
• C.to support synchronization of a standby database with the primary database in a Data Guard environment
• D.to support active database duplication by taking image copies of the source database
• E.to support file recovery over the network in a Data Guard environment

Comment: *

Name: *

Email: *

Verification: *

You plan to drop the column of a table that has Flashback Archiving enabled.
You want to ensure minimal service disruption.
How would you do this in your Oracle 12c Database?

• A.Drop the column using the ALTER TABLEstatement.
• B.Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.
• C.Disable Flashback Archiving, drop the column, and re-enable Flashback Archiving.
• D.Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.
• E.Drop the column by using the DBMS_REDEFINITIONpackage.

Comment: *

Name: *

Email: *

Verification: *