Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?

• A.the physical data model
• B.using check constraints to speed up updates
• C.defining primary keys for all tables to speed up all queries
• D.the configuration of storage arrays
• E.defining foreign keys for all tables to speed up joins

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:

While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted.
To recover from this critical failure, you execute these commands:

What will be the outcome?

• A.It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
• B.It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
• C.It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
• D.It will fail because there is no autobackup of the controlfiles.
• E.It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

Comment: *

Name: *

Email: *

Verification: *

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

• A.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• C.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• D.Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• E.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• F.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Comment: *

Name: *

Email: *

Verification: *

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

• A.It is a set of recommendations by the optimizer to create new indexes.
• B.It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
• C.It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
• D.It is a set of recommendations by the optimizer to change the access methods used.
• E.It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.

Comment: *

Name: *

Email: *

Verification: *

Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

• A.Set only the PDB_FILE_NAME_CONVERT parameter.
• B.Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• C.Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
• D.Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)
• E.Addonly the CREATE_FILE_DEST clause to the statement.
• F.Enable only OMF.

Comment: *

Name: *

Email: *

Verification: *