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

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

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

Which three statements are true about dynamic performance views?

• A.They are owned by the SYSTEM user.
• B.They can be queried only when the database is open.
• C.Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.
• D.Read consistency is not guaranteed.
• E.V$FIXED_TABLE can be queried to display the names of all dynamic performance views.

Which three statements are true about resumable space allocation in Oracle databases?

• A.All sessions must have the same timeout value when waiting for resumable space allocations.
• B.A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.
• C.Resumable space allocation is only possible with locally managed tablespaces.
• D.Resumable space allocation may be enabled for some sessions and not others.
• E.A user's session may be suspended and resumed multiple times.
• F.The AFTER SUSPEND event trigger can itself be suspended due to space conditions.

You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?

• A.From the PDB, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfile$;
• B.From the CDB root, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
• C.From the PDB, execute SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$parameter;
• D.From the CDB root, execute SELECT db_uniq_name, pdb_uid, name, value$ FROM pdb_spfiles;

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.It is supported for SYS-owned tables contained in locally managed tablespaces.
• 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.Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.