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

• A.It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
• 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 change the access methods used.
• D.It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
• E.It is a set of recommendations by the optimizer to create new indexes.

Comment: *

Name: *

Email: *

Verification: *

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)

• A.Enable asynchronous disk I/O.
• B.Increase the size of the database buffer cache.
• C.Increase the size of tape I/O buffers.
• D.Disable FORCE LOGGING for the database.
• E.Increase the level of RMAN multiplexing.

Comment: *

Name: *

Email: *

Verification: *

For which two requirements can you use the user_tablespaces clause with the create pluggable database command?

• A.to include specific user tablespaces only when relocating a PDB
• B.to specify the list of tablespaces to include when creating a PDB from the CDB seed
• C.to exclude a temp tablespace when plugging in a PDB
• D.to specify a default tablespace in a PDB cloned from another PDB in the same CDB
• E.to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• F.to exclude all tablespaces except system, sysaux, and temp when plugging in a PDB

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle instance recovery? (Choose three.)

• A.Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
• B.Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
• C.Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
• D.Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
• E.Recovery begins from the beginning of the CURRENT redo log group.
• F.Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Comment: *

Name: *

Email: *

Verification: *

Which three are true? (Choose three.)

• A.Application-common TSDP policies are always container specific.
• B.Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
• C.Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
• D.Unified auditing can be automatically synchronized to all application PDBs in an application container.
• E.Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
• F.Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
• G.Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

Comment: *

Name: *

Email: *

Verification: *