CMS专题

单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You wou

题目
单选题
From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users.   Which method would you use to achieve this objective？（）
A

create a plan directive in the SYS_GROUP

B

create the pending area for the consumer group

C

activate the provided SYSTEM_PLAN in Resource Manager

D

set the TIMED_STATISTICS parameter to TRUE in the parameter file

E

set the execution time limit for all users， except SYS and SYSTEM， in their profiles

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）

  • A、 By using the trace file.
  • B、 By using the alert log file.
  • C、 By using the database ID
  • D、 By using the server parameter file.
  • E、 By using the V$CONTROLFILE view.
  • F、 By using the autobackup format configuration setting.

正确答案:C,F

第2题：

In what view are you likely to see the following output？（）   SID SERIAL# EVENT SECONDS_IN_WAIT  121 269 RMAN backup & recovery I/O 2  129 415 SQL*Net message from client 63 130 270 SQL*Net message from client  

  • A、 V$SESSION_EVENT
  • B、 V$SESSION
  • C、 V$WAITS
  • D、 V$WAITSTAT
  • E、 V$SYSSTAT

正确答案:B

第3题：

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.


参考答案：C

第4题：

If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）

  • A、 recover lost blocks
  • B、 recover corrupt blocks
  • C、 recover media corrupt blocks from list
  • D、 recover corrupt blocks from list
  • E、 recover corruption list

正确答案:E

第5题：

You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

  • A、 Query the V$FLASHBACK_DATABASE_LOG view.
  • B、 Query the V$FLASHBACK_DATABASE_STAT view.
  • C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
  • D、 Query the V$RECOVERY_FILE_DEST view.

正确答案:B

第6题：

What view might you use to try to determine how long a particular backup will take?（）

  • A、V$SESSION_EVENT 
  • B、V$SESSION 
  • C、V$W0041ITS
  • D、V$WAITSTAT 
  • E、V$SESSION_LONGOPS 

正确答案:E

第7题：

You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）

  • A、 DBA_SCHEDULER_JOB_RUN_DETAILS
  • B、 DBA_SCHEDULER_RUNNING_JOBS
  • C、 DBA_SCHEDULER_JOBS
  • D、 DBA_SCHEDULER_JOB_LOG

正确答案:C

第8题：

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.

正确答案:C

第9题：

What view might you use to try to determine how long a particular backup will take？（）  

  • A、 V$SESSION_EVENT
  • B、 V$SESSION
  • C、 V$WAITS
  • D、 V$WAITSTAT
  • E、 V$SESSION_LONGOPS

正确答案:E

第10题：

Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data.  Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（　） function. This view does not allow you to create an index. You need to create an index on the view.  Which two actions should you perform?（）

  • A、 Remove all deterministic function calls from within the view. 
  • B、 Remove all nondeterministic function calls from within the view. 
  • C、 Schema-bind all functions that are called from within the view. 
  • D、 Create the view and specify the WITH CHECK OPTION clause.

正确答案:B,C

更多相关问题
相关内容