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 20th of August
• B.all backups prior to 22nd of August
• C.all backups prior to 24th of August
• D.all backups prior to 10th of August
• E.all backups prior to 17th of August

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
CDB1 is a container database.
PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.PDB1 and PDB2 are in MOUNT state.
• B.PDB1 and PDB2 are in READ ONLY state.
• C.PDB$SEED is in READ ONLY state.
• D.Redo logs are opened.
• E.CDB$ROOT is in MOUNT state.

Comment: *

Name: *

Email: *

Verification: *

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The local_undo_enabled database property is set to false in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the backup database command while connected to CDB$ROOT.
Which three are true?

• A.Data file 24 can be restored only while connected to CDB$ROOT.
• B.Data file 24 can be restored only while connected to PDB2.
• C.Data file 24 can be recovered only while connected to PDB2.
• D.Data file 24 can be recovered while connected to PDB2.
• E.Data file 24 can be recovered while connected to CDB$ROOT.
• F.Data file 24 can be restored and recovered while connected to CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
$ rhpctl move database -sourcehorae Oracle_horne_path -destinationhome Oracle_home_path For which two purposes can you use this command?

• A.to switch to a read-only Oracle home
• B.to switch to a patched Oracle Database home
• C.to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
• D.to switch back to the previous Oracle home as part of a rollback operation
• E.to switch an existing Oracle Database home to a newer release of Oracle software on the same server

Comment: *

Name: *

Email: *

Verification: *