niusouti.com

单选题You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to r

题目
单选题
You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）
A

The baseline， once created， cannot be removed.

B

Disable the baseline metrics in the Database Control Manage Metrics page.

C

The baseline will be automatically removed once the database performance has been optimized.

D

Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.

相似考题

1.You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）A、The baseline， once created， cannot be removed.B、Disable the baseline metrics in the Database Control Manage Metrics page.C、The baseline will be automatically removed once the database performance has been optimized.D、Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.

2. You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the 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 the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data

3.You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）A、create baseline metrics for today’s performanceB、write the current database metrics to a database table and create a trigger to compare with future database statisticsC、write the current database metrics to a flat file and create an operating script to compare with future database statisticsD、write the current database metrics to a database table and create a procedure to compare with future database statisticsE、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

4. You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）A、 Use SQL Server Profiler to identify missing indexes.B、 Use the Database Engine Tuning Advisor to identify missing indexes.C、 Use a Dynamic Management View to analyze query plans.D、 Use a DynamicManagement View to ascertain the number of pending I/O requests.

更多“单选题You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to r”相关问题

  • 第1题：

    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）

    • A、The instance aborts.
    • B、The database cannot be recovered.
    • C、The database can be recovered by restoring the control files from the backup.
    • D、The database remains opened and you have to shut it down with the ABORT option.
    • E、The database can be restored till the point of the last closed whole database backup.

    正确答案:A,E

  • 第2题：

    You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

    • A、You must have started the database instance in restricted mode.
    • B、You must have started the database instance inNORMALmode.
    • C、You must have started the database instance with server parameter file.
    • D、You must have started the database instance but must not have mounted.
    • E、You must have started the database instance but must not have opened.

    正确答案:C

  • 第3题：

    You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）

    • A、Increase the size of redo log files
    • B、Increase the size of redo log buffer
    • C、Increase the number of redo log files
    • D、Place the redo log files on a separate disk
    • E、Decrease the number of redo log groups to two
    • F、Increate the number Log Writer （LGWR） process

    正确答案:B,D

  • 第4题：

    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

    正确答案:C

  • 第5题：

    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）

    • A、increase the size of the redo log buffer
    • B、increase the number of redo log groups
    • C、increase the number of log writer processes
    • D、increase the number of ARCn processes
    • E、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

    正确答案:B,E

  • 第6题：

    You administer a SQL Server 2008 instance. The instance runs on a computer that has the following features: A 64-GB RAM  Four quad-core processors  Several independent physical raid volumes  You plan to implement a transactional database on the instance. The database is expected to have a high volume of INSERT, UPDATE, and DELETE activities. The activities include creation of new tables. You need to optimize the performance of the database by maximizing disk bandwidth and reducing the contention in the storage allocation structures. What should you do?（）

    • A、Create multiple data files for the database.
    • B、Place database and log files on the same volume.
    • C、Configure the affinity mask option appropriately.
    • D、Configure the affinity I/O mask option appropriately.

    正确答案:A

  • 第7题：

    多选题
    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？ （）
    A

    increase the size of the redo log buffer

    B

    increase the number of redo log groups

    C

    increase the number of log writer processes

    D

    increase the number of ARCn processes

    E

    change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location


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

  • 第8题：

    单选题
    You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）
    A

    Run Segment Advisor

    B

    Run the SQL Tuning Advisor (STA)

    C

    Run the Automatic Workload Repository (AWR) report

    D

    Run the SQL Access Advisor with a hypothetical workload


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

  • 第9题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the 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 the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data


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

  • 第10题：

    单选题
    You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective？（）
    A

    Save the baseline in the database

    B

    Save the baseline in the Database Control Home Page

    C

    Create a procedure to read and apply the baseline to disk I/O metrics

    D

    Apply the baseline to the disk I/O metrics in the Mange Metrics page

    E

    Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd


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

  • 第11题：

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

  • 第12题：

    单选题
    You administer a SQL Server 2008 instance. The instance runs on a computer that has the following features: A 64-GB RAM  Four quad-core processors  Several independent physical raid volumes  You plan to implement a transactional database on the instance. The database is expected to have a high volume of INSERT, UPDATE, and DELETE activities. The activities include creation of new tables. You need to optimize the performance of the database by maximizing disk bandwidth and reducing the contention in the storage allocation structures. What should you do?（）
    A

    Create multiple data files for the database.

    B

    Place database and log files on the same volume.

    C

    Configure the affinity mask option appropriately.

    D

    Configure the affinity I/O mask option appropriately.


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

  • 第13题：

    You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective？（）

    • A、Save the baseline in the database
    • B、Save the baseline in the Database Control Home Page
    • C、Create a procedure to read and apply the baseline to disk I/O metrics
    • D、Apply the baseline to the disk I/O metrics in the Mange Metrics page
    • E、Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd

    正确答案:D

  • 第14题：

    You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

    • A、Run Segment Advisor
    • B、Run the SQL Tuning Advisor (STA)
    • C、Run the Automatic Workload Repository (AWR) report
    • D、Run the SQL Access Advisor with a hypothetical workload

    正确答案:D

  • 第15题：

    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

    • A、 redo log files
    • B、 password file
    • C、 control file
    • D、 change tracking file

    正确答案:D

  • 第16题：

    You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）

    • A、 CPU usage
    • B、 degree of parallelism
    • C、 number of open cursors
    • D、 number of sorts performed
    • E、 idle time for blocking sessions
    • F、 number of disk I/O operations performed
    • G、 number of memory I/O operations performed

    正确答案:A,B,E

  • 第17题：

    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

  • 第18题：

    You are designing a performance monitoring plan for the database that supports APP1. You need to monitor only necessary indicators. Which indicator or indicators should you include in the baseline?（）

    • A、response times for frequently used queries
    • B、database backup and restore completion times
    • C、disk I/O
    • D、CPU utilization
    • E、network packet size
    • F、SOAP requests failed

    正确答案:A,C,D

  • 第19题：

    单选题
    You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
    A

    create baseline metrics for today’s performance

    B

    write the current database metrics to a database table and create a trigger to compare with future database statistics

    C

    write the current database metrics to a flat file and create an operating script to compare with future database statistics

    D

    write the current database metrics to a database table and create a procedure to compare with future database statistics

    E

    write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics


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

  • 第20题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the 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 the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data.


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

  • 第21题：

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

  • 第22题：

    单选题
    You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）
    A

     Use SQL Server Profiler to identify missing indexes.

    B

     Use the Database Engine Tuning Advisor to identify missing indexes.

    C

     Use a Dynamic Management View to analyze query plans.

    D

     Use a DynamicManagement View to ascertain the number of pending I/O requests.


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

  • 第23题：

    单选题
    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）
    A

     redo log files

    B

     password file

    C

     control file

    D

     change tracking file


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

  • 第24题：

    单选题
    You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）
    A

    The baseline， once created， cannot be removed.

    B

    Disable the baseline metrics in the Database Control Manage Metrics page.

    C

    The baseline will be automatically removed once the database performance has been optimized.

    D

    Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.


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

相关内容