Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)A、The ADR base keeps all diagnostic information in binary formatB、SQL*Plus provides the ADRI script, which can be used to work with ADRC、The ADR can be used for problem diagnosis only when the database is openD、The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE、The ADR can be used for problem diagnosis even when the database instance is downF、The ADR base is shared across multiple instances
Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)
- A、The ADR base keeps all diagnostic information in binary format
- B、SQL*Plus provides the ADRI script, which can be used to work with ADR
- C、The ADR can be used for problem diagnosis only when the database is open
- D、The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
- E、The ADR can be used for problem diagnosis even when the database instance is down
- F、The ADR base is shared across multiple instances
相关考题：
Which two statements are true about the Automatic Diagnostic Repository (ADR)?() A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instances
Which two statements regarding a SQL profile are true?() A. It is built by Automatic Tuning Optimizer.B. It cannot be stored persistently in the data dictionary.C. It can be used by the query optimizer automatically.D. It can be created manually by using the CREATE PROFILE command.
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL－related problems?() A. ADR diagnostic filesB. all the optimizer statisticsC. initialization parameter settingsD. PL/SQL functions, procedures, and packagesE. the table and index definitions and actual data
Observe the following warning in an RMAN session of your database instance:WARNING: new failures were found since last LIST FAILURE commandWhich statement describes the scenario that must have produced this warning?（）A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURED. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.) A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instances
Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）A、The ADDM requires at least four AWR snapshots for analysis.B、The ADDM runs after each AWR snapshot is collected automatically by MMON.C、The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.D、The ADDM analysis provides only diagnostic information but does not provide recommendations.E、The ADDM calls other advisors if required， but does not provide recommendations about the advisors.
Which two statements about static NAT are true? （）(Choose two.)A、Static NAT can only be used with destination NAT.B、Static NAT rules take precedence over overlapping dynamic NAT rules.C、NAT rules take precedence over overlapping static NAT rules.D、A reverse mapping is automatically created.
Which two statements are true with regard to policy ordering? （）(Choose two.)A、The last policy is the default policy, which allows all traffic.B、The order of policies is not important.C、New policies are placed at the end of the policy list.D、The insert command can be used to change the order.
Which two statements regarding symmetric key encryption are true?（） (Choose two.)A、The same key is used for encryption and decryption.B、It is commonly used to create digital certificate signatures.C、It uses two keys: one for encryption and a different key for decryption.D、An attacker can decrypt data if the attacker captures the key used for encryption.
Which statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）A、 You can add or remove the trace files to the package.B、 You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.C、 You can add SQL test cases to the incident package.D、 You cannot create an incremental incident package when the physical files are purged rom the ADR.
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） A、 The ADR base keeps all diagnostic information in binary formatB、 SQL*Plus provides the ADRI script， which can be used to work with ADRC、 The ADR can be used for problem diagnosis only when the database is openD、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE、 The ADR can be used for problem diagnosis even when the database instance is downF、 The ADR base is shared across multiple instances
Which two statements are true regarding the SQL Repair Advisor？（） A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems？（） A、 ADR diagnostic filesB、 all the optimizer statisticsC、 initialization parameter settingsD、 PL/SQL functions，procedures，and packagesE、 the table and index definitions and actual data
Which two statements are true about the Automatic Workload Repository （AWR）（）A、All AWR tables belong to the SYSTEM schema.B、The AWR contains systemwide tracing and logging information.C、The snapshots collected by the AWR are accessible through data dictionary views.D、The snapshots collected by the AWR are used by self-tuning components in the database.
Which two statements regarding a SQL profile are true？（）A、 It is built by Automatic Tuning Optimizer.B、 It cannot be stored persistently in the data dictionary.C、 It can be used by the query optimizer automatically.D、 It can be created manually by using the CREATE PROFILE command.
Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository （ADR）？（） A、 The incident metadata is purged when the problem is resolved and the DBA closes the SRB、 The incident files and dumps are not retained in the ADR for the manually created incidents C、 The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SRD、 The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month
Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）A、Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B、All DDL commands are logged in the alert log file.C、All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D、Only DDL commands that resulted in the creation of new segments are logged.E、All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
Which two statements about Automatic Storage Management （ASM） are true？（）A、ASM provides mirroring on file by file basis.B、ASM provides automatic load balancing across all ASM disks.C、ASM supports the Oracle database and operating system files.D、ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.
Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?（）A、The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)B、The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)C、The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURED、The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
Observe the following warning in an RMAN session of your database instance： WARNING:// new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning？（）A、 The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository（ADR）B、 The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR）C、 The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURED、 The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed
多选题Which two statements are true with regard to policy ordering? （）(Choose two.)AThe last policy is the default policy, which allows all traffic.BThe order of policies is not important.CNew policies are placed at the end of the policy list.DThe insert command can be used to change the order.
多选题Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）AThe ADDM requires at least four AWR snapshots for analysis.BThe ADDM runs after each AWR snapshot is collected automatically by MMON.CThe results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.DThe ADDM analysis provides only diagnostic information but does not provide recommendations.EThe ADDM calls other advisors if required， but does not provide recommendations about the advisors.
单选题Observe the following warning in an RMAN session of your database instance： WARNING:// new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning？（）A The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository（ADR）B The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR）C The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURED The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed
多选题Which two statements are true about the Automatic Diagnostic Repository (ADR)?（）AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances
多选题Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances
单选题Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository （ADR）？（）A The incident metadata is purged when the problem is resolved and the DBA closes the SRB The incident files and dumps are not retained in the ADR for the manually created incidents C The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SRD The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month
多选题Which two statements regarding symmetric key encryption are true?（） (Choose two.)AThe same key is used for encryption and decryption.BIt is commonly used to create digital certificate signatures.CIt uses two keys: one for encryption and a different key for decryption.DAn attacker can decrypt data if the attacker captures the key used for encryption.