Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

• A.A PDB snapshot is always a full copy of the source PDB.
• B.A PDB snapshot is always a sparse copy of the source PDB.
• C.A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
• D.A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• E.A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• F.A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
• G.A snapshot copy PDB can be created from a stand-alone clone PDB.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about a Recovery Manager (RMAN) duplication without a target connection?

• A.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• B.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
• C.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• D.The undo tablespace clause is always required when no connection exists to the recovery catalog and the target database is closed.
• E.The undo tablespace clause is always required when no connection exists to the target instance.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

• A.By default, the transported database will use Oracle Managed Files (OMF)
• B.Data files can be converted on the destination system.
• C.Data files can be converted on the source system.
• D.A new DBID is automatically created for the transported database.
• E.Databases can be transported between systems with different endian formats.
• F.The password file is automatically converted by RMAN.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?
(Choose two.)

• A.SQL statements doing joins always do more physical I/O than single table queries.
• B.SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
• C.Poorly performing SQL statements can be tuned automatically by the Oracle server.
• D.SQL statements doing only logical reads never require tuning because they do no physical I/O.
• E.The solution that best optimizes one SQL statement can degrade the performance of others.

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?

• A.all backups prior to 22nd of August
• B.all backups prior to 10th of August
• C.all backups prior to 20th of August
• D.all backups prior to 24th of August
• E.all backups prior to 17th of August

Comment: *

Name: *

Email: *

Verification: *