Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.)

• A.Taking the MASTERTBS tablespace offline
• B.Dropping the relationship between the tables
• C.Adding the MASTERTBS tablespace to the recovery set
• D.Putting the MASTERTBS tablespace in read-only mode

Comment: *

Name: *

Email: *

Verification: *

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

• A.Set DB_FLASH_CACHE_ZISE = 64G.
• B.Set DB_FLASH_CACHE_ZISE = 64G, 64G
• C.Set DB_FLASH_CACHE_ZISE = 128G.
• D.DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true regarding the startup of a database instance?

• A.Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIAT
• B.The instance does not start up normally and requires manual media recovery after a shutdown using the abort
  option.
• C.Media recovery is required when the database is shut down by using either the immediate option or the abort
  option.
• D.There is no difference in the underlying mechanics of the startup whether the database is shut down by using the
  immediate option or the abort option.
• E.Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the
  immediate option.

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? (Choose three.)

• 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: *

Which two statements are true about availability audit features after migration to unified auditing?

• A.The ability of users to audit their own schema objects is not available in the post- migrated database.
• B.Operating systemaudit trail is available in the post-migrated database.
• C.Network auditing is available in the post-migrated database.
• D.Mandatory auditing of audit administrative actions is available in the post-migrated database.

Comment: *

Name: *

Email: *

Verification: *