网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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？（）
A
set the CPU time per call in the users profile
B
set the CPU time per session in the users profiles
C
set the TIMED_STATISTICS parameter to TRUE in the parameter file
D
set the CPU levels for the users’ group using Resource Manager
参考答案
参考解析
解析：
暂无解析
更多 “单选题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？（）A set the CPU time per call in the users profileB set the CPU time per session in the users profilesC set the TIMED_STATISTICS parameter to TRUE in the parameter fileD set the CPU levels for the users’ group using Resource Manager” 相关考题
考题
You are having problems with connections from a specific host (192.168.1.15) not closing down correctly.You want to find the state of the threads from that host check for long-running queries. Which statement will accomplish this?（）A.AB.BC.CD.D
考题
From the V$SESSION_LONGOPS view， you find that some of the database users have long/x7frunning 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 profileB、set the CPU time per session in the users profilesC、set the CPU levels for the users’ group using Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter file
考题
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.
考题
In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A、REBUILDB、CASCADEC、TRUNCATED、ROW MOVEMENTE、SHRINK SPACE COMPACTF、SHRINK SPACE CASCADE
考题
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_GROUPB、create the pending area for the consumer groupC、activate the provided SYSTEM_PLAN in Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter fileE、set 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/x7frunning 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_GROUPB、create the pending area for the consumer groupC、activate the provided SYSTEM_PLAN in Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter fileE、set 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 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 profileB、set the CPU time per session in the users profilesC、set the CPU levels for the users’ group using Resource ManagerD、set the TIMED_STATISTICS parameter to TRUE in the parameter file
考题
You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?（）A、It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.B、It contains username and passwords of database users who are members of the OSOPER operating system group.C、It contains usernames and passwords of database users who are members of the OSDBA operating system group.D、It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.E、It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
考题
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
考题
You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）A、Use the DBCC INPUTBUFFER command.B、Use the sys.dm_exec_query_stats dynamic management view （DMV）.C、Use the sqldiag utility.D、Use the SHOWPLAN session option.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time. So in the options below, which dynamic management view should you choose to use?（） A、sys.dm_os_wait_stats B、sys.dm_exec_requests C、sys.dm_exec_sessions D、sys.dm_exec_query_stats
考题
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long/x7frunning 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_GROUPB
create the pending area for the consumer groupC
activate the provided SYSTEM_PLAN in Resource ManagerD
set the TIMED_STATISTICS parameter to TRUE in the parameter fileE
set the execution time limit for all users， except SYS and SYSTEM， in their profiles
考题
单选题You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）A
Segment Advisor B
SQL Tuning Advisor C
SQL Access Advisor D
Segment Resource Estimation E
Automatic Database Diagnostic Monitor (ADDM)
考题
单选题You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）A
Use the DBCC INPUTBUFFER command.B
Use the sys.dm_exec_query_stats dynamic management view （DMV）.C
Use the sqldiag utility.D
Use the SHOWPLAN session option.
考题
单选题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 are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）A
V$DATABASEB
V$FLASHBACK_DATABASE_STATC
V$FLASHBACK_DATABASE_LOGD
V$RECOVERY_FILE_DEST
考题
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A
REBUILDB
CASCADEC
TRUNCATED
ROW MOVEMENTE
SHRINK SPACE COMPACTF
SHRINK SPACE CASCADE
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. For some reason, now the company wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number. Which performance object should you capture?（）A
SQLServer:Buffer Manager B
SQLServer:Access Methods C
SQLServer:General Statistics D
SQLServer:Exec Statistics
考题
多选题You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?（）AIt will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.BIt contains username and passwords of database users who are members of the OSOPER operating system group.CIt contains usernames and passwords of database users who are members of the OSDBA operating system group.DIt will permit the use of lowercase passwords for database users who have granted the SYSDBA role.EIt will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
考题
单选题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_GROUPB
create the pending area for the consumer groupC
activate the provided SYSTEM_PLAN in Resource ManagerD
set the TIMED_STATISTICS parameter to TRUE in the parameter fileE
set 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/x7frunning 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 profileB
set the CPU time per session in the users profilesC
set the CPU levels for the users’ group using Resource ManagerD
set the TIMED_STATISTICS parameter to TRUE in the parameter file
考题
单选题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.
考题
单选题Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）A
V$DATABASEB
V$UNDOSTATC
V$FLASHBACK_DATABASE_LOGD
V$FLASHBACK_DATABASE_STAT
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time. So in the options below, which dynamic management view should you choose to use?（）A
sys.dm_os_wait_stats B
sys.dm_exec_requests C
sys.dm_exec_sessions D
sys.dm_exec_query_stats
考题
单选题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？（）A
set the CPU time per call in the users profileB
set the CPU time per session in the users profilesC
set the TIMED_STATISTICS parameter to TRUE in the parameter fileD
set the CPU levels for the users’ group using Resource Manager
考题
单选题Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）A
Java poolB
Large poolC
Shared poolD
Streams poolE
Library cacheF
Redo log bufferG
Data dictionary cacheH
Database buffer cache
考题
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A
REBUILDB
CASCADEC
TRUNCATED
ROW MOVEMENTE
SHRINK SPACE COMPACTF
SHRINK SPACE CASCADE
考题
单选题The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）A
set the SESSIONS to 1 in the parameter fileB
grant SINGLE SESSION privilege to all of the usersC
set the SESSIONS_PER_USER to 1 in the users’ profileD
grant RESTRICTED SESSION privilege to all of the database usersE
create a role with SINGLE SESSION privilege and assign the role to the users
热门标签
最新试卷
