1Z1-182 試験問題を無料オンラインアクセス

Which of the following is true about the status of a PDB that has been unplugged from a CDB?

• A.The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.
• B.The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.
• C.The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.
• D.The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.

What are Oracle Database Metrics?

• A.Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.
• B.Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.
• C.Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.
• D.Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.
• E.Oracle Database Metrics monitor performance using thresholds to generate alerts.

Which advisor is used to detect missing or stale object statistics?

• A.SQL Access Advisor
• B.SQL Performance Analyzer
• C.SQL Statistics Advisor
• D.SQL Tuning Advisor

Which three statements are true about Deferred Segment Creation in Oracle databases?

• A.It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
• B.Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.
• C.Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table.
• D.It is the default behavior for tables and indexes.
• E.It is supported for SYS-owned tables contained in locally managed tablespaces.

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.Online table segment shrink.
• D.Oracle Managed Files (OMF).
• E.Automatic data file extension (AUTOEXTEND).