Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.
How do you achieve this?

• A.This cannot be done due to the lack of a clean restore point.
• B.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
• C.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
• D.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
• E.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

• A.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
• B.Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
• C.Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
• D.Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.
• E.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about performing an Oracle Database install on Linux?

• A.The Oracle database administrator must be granted access to the root operating system account to run root privileged scripts.
• B.It can be done after installing Grid Infrastructure for a Standalone Server.
• C.The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
• D.The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
• E.It can be done before installing Grid Infrastructure for a Standalone Server.
• F.The runfixup.sh script can install missing RPMs.
• G.It allows you to select the languages supported by the Oracle database server.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

• A.The number of table rows is considered when evaluating the cost of accessing a table using an index.
• B.Index balanced B*Tree height is considered when evaluating the cost of using an index.
• C.The Statistics Advisor can help recommend the best way to gather statistics.
• D.Statistics collected using DBMS_STATS always yield the best optimizer result.
• E.The Statistics Advisor generates actions for all recommendations.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about SGA memory management in a multitenant database? (Choose three.)

• A.Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
• B.SGA_MIN_SIZE cannot be set for a PDB.
• C.Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
• D.The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
• E.Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
• F.The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.

Comment: *

Name: *

Email: *

Verification: *