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

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

相似考题

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

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. When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）A、audit trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer

4.In which scenario do you use the Flashback Database feature？（）A、 when a table is dropped and you restore it from the Recycle BinB、 when a user’s schema is dropped and you recover the user’s schemaC、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

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

  • 第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/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

  • 第3题：

    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

    • A、the time when the last flashback operation in your database was performed
    • B、the time when the first flashback operation in your database was performed
    • C、a list of flashback operations performed in your database using SCN and time
    • D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

    正确答案:D

  • 第4题：

    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

  • 第5题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）

    • A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.
    • B、In a query execution plan， you should look for queries with missing or out-of-date statistics.
    • C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.
    • D、In a query execution plan， you should look for queries with a large number of table scans.

    正确答案:C

  • 第6题：

    单选题
    A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work.  ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）
    A

    Modify the profile assigned to the user.

    B

    Modify the roles assigned to the users.

    C

    Modify the object privileges assigned to the user.

    D

    Modify the system privileges assigned to the users.

    E

    Modify the value for the RESOURCE_LIMIT parameter in the parameter file.


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

  • 第7题：

    单选题
    In which scenario do you use the Flashback Database feature？（）
    A

     when a table is dropped and you restore it from the Recycle Bin

    B

     when a user’s schema is dropped and you recover the user’s schema

    C

     when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp

    D

     when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration


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

  • 第8题：

    单选题
    A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392： exceeded session limit on CPU usage， you are being logged off Which action would you take to increase the session limit on CPU usage？（）
    A

    Modify the profile assigned to the user.

    B

    Modify the roles assigned to the users.

    C

    Modify the object privileges assigned to the user.

    D

    Modify the system privileges assigned to the users.

    E

    Modify the value for the RESOURCE_LIMIT parameter in the parameter file.


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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

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


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

  • 第12题：

    单选题
    An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace：   1. You log on to Enterprise Manager as SYSDBA.    2. You select the maintenance screen.    3. You choose Perform Recovery option on the maintenance screen.    4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen.    6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen.    7. You click the continue button.    An information screen appears saying that the database is unavailable. What is this information screen？（）
    A

    Recovery Manager

    B

    Recovery Window

    C

    Recovery Wizard

    D

    Enterprise Manager Home Page


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

  • 第13题：

    An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace：   1. You log on to Enterprise Manager as SYSDBA.    2. You select the maintenance screen.    3. You choose Perform Recovery option on the maintenance screen.    4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen.    6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen.    7. You click the continue button.    An information screen appears saying that the database is unavailable. What is this information screen？（）

    • A、Recovery Manager
    • B、Recovery Window
    • C、Recovery Wizard
    • D、Enterprise Manager Home Page

    正确答案:C

  • 第14题：

    Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）

    • A、You find that one of the redo log members in each redo log group is lost.
    • B、You find that a data file that belongs to the USERS tablespace is damaged.
    • C、You find that a data file that belongs to the SYSTEM tablespace is damaged.
    • D、You find that the current redo log group is damaged and is not available for recovery.
    • E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

    正确答案:D,E

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    You create 200 new user accounts. The users are located in six different sites. New users report that they receive the following error message when they try to log on： "The username or password is incorrect." You confirm that the user accounts exist and are enabled. You also confirm that the user name and password information supplied are correct. You need to identify the cause of the failure. You also need to ensure that the new users are able to log on Which utility should you run（）

    • A、Rsdiag
    • B、Rstools
    • C、Repadmin
    • D、Active Directory Domains and Trusts

    正确答案:C

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）
    A

    In a SQL Trace log file， you should look for queries with low duration values and high read and write values.

    B

    In a query execution plan， you should look for queries with missing or out-of-date statistics.

    C

    In a SQL Trace log file， you should look for queries with high duration values and low read and write values.

    D

    In a query execution plan， you should look for queries with a large number of table scans.


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

  • 第20题：

    单选题
    When you try to open your database， you receive the following error：  ORA-00205： error in identifying controlfile  Where would you find the details required to resolve this error？（）
    A

    audit trail

    B

    alert log file

    C

    user trace file

    D

    online trace file

    E

    background trace file

    F

    operating system event viewer


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

  • 第21题：

    单选题
    In which scenario will you perform a cancel-based recovery？（）
    A

     when a tablespace is dropped and you have only RMAN-based backup of the database

    B

     when a table is dropped and stored in the Recycle Bin

    C

     when you are required to recover an existing table to its previous state

    D

     when a tablespace is dropped and you have only a user-managed full backup of the database


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    You create 200 new user accounts. The users are located in six different sites. New users report  that they receive the following error message when they try to log on： "The username or  password is incorrect."     You confirm that the user accounts exist and are enabled. You also confirm that the user name  and password information supplied are correct.     You need to identify the cause of the failure. You also need to ensure that the new users are able  to log on.     Which utility should you run（）
    A

    Rsdiag

    B

    Rstools

    C

    Repadmin

    D

    Active Directory Domains and Trusts


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

相关内容