The database must be running in ARCHIVELOG mode.
No special setup is required, and the feature is enabled by default.
The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
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.
第1题:
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?()
第2题:
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?()
第3题:
Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g?()
第4题:
You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups()
第5题:
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()
第6题:
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g?()
第7题:
The source database backup must be copied over the net for test database.
The source database must be run in ARCHIVELOG mode if the database is open.
The source database must be shut down cleanly if the database is in mounted state.
A net service name should be set up and a listener configured with the target as well as the source database.
第8题:
setting the STATISTICS_LEVEL parameter to TYPICAL
adding filters to the Automatic Database Diagnostic Monitor (ADDM)
enabling Automated Maintenance Task using Oracle Enterprise Manager
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
第9题:
The database must be running in ARCHIVELOG mode.
No special setup is required, and the feature is enabled by default.
The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
The Enterprise Manager Support Workbench can be enabled only if the background process manage ability monitor (MMON) is configured.
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.
第10题:
The database must be running in ARCHIVELOG mode.
No special setup is required, and the feature is enabled by default.
The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
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.
第11题:
Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).
The problem key is the same as the incident number.
The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
Every problem has a problem key, which is a text string that describes the problem.
The database makes an entry into the alert log file when problems and incidents occur.
第12题:
It must be executed from the Oracle Database 11g environment.
It must be executed only after the SYSAUX tablespace has been created.
It must be executed from the environment of the database that is being upgraded.
It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
第13题:
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?()
第14题:
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
第15题:
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?()
第16题:
Which setting enables the baselines by default in Oracle Database 11g?()
第17题:
Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?()
第18题:
You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements are true about these backups()
第19题:
View long-running SQL workloads
View problem details
Gather additional diagnostic information
Create a Service Request
Clean up incident data after upload to Oracle Support
第20题:
The database must be in read-write mode.
The database must have no external files.
The database must open in read-only mode.
The database must be mounted but not opened.
第21题:
The backups would be consistent.
The backups would be inconsistent.
The backups would be possible only if the database is running in ARCHIVELOG mode.
The backups would be possible only if the database is running in NOARCHIVELOG mode.
The backups need to be restored and the database has to be recovered in case of a media failure.
第22题:
Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.
Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.
Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.
Displays a high-level view of critical errors on the database home page.
第23题:
The backup will consist of used data blocks only.
The database must be shut down to accomplish the backup.
The backup can be accomplished without shutting down the database.
The backup will contain all database files that have never been backed up.
第24题:
It must be executed from the Oracle Database 11g environment.
It must be executed only after the SYSAUX tablespace has been created.
It must be executed from the environment of the database that is being upgraded.
It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.