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

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

Comment: *

Name: *

Email: *

Verification: *

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

• A.The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct
• B.Settingthetargettablespacetoread-only
• C.Setting the target tablespace offline
• D.The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• E.The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Comment: *

Name: *

Email: *

Verification: *

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1, must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

• A.Create an application seed, and install HR_APP in it.
• B.Create the PDB1 application PDB and synchronize it with HR_ROOT.
• C.Create the PDB1 application PDB and synchronize it with PDB$SEED.
• D.Create the PDB1 application PDB and install HR_APP in it.
• E.Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.

Comment: *

Name: *

Email: *

Verification: *

Choose three. You issued this command: RMAN> BACKUP RECOVERY AREA FORCE; Which three are true?

• A.All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
• B.All files in any previous FRA that have not yet been backed up, are backed up.
• C.All Oracle recovery files normally written to the FRA and which have not yet been backed, are backed up.
• D.All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up. C)All files in the current FRA that have been backed up already, are backed up.
• E.All files in any previous FRA that have been backed up already, are backed up.
• F.All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.

Comment: *

Name: *

Email: *

Verification: *

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

• A.It creates a file that contains RMAN scripts to create a duplicate database.
• B.It updates the alert log with the location and contents of the control file
• C.It creates a copy of the control file in the fast recovery area (FRA).
• D.It creates a file that contains SQL statements to re-create the control file.
• E.It creates a binary backup of the control file.

Comment: *

Name: *

Email: *

Verification: *