1Z0-182 무료 덤프문제 온라인 액세스

Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?

• A.The Automatic SQL Plan Management Evolve Advisor task, which evolves plans that have recently been added as the SQL plan baseline for statements.
• B.The Automatic SQL Performance Analyzer task, which is used to provide details about impact of database changes to application SQL batch.
• C.The Automatic Index Advisor task, which is used to create and maintain table indexes based on the DML load and operations.
• D.The Automatic SQL Tuning Advisor tasks, which would examine the performance of high-load SQL statements and make recommendations for those statements.
• E.The Automatic SQL Access Advisor task, which is used to manage an application SQL load.

Which statement regarding PDBs (Pluggable Databases) is correct?

• A.You cannot drop a source PDB of a refreshable PDB.
• B.You can drop a PDB as long as it is not the PDB seed.
• C.You can drop an application root along with the associated PDBs.
• D.When the relocation of a PDB is finished, the source PDB must be dropped.

Which two statements are true about the configuration and use of UNDO?

• A.Unexpired UNDO is always retained.
• B.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.
• C.Active UNDO is always retained.
• D.UNDO_RETENTION specifies how long all types of UNDO are retained.
• E.UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?

• A.ALTER SYSTEM FLUSH BUFFER_CACHE
• B.ALTER SYSTEM SWITCH LOGFILE
• C.ALTER SYSTEM CHECKPOINT
• D.ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?

• A.Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).
• B.Online index segment shrink.
• C.Automatic data file extension (AUTOEXTEND).
• D.Oracle Managed Files (OMF).
• E.Online table segment shrink.