11gocmu 무료 덤프문제 온라인 액세스

Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

• A.The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
• B.Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
• C.No special setup is required, and the feature is enabled by default.
• D.The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
• E.The database must be running in ARCHIVELOG mode.

You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose all that apply.)

• A.The source database must be shut down cleanly if the database is in mounted state.
• B.A net service name should be set up and a listener configured with the target as well as the source database.
• C.The source database must be run in ARCHIVELOG mode if the database is open.
• D.The source database backup must be copied over the net for test database.

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)

• A.Only the changes in the execution plan, and not performance regression, are detected.
• B.It automatically calls the SQL Tuning Advisor for recommendations.
• C.It produces less accurate results of the comparison analysis.
• D.It shortens the time of execution and reduces the impact on system resources.

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

• A.Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
• B.Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
• C.Use Data Pump to transfer the existing data to a new encrypted tablespace.
• D.Use ALTER TABLE. MOVE to transfer the existing data to a new encrypted tablespace.
• E.Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.

Which of the following is not a configurable attribute for an individual disk group?

• A.COMPATIBLE.RDBMS
• B.COMPATIBLE.ASM
• C.DISK_REPAIR_TIME
• D.DG_DROP_TIME
• E.AU_SIZE