Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently, the warning threshold fo

题目

Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently, the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool, you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do?()

  • A、 Disable SQL tracing for the APPS tablespace.
  • B、 Disable logging attributes for the APPS tablespace.
  • C、 Modify the tablespace to be a dictionary-managed tablespace.
  • D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
  • E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.

相似考题
参考答案和解析
正确答案:E
更多“Users are performing”相关问题
  • 第1题:

    在缺省配置下,普通用户登录到Windows 2000 Professional中和Windows 2000 Server中后分别所在的组为()

    • A、Users,Users
    • B、Power Users,Power Users
    • C、Users,Power Users
    • D、Power Users,Users

    正确答案:D

  • 第2题:

    下面哪些可以将john添加到users数组中?()

    • A、$users[]=‘john’;
    • B、array_add($users,’john’);
    • C、array_push($users,‘john’);
    • D、$users[“name”]=‘john’;

    正确答案:A,C,D

  • 第3题:

    A 4-way x445 server with 2GB of memory running Windows 2003 Server with Exchange 2003 is performing poorly.  Users are complaining of slow response times when accessing their email.  Which subsystem should be checked first as a potential bottleneck?()

    • A、Processors
    • B、Memory subsystem
    • C、Storage subsystem
    • D、Network connectivity

    正确答案:B

  • 第4题:

    You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX:   SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE;   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation?() 

    • A、 Index-organized table
    • B、 Mapping Table
    • C、 Clustered Table
    • D、 Journal Table

    正确答案:D

  • 第5题:

    The size of the largest datafile, data1.dbf, in your database is 30MB. You issued the following command:   RMAN>CONFIGURE MAXSETSIZE 10MB;     What will be the impact of the above setting?()

    • A、 While performing the backup of the datafile,data1.dbf,one backup set is created.
    • B、 While performing the backup of the datafile,data1.dbf,two backup sets are created.
    • C、 While performing the backup of the datafile,data1.dbf,three backup sets are created.
    • D、 While performing the backup of the datafile,data1.dbf,the command for performing a backup of the datafile,data1.dbf,will fail.

    正确答案:D

  • 第6题:

    You are the administrator of a Windows 2000 Professional computer. A user named Maria assists you in performing some administrative tasks. Maria is a member of local Administrators group. Users report that Maria has been viewing and changing their files.  You want Maria to be able to install programs, perform backups and manage printers, but not to view, change or read other users’ files for which permission has not been granted. You want to set up Maria’s account to have minimal rights and permission. You want to accomplish this with least amount of administrative effort.  What should you do?  ()

    • A、 Leave Maria in the local Administrators group.  Limit her rights by using Local Policies.
    • B、 Leave Maria in the local Administrators group. Change the NTFS provision on other users’ files to deny Maria’s request.
    • C、 Remove Maria from the local Administrators group. Add her to both the Power Users group and Backup Operators group.
    • D、 Remove Maria from local Administrators group.  Add her to Power User group.  Then grant her NTFS Read permission on the files to be backed up.

    正确答案:C

  • 第7题:

    单选题
    A retail customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations. Which questions will provide the information necessary to design the best performing storage solution of the following?()
    A

    How many web servers will be connected to the database?

    B

    How many concurrent applications will run against the database?

    C

    How many concurrent users will be accessing the database?

    D

    What are the types of transactions run against the database?


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

  • 第8题:

    单选题
    A customer is experiencing a performance bottleneck in a disk subsystem.  The server is performing sequential I/O with a small number of users requesting large files.  Which of the following would most likely resolve the bottleneck?()
    A

    Increase seek translation

    B

    Increase data transfer rate

    C

    Decrease rotational latency

    D

    Increase rotational latency


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

  • 第9题:

    单选题
    Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement:   SQL>ALTER TABLSPACE temp OFFLINE NORMAL;   What is the result of this statement?()
    A

     The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.

    B

     The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.

    C

     The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected, but these users must re-execute their queries.

    D

     The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected, and their queries execute successfully.


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

  • 第10题:

    多选题
    What are three common reasons why customers are saying that they need to evolve their data center? ()
    A

    demand among users for access to information anytime, anywhere

    B

    desire to use the same vender for desktop and server deployments

    C

    existing equipment has reached and of life

    D

    increasing operational costs of managing data centers

    E

    architectures that is inflexible and inefficient

    F

    selecting best-performing vendors for each individual component


    正确答案: C,A
    解析: 暂无解析

  • 第11题:

    单选题
    In which situation would you use the Oracle Shared Server configuration?()
    A

    when performing export and import using Oracle Data Pump

    B

    when performing backup and recovery operations using Oracle Recovery Manager

    C

    when performing batch processing and bulk loading operation in a data warehouse environment 

    D

    in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time


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

  • 第12题:

    单选题
    You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?()
    A

    Set a threshold for the default system-defined moving window baseline.

    B

    Add directives to the Automatic Database Diagnostic Monitor (ADDM).

    C

    Modify the profile for the targeted users for which control needs to be imposed.

    D

    Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.


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

  • 第13题:

    Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement:   SQL>ALTER TABLSPACE temp OFFLINE NORMAL;   What is the result of this statement?()

    • A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
    • B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
    • C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected, but these users must re-execute their queries.
    • D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected, and their queries execute successfully.

    正确答案:D

  • 第14题:

    What are three common reasons why customers are saying that they need to evolve their datacenter?()

    • A、architectures that is inflexible and inefficient
    • B、desire to use the same vender for desktop and server deployments
    • C、selecting best-performing vendors for each individual component
    • D、existing equipment has reached and of life
    • E、increasing operational costs of managing data centers
    • F、demand among users for access to information anytime, anywhere

    正确答案:A,D,E

  • 第15题:

    A customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations.  Which of the following questions will provide the information necessary to design the best performing storage solution?()

    • A、How many web servers will be connected to the database?
    • B、Will the database be run on a Windows solution?
    • C、How many concurrent users will be accessing the database?
    • D、What are the types of transactions run against the database?

    正确答案:D

  • 第16题:

    Which two prerequisites are needed for performing workload capture and replay?()

    • A、Close all sessions performing queries using database links
    • B、running the database in shared server mode
    • C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
    • D、setting up the directory to capture the workload

    正确答案:C,D

  • 第17题:

    You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()

    • A、 user managed complete recovery
    • B、 user managed incomplete recovery
    • C、 RMAN-based complete recovery
    • D、 RMAN-based incomplete recovery

    正确答案:D

  • 第18题:

    单选题
    The size of the largest datafile, data1.dbf, in your database is 30MB. You issued the following command:   RMAN>CONFIGURE MAXSETSIZE 10MB;     What will be the impact of the above setting?()
    A

     While performing the backup of the datafile,data1.dbf,one backup set is created.

    B

     While performing the backup of the datafile,data1.dbf,two backup sets are created.

    C

     While performing the backup of the datafile,data1.dbf,three backup sets are created.

    D

     While performing the backup of the datafile,data1.dbf,the command for performing a backup of the datafile,data1.dbf,will fail.


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

  • 第19题:

    单选题
    You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()
    A

     user managed complete recovery

    B

     user managed incomplete recovery

    C

     RMAN-based complete recovery

    D

     RMAN-based incomplete recovery


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

  • 第20题:

    单选题
    You are the administrator of a Windows 2000 Professional computer. A user named Maria assists you in performing some administrative tasks. Maria is a member of local Administrators group. Users report that Maria has been viewing and changing their files.  You want Maria to be able to install programs, perform backups and manage printers, but not to view, change or read other users’ files for which permission has not been granted. You want to set up Maria’s account to have minimal rights and permission. You want to accomplish this with least amount of administrative effort.  What should you do?  ()
    A

     Leave Maria in the local Administrators group.  Limit her rights by using Local Policies.

    B

     Leave Maria in the local Administrators group. Change the NTFS provision on other users’ files to deny Maria’s request.

    C

     Remove Maria from the local Administrators group. Add her to both the Power Users group and Backup Operators group.

    D

     Remove Maria from local Administrators group.  Add her to Power User group.  Then grant her NTFS Read permission on the files to be backed up.


    正确答案: C
    解析: By adding Maria’s user account to the Power Users group Maria will inherit the ability to share resources and install programs that is conferred on members of the Power Users group. To grant Maria the ability to backup files she must be added to the Backup Operators group, which has the permissions to backup files. As a member of this group Maria will be able to backup files as she will inherit those rights by virtue of  being a member of that group. Maria will not have permissions to read the users’ files as she has been removed from the local administrators group and as neither the Power Users group nor the Backup Operators group has the permissions to read other users’ files.

  • 第21题:

    单选题
    You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also, you plan to transfer these values to another table for analysis.  How would you achieve this?()
    A

    by using triggers

    B

    by using external tables

    C

    by using anonymous PL/SQL blocks

    D

    by auditing all DML operations on the table


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

  • 第22题:

    单选题
    How many users are supported on the Cisco Unified Communications models 540 and 560 platforms?()
    A

     16 users on the UC540 and 64 users on the UC560

    B

     32 users on the UC540 and 64 users on the UC560

    C

     32 users on the UC540 and 104 users on the UC560

    D

     16 users on the UC540 and 104 users on the UC560


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

  • 第23题:

    单选题
    Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true?()
    A

     You cannot perform the TSPITR with the constraints enabled.

    B

     You must perform the TSPITR recovery of both tablespaces for it to be successful.

    C

     You can perform TSPITR only on the USERS tablespace.

    D

     RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.

    E

     The TSPITR will only be successful if the constraint is enabled.


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

  • 第24题:

    多选题
    下面哪些可以将john添加到users数组中?()
    A

    $users[]=‘john’;

    B

    array_add($users,’john’);

    C

    array_push($users,‘john’);

    D

    $users[“name”]=‘john’;


    正确答案: D,C
    解析: 暂无解析