网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（）
A
General
B
High Availability
C
Space Usage
D
Diagnostic Summary
参考答案
参考解析
解析：
暂无解析
更多 “单选题While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（）A GeneralB High AvailabilityC Space UsageD Diagnostic Summary” 相关考题
考题
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
考题
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?()
A. Allocates memory for RMAN backup and restore operationsB. Allocates memory for shared and private SQL areasC. Contains a cursor area for storing runtime information about cursorsD. Contains stack spaceE. Contains a hash area performing hash joins of tables
考题
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A、 The EVENT parameter was not setB、 The SQL_TRACE parameter is set to FALSEC、 The Enterprise Manager Grid Control is not usedD、 The STATISTICS_LEVEL parameter is set to BASICE、 The TIMED_STATISTICS parameter is set to FALSE
考题
Which of the following tasks does the tool Incident Packaging Service （IPS） perform？（） A、 Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.B、 Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.C、 Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.D、 Displays a high-level view of critical errors on the database home page.
考题
Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）A、JournalB、Task CenterC、Control CenterD、Activity Monitor
考题
You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
考题
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）A、Execute the query and view Active Session History (ASH) for information about the query.B、Enable SQL trace for the query.C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
考题
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A、The EVENT parameter was not set.B、The SQL_TRACE parameter is set to FALSEC、The Enterprise Manager Grid Control is not used.D、The STATISTICS_LEVEL parameter is set to BASICE、The TIMED_STATISTICS parameter is set to FALSE
考题
Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）A、Allocates memory for RMAN backup and restore operationsB、Allocates memory for shared and private SQL areasC、Contains a cursor area for storing runtime information about cursorsD、Contains stack spaceE、Contains a hash area performing hash joins of tables
考题
You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A、enable index monitoring and query the DBA_OBJECTS viewB、enable index monitoring and query the DBA_INDEXES viewC、enable index monitoring and query the V$OBJECT_USAGE viewD、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A、Information about each Oracle Net connection.B、Information about each entry in theLinstener.orafileC、Information about the changed done in the databaseD、Information about the different listeners in your systemE、Information about all thenondatabasefiles required to operate the database
考题
You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system （OS） file.D、It is a Recovery Manager （RMAN） script
考题
You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）A、 redo log filesB、 password fileC、 control fileD、 change tracking file
考题
You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）A、 No warning level or critical level alert will be generated.B、 A warning level alert will never be generated， but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used.C、 A critical level alert will never be generated， but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used.D、 A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace， and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.
考题
Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）A、V$DATAFILEB、V$TEMPFILEC、V$DBFILED、V$DATAFILE_HEADER
考题
Which two statements about creating constraints are true?（）A、Constraint names must start with SYS_CB、All constraints must be defines at the column level.C、Constraints can be created after the table is created.D、Constraints can be created at the same time the table is created.E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.
考题
单选题A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）A
Execute the query and view Active Session History (ASH) for information about the query.B
Enable SQL trace for the query.C
Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D
Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
考题
单选题You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）A
No warning level or critical level alert will be generated.B
A warning level alert will never be generated， but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used.C
A critical level alert will never be generated， but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used.D
A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace， and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.
考题
单选题While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（）A
GeneralB
High AvailabilityC
Space UsageD
Diagnostic Summary
考题
单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A
The EVENT parameter was not setB
The SQL_TRACE parameter is set to FALSEC
The Enterprise Manager Grid Control is not usedD
The STATISTICS_LEVEL parameter is set to BASICE
The TIMED_STATISTICS parameter is set to FALSE
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
单选题Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）A
JournalB
Task CenterC
Control CenterD
Activity Monitor
考题
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）A
Oracle Enterprise ManagerB
The V$LOG viewC
The V$LOGFILE viewD
The V$FLASHBACK_DATABASE_LOGS view
考题
单选题Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）A
V$DATAFILEB
V$TEMPFILEC
V$DBFILED
V$DATAFILE_HEADER
考题
单选题Which of the following tasks does the tool Incident Packaging Service （IPS） perform？（）A
Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.B
Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.C
Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.D
Displays a high-level view of critical errors on the database home page.
考题
单选题You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）A
redo log filesB
password fileC
control fileD
change tracking file
考题
单选题You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A
Information about each Oracle Net connection.B
Information about each entry in theLinstener.orafileC
Information about the changed done in the databaseD
Information about the different listeners in your systemE
Information about all thenondatabasefiles required to operate the database
考题
多选题Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）AAllocates memory for RMAN backup and restore operationsBAllocates memory for shared and private SQL areasCContains a cursor area for storing runtime information about cursorsDContains stack spaceEContains a hash area performing hash joins of tables
热门标签
最新试卷