多选题Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）AEnterprise Manager GUIBDBMS_TRACE package APIsCDBMS_ADVISOR package APIsDDBMS_MONITOR package APIsE$ORACLE_HOME/rdbms/admin/addmrpt.sql script
多选题
Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）
A
Enterprise Manager GUI
B
DBMS_TRACE package APIs
C
DBMS_ADVISOR package APIs
D
DBMS_MONITOR package APIs
E
$ORACLE_HOME/rdbms/admin/addmrpt.sql script
参考解析
解析：
暂无解析
相关考题：
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this?（）A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task.
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?A．Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.B．Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.C．Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system accountD．Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
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 three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）A、 Enterprise Manager GUIB、 DBMS_TRACE package APIsC、 DBMS_ADVISOR package APIsD、 DBMS_MONITOR package APIsE、 $ORACLE_HOME/rdbms/admin/addmrpt.sql script
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.
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）A、Create two custom ADDM tasks.B、Modify the AWR snapshot time interval to two hours.C、Create a new scheduler window for a time period of two hours.D、Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）A、 Recovery catalogB、 Oracle Enterprise Manager RepositoryC、 Automatic Workload Repository （AWR）D、 Oracle 10g Enterprise Manager Grid ControlE、 Automatic Database Diagnostic Monitor （ADDM）
You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） A、Memory AdvisorB、Segment AdvisorC、SQL Tuning AdvisorD、SQL Access AdvisorE、Automatic Database Diagnostic Monitor （ADDM）
You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）A、 Memory AdvisorB、 Segment AdvisorC、 SQL Access AdvisorD、 Automatic Workload Repository （AWR）E、 Automatic Database Diagnostic Monitor （ADDM）
You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）A、use enterprise managerB、use DBMS_SQL packageC、use DBMS_AWR packageD、use PRVT_WORKLOAD packageE、query the AWR snapshot repository objectsF、use DBMS_WORKLOAD_REPOSITORY package
You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）A、Enable Memory Access Mode, which reads performance data from SGA.B、Use emergency monitoring to fetch data directly from SGA analysis.C、Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.D、Use Active Session History (ASH) data and hang analysis in regular performance monitoring.E、Run ADDM in diagnostic mode.
In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend analysis and capacity planning of the database. Which component stores these statistics？（）A、recovery catalogB、Oracle Enterprise Manager RepositoryC、Automatic Workload Repository （AWR）D、Oracle 10g Enterprise Manager Grid ControlE、Automatic Database Diagnostic Monitor （ADDM）
You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）A、run Segment AdvisorB、run SQL Tuning Advisor on top SQL statementsC、run the Automatic Workload Repository （AWR） reportD、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
You create a new Automatic Database Diagnostic Monitor （ADDM） task： instance_analysis_mode_task. To view the ADDM report， you use the following command： SQL SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual； You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments. What would you do to achieve this？（）A、 Add a finding directive for the ADDM task.B、 Add a segment directive for the ADDM task.C、 Add a parameter directive for the ADDM task.D、 Disable the Segment Advisor from the Automatic Maintenance Task.
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） A、 Generate reports on data failure such as data file failures.B、 You can track the Service Request （SR） and implement repairs.C、 You can package and upload diagnostic data to Oracle Support.D、 You can manually run health checks to gather diagnostic data for a problem.
You run a 16-bit scientific data analysis package on your Windows 2000 Professional computer. The package consists of three components. The first component is a data acquisition application that monitors continuous data output from scientific instruments. The second component is a data analysis application that receives data from the data acquisition application by using shared memory. The third component is a data graphing application that displays the processed data in real time. The data analysis application communicates with the data graphing application by using OLE. When you attempt to analyze large data sets, your computer is not able to display data in real time. You install a second processor in your computer; only one processor is used while the package is running, even though task manager shows both processors. You want your data analysis package to use both processors. What should you do?（）A、Configure the data acquisition application to run in its own virtual DOS machine (VDM).B、Configure the data analysis application to run in its own virtual DOS machine (VDM).C、Configure the data graphing application to run in its own virtual DOS machine (VDM).D、Configure the virtual DOS machine for the data acquisition and data analysis applications to.have a hard affinity for processor 0. Configure the VDM for the data graphing application to.have a hard affinity for processor1. E、Configure the virtual DOS machine for the data acquisition to have a hard affinity for processor 0. Configure the VDM for the data graphing application to have a hard affinity for processor1.
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized？（）A、The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.B、The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.C、The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.D、The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.
多选题Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）AYou can add SQL test cases to the incident package.BYou can add or remove the trace files to the package.CYou cannot create an incremental incident package when the physical files are purged from the ADR.DYou can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.
多选题Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（）AGenerate reports on data failure such as data file failures.BYou can track the Service Request （SR） and implement repairs.CYou can package and upload diagnostic data to Oracle Support.DYou can manually run health checks to gather diagnostic data for a problem.
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）ADBMS_STATS BDBMS_ALERT CDBMS_SPACE DDBMS_MONITOR EDBMS_SERVER_ALERTFDBMS_SPACE_ADMIN
多选题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.
单选题You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）A Memory AdvisorB Segment AdvisorC SQL Tuning AdvisorD SQL Access AdvisorE Automatic Database Diagnostic Monitor （ADDM）
多选题You run a 16-bit scientific data analysis package on your Windows 2000 Professional computer. The package consists of three components. The first component is a data acquisition application that monitors continuous data output from scientific instruments. The second component is a data analysis application that receives data from the data acquisition application by using shared memory. The third component is a data graphing application that displays the processed data in real time. The data analysis application communicates with the data graphing application by using OLE. When you attempt to analyze large data sets, your computer is not able to display data in real time. You install a second processor in your computer; only one processor is used while the package is running, even though task manager shows both processors. You want your data analysis package to use both processors. What should you do?（）AConfigure the data acquisition application to run in its own virtual DOS machine (VDM).BConfigure the data analysis application to run in its own virtual DOS machine (VDM).CConfigure the data graphing application to run in its own virtual DOS machine (VDM).DConfigure the virtual DOS machine for the data acquisition and data analysis applications to.have a hard affinity for processor 0. Configure the VDM for the data graphing application to.have a hard affinity for processor1.EConfigure the virtual DOS machine for the data acquisition to have a hard affinity for processor 0. Configure the VDM for the data graphing application to have a hard affinity for processor1.
单选题You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）AMemory AdvisorBSegment AdvisorCSQL Tuning AdvisorDSQL Access AdvisorEAutomatic Database Diagnostic Monitor （ADDM）
单选题The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do？（）A Create two custom ADDM tasks.B Modify the AWR snapshot time interval to two hours.C Create a new scheduler window for a time period of two hours.D Modify the Automatic Workload Repository （AWR） snapshot retention period to two hours.
单选题You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）AEnable Memory Access Mode, which reads performance data from SGA.BUse emergency monitoring to fetch data directly from SGA analysis.CRun Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.DUse Active Session History (ASH) data and hang analysis in regular performance monitoring.ERun ADDM in diagnostic mode.
多选题You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）Ause enterprise managerBuse DBMS_SQL packageCuse DBMS_AWR packageDuse PRVT_WORKLOAD packageEquery the AWR snapshot repository objectsFuse DBMS_WORKLOAD_REPOSITORY package