单选题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？（）Acreate a plan directive in the SYS_GROUPBcreate the pending area for the consumer groupCactivate the provided SYSTEM_PLAN in Resource ManagerDset the TIMED_STATISTICS parameter to TRUE in the parameter fileEset the execution time limit for all users， except SYS and SYSTEM， in their profiles
单选题
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
参考解析
解析：
暂无解析
相关考题：
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.
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 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 IDD、 By using the server parameter file.E、 By using the V$CONTROLFILE view.F、 By using the autobackup format configuration setting.
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$W0041ITSD、V$WAITSTAT E、V$SESSION_LONGOPS
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_EVENTB、 V$SESSIONC、 V$WAITSD、 V$WAITSTATE、 V$SYSSTAT
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_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
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.
What view might you use to try to determine how long a particular backup will take？（） A、 V$SESSION_EVENTB、 V$SESSIONC、 V$WAITSD、 V$WAITSTATE、 V$SESSION_LONGOPS
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 blocksB、 recover corrupt blocksC、 recover media corrupt blocks from listD、 recover corrupt blocks from listE、 recover corruption list
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.
TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s 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.
You have an Exchange Server 2010 organization.You need to view the replication status of a mailbox database copy.What should you do？（）A、From the Exchange Management Shell， run the Test-ServiceHealth cmdlet.B、From the Exchange Management Shell， run the Get-DatabaseAvailabilityGroup cmdlet.C、From the Exchange Management Console （EMC）， view the properties of the database copy.D、From the Exchange Management Console （EMC）， view the properties of the Mailbox server.
You manage a member server that runs Windows Server 2008. The server runs the Terminal Server Gateway （TS Gateway） role service. You need to find out whether a user named User1 has ever connected to his office workstation through the TS Gateway server. What should you do？（）A、View the events in the Monitoring folder from the TS Gateway Manager console.B、View the Event Viewer Security log.C、View the Event Viewer Application log.D、View the Event Viewer Terminal Services-Gateway log.
多选题Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）AYou can find information about only active transactions from the viewBYou can find information about read only transactions from the viewCYou require the SELECT ANY TRANSACTION system privilege to access the viewDYou can find information about both active and committed transactions from the viewEYou require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view
单选题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_DETAILSB DBA_SCHEDULER_RUNNING_JOBSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG
单选题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?（）AExecute the query and view Active Session History (ASH) for information about the query.BEnable SQL trace for the query.CCreate a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.DUse the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
多选题TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s 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？（）ARemove all deterministic function calls from within the view.BRemove all nondeterministic function calls from within the view.CSchema-bind all functions that are called from within the view.DCreate the view and specify the WITH CHECK OPTION clause.
单选题What view might you use to try to determine how long a particular backup will take？（）A V$SESSION_EVENTB V$SESSIONC V$WAITSD V$WAITSTATE V$SESSION_LONGOPS
单选题For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A Set the CPU time per call in the users profile.B Set the CPU time per session in the users profile.C Set the CPU levels for the user’s group using Resource Manager.D Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
多选题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?（）ARemove all deterministic function calls from within the view.BRemove all nondeterministic function calls from within the view.CSchema-bind all functions that are called from within the view.DCreate the view and specify the WITH CHECK OPTION clause.
单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
单选题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？（）Aenable index monitoring and query the DBA_OBJECTS viewBenable index monitoring and query the DBA_INDEXES viewCenable index monitoring and query the V$OBJECT_USAGE viewDenable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
单选题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 blocksB recover corrupt blocksC recover media corrupt blocks from listD recover corrupt blocks from listE recover corruption list
单选题What view might you use to try to determine how long a particular backup will take?（）AV$SESSION_EVENT BV$SESSION CV$W0041ITSDV$WAITSTAT EV$SESSION_LONGOPS
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）Aset the CPU time per call in the users profileBset the CPU time per session in the users profilesCset the CPU levels for the users’ group using Resource ManagerDset the TIMED_STATISTICS parameter to TRUE in the parameter file
单选题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 clientA V$SESSION_EVENTB V$SESSIONC V$WAITSD V$WAITSTATE V$SYSSTAT
单选题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.