单选题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 

题目
单选题
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

相似考题

1.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

2.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.

3. 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

4. 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

更多“单选题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 ”相关问题

  • 第1题：

    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

    正确答案:C

  • 第2题：

    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 CPU levels for the users’ group using Resource Manager
    • D、set the TIMED_STATISTICS parameter to TRUE in the parameter file

    正确答案:C

  • 第3题：

    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$DATABASE
    • B、 V$UNDOSTAT
    • C、 V$FLASHBACK_DATABASE_LOG
    • D、 V$FLASHBACK_DATABASE_STAT

    正确答案:C

  • 第4题：

    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

    正确答案:D

  • 第5题：

    单选题
    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)


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    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 Advisor

    B

    run SQL Tuning Advisor on top SQL statements

    C

    run the Automatic Workload Repository （AWR） report

    D

    run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    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

     REBUILD

    B

     CASCADE

    C

     TRUNCATE

    D

     ROW MOVEMENT

    E

     SHRINK SPACE COMPACT

    F

     SHRINK SPACE CASCADE


    正确答案： B
    解析： 暂无解析

  • 第8题：

    多选题
    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.


    正确答案： E,C
    解析： 暂无解析

  • 第9题：

    单选题
    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 profile

    B

    set the CPU time per session in the users profiles

    C

    set the CPU levels for the users’ group using Resource Manager

    D

    set the TIMED_STATISTICS parameter to TRUE in the parameter file


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    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$DATABASE

    B

     V$UNDOSTAT

    C

     V$FLASHBACK_DATABASE_LOG

    D

     V$FLASHBACK_DATABASE_STAT


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    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

    REBUILD

    B

    CASCADE

    C

    TRUNCATE

    D

    ROW MOVEMENT

    E

    SHRINK SPACE COMPACT

    F

    SHRINK SPACE CASCADE


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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_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

    正确答案:C

  • 第14题：

    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.

    正确答案:A,D

  • 第15题：

    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.

    正确答案:B

  • 第16题：

    单选题
    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_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


    正确答案： E
    解析： 暂无解析

  • 第17题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第18题：

    单选题
    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$DATABASE

    B

     V$FLASHBACK_DATABASE_STAT

    C

     V$FLASHBACK_DATABASE_LOG

    D

     V$RECOVERY_FILE_DEST


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    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 pool

    B

    Large pool

    C

    Shared pool

    D

    Streams pool

    E

    Library cache

    F

    Redo log buffer

    G

    Data dictionary cache

    H

    Database buffer cache


    正确答案： G
    解析： 暂无解析

  • 第24题：

    单选题
    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 file

    B

    grant SINGLE SESSION privilege to all of the users

    C

    set the SESSIONS_PER_USER to 1 in the users’ profile

    D

    grant RESTRICTED SESSION privilege to all of the database users

    E

    create a role with SINGLE SESSION privilege and assign the role to the users


    正确答案： A
    解析： 暂无解析

相关内容