单选题As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）A Coalesce the applicat

题目
单选题
As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）
A

Coalesce the application tables at a regular interval.

B

Export and Import the application tables a regular interval.

C

Drop and recreate the application tables at a regular interval.

D

Move the application tables to a tablespace with less space usage.

E

Distribute the application tables across multiple tablespaces depending on usage.

F

Move the application tables to automatic segment space management tablespace.

相似考题

1.You are an administrator of a switched network and your goal is to reduce some of the administrative overhead on your network. You plan on achieving this by configuring a new VLAN for each department in your network. However, you need to share the VLAN information across numerous switches throughout your network.Which of the following would allow you accomplish this?（）A.STPB.GVRPC.SNMPD.VTPE.DHCP

2. You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）A、Memory AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）

3.You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）A、Control fileB、Password fileC、Parameter fileD、Online redo log fileE、Listener controller fileF、Server parameter file

4. In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）A、heap tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index­organized table （IOT）

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）A Coalesce the applicat”相关问题

  • 第1题：

    You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

    • A、It degrades the run time and compiler performance.
    • B、It provides better run time and compiler performance.
    • C、It provides better optimization of the statement during parse time.
    • D、It forces the rule based optimizer to be used for statement optimization.
    • E、It provides better run time performance but slightly degraded compiler performance. 
    • F、It provides better run time performance but slightly degraded run time performance.

    正确答案:E

  • 第2题：

    You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

    • A、 Memory Advisor
    • B、 Segment Advisor
    • C、 SQL Access Advisor
    • D、 Automatic Workload Repository （AWR）
    • E、 Automatic Database Diagnostic Monitor （ADDM）

    正确答案:C

  • 第3题：

    You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

    • A、Database Control
    • B、Management Server
    • C、Management Repository
    • D、Application Server Control
    • E、Oracle Management Agent

    正确答案:E

  • 第4题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）
    A

    Hot backup

    B

    Online backup

    C

    consistent backup

    D

    incremental backup

    E

    inconsistent backup


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

  • 第5题：

    单选题
    You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
    A

    Database Control

    B

    Management Server

    C

    Management Repository

    D

    Application Server Control

    E

    Oracle Management Agent


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

  • 第6题：

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

  • 第7题：

    单选题
    You work as a database administrator for Certkiller .com. You are using three database， Certkiller DB01， Certkiller DB02， and Certkiller DB03， on different host machines in your development environment. The database serverconfiguration， such as IP address and listener port number， change frequently due to development requirements， and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）
    A

    Host naming

    B

    Local naming

    C

    Easy Connect

    D

    External naming

    E

    directory naming


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

  • 第8题：

    单选题
    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）
    A

     Heap table

    B

     Object table

    C

     External table

    D

     Clustered table

    E

     Global temporary table

    F

     Index-organized table （IOT）


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

  • 第9题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第10题：

    单选题
    You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）
    A

    Control file

    B

    Password file

    C

    Parameter file

    D

    Online redo log file

    E

    Listener controller file

    F

    Server parameter file


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

  • 第11题：

    单选题
    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）
    A

    heap table

    B

    object table

    C

    external table

    D

    clustered table

    E

    global temporary table

    F

    index-organized table （IOT）


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

  • 第12题：

    单选题
    As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）
    A

    Coalesce the application tables at a regular interval.

    B

    Export and Import the application tables a regular interval.

    C

    Drop and recreate the application tables at a regular interval.

    D

    Move the application tables to a tablespace with less space usage.

    E

    Distribute the application tables across multiple tablespaces depending on usage.

    F

    Move the application tables to automatic segment space management tablespace.


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

  • 第13题：

    As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）

    • A、Coalesce the application tables at a regular interval.
    • B、Export and Import the application tables a regular interval.
    • C、Drop and recreate the application tables at a regular interval.
    • D、Move the application tables to a tablespace with less space usage.
    • E、Distribute the application tables across multiple tablespaces depending on usage.
    • F、Move the application tables to automatic segment space management tablespace.

    正确答案:F

  • 第14题：

    In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）

    • A、hash clusters
    • B、index clusters
    • C、partitioned tables
    • D、index­organized table （IOT）

    正确答案:B

  • 第15题：

    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

  • 第16题：

    单选题
    You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

    Memory Advisors

    B

    Segment Advisors

    C

    SQL Tuning and Access Advisors

    D

    Automated Workload Repository （AWR）

    E

    Automatic Database Diagnostic Monitor （ADDM）


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

  • 第17题：

    单选题
    In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）
    A

    hash clusters

    B

    index clusters

    C

    partitioned tables

    D

    index­organized table （IOT）


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

  • 第18题：

    单选题
    You are an administrator of a switched network and your goal is to reduce some of the administrative overhead on your network. You plan on achieving this by configuring a new VLAN for each department in your network. However, you need to share the VLAN information across numerous switches throughout your network. Which of the following would allow you accomplish this?（）
    A

    STP

    B

    GVRP

    C

    SNMP

    D

    VTP

    E

    DHCP


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

  • 第19题：

    单选题
    You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

    Memory Advisor

    B

    Segment Advisor

    C

    SQL Access Advisor

    D

    Automatic Workload Repository （AWR）

    E

    Automatic Database Diagnostic Monitor （ADDM）


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

  • 第20题：

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

  • 第21题：

    单选题
    You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     SQL Access Advisor

    D

     Automatic Workload Repository （AWR）

    E

     Automatic Database Diagnostic Monitor （ADDM）


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

  • 第22题：

    单选题
    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）
    A

    heap table

    B

    object table

    C

    external table

    D

    clustered table

    E

    global temporary table

    F

    index­organized table （IOT）


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

  • 第23题：

    单选题
    You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）
    A

    It degrades the run time and compiler performance.

    B

    It provides better run time and compiler performance.

    C

    It provides better optimization of the statement during parse time.

    D

    It forces the rule based optimizer to be used for statement optimization.

    E

    It provides better run time performance but slightly degraded compiler performance. 

    F

    It provides better run time performance but slightly degraded run time performance.


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

相关内容