The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload 

题目

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）

  • A、by using the SQL access advisor
  • B、by using the Automatic Workload Repository report
  • C、by running the Automatic Database Diagnostic Monitor （ADDM）
  • D、by using the Automatic Workload Repository Compare Period report
  • E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
相似考题

1.Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports

2.You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）A、RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASEB、RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASEC、RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE D、RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

3.Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）  A、 WindowB、 ProgramC、 Job_ClassD、 Window group

4.Which IBM Resource would best help you determine the proper performance tuning of your System x hardware and the application workload of the software？（）A、xREF SheetsB、IBM Sizing GuidesC、Configuration & Options Guide - （COG）D、Standalone Solutions Configuration Tool （SSCT）

更多“The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload ”相关问题

  • 第1题：

    You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）

    • A、 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.
    • B、 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.
    • C、 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.
    • D、 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.

    正确答案:B

  • 第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题：

    The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）

    • A、by using the SQL access advisor
    • B、by using the Automatic Workload Repository report
    • C、by running the Automatic Database Diagnostic Monitor （ADDM）
    • D、by using the Automatic Workload Repository Compare Period report
    • E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

    正确答案:D

  • 第4题：

    On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）

    • A、Flashback Drop
    • B、Flashback Table
    • C、Flashback Database
    • D、Flashback Version Query
    • E、Flashback Transaction Query

    正确答案:C

  • 第5题：

    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

    • A、 UNTIL SEQUENCE
    • B、 UNTIL SCN
    • C、 UNTIL CHANGE
    • D、 UNTIL CANCEL

    正确答案:C,D

  • 第6题：

    You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.  Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（）  

    • A、 Create a manual incremental online database backup.
    • B、 Back up all the archived redo logs generated since the 8 a.m. backup.
    • C、 Create a brand-new backup after all the changes have been applied.
    • D、 There is no way to make the changes recoverable based on the 8 a.m. backup.
    • E、 Perform an online backup of the tablespace（s） that contained changed data.

    正确答案:B

  • 第7题：

    单选题
    At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）
    A

     DBA_PENDING_TRANSACTIONS

    B

     DBA_AUDIT_STATEMENT

    C

     V$FLASHBACK_DATABASE_STATS

    D

     FLASHBACK_TRANSACTION_QUERY


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

  • 第8题：

    单选题
    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）
    A

     incomplete recovery

    B

     complete recovery

    C

     recovery using the Flashback Database feature

    D

     recovery using the export/import utility


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

  • 第9题：

    单选题
    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）
    A

    Database replay

    B

    SQL Tuning Advisor

    C

    SQL Access Advisor

    D

    SQL Performance Analyzer

    E

    Automatic Workload Repository compare reports


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

  • 第10题：

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

  • 第11题：

    单选题
    Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8：30 a.m. With reference to this scenario， what would you do to recover the database？（）
    A

    restore all the data files from last Sunday’s backup， and then perform a time­based recovery

    B

    restore all the data files from last Sunday’s backup， and then perform a cancel­based recovery

    C

    restore all the data files from last Sunday’s backup， and then perform a change­based recovery

    D

    restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery


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

  • 第12题：

    单选题
    Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）
    A

     Window

    B

     Program

    C

     Job_Class

    D

     Window group


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

  • 第13题：

    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

  • 第14题：

    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

    • A、Database replay
    • B、SQL Tuning Advisor
    • C、SQL Access Advisor
    • D、SQL Performance Analyzer
    • E、Automatic Workload Repository compare reports

    正确答案:E

  • 第15题：

    The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）

    • A、 time-based recovery
    • B、 log sequence recovery
    • C、 cancel-based recovery
    • D、 change-based recovery

    正确答案:C

  • 第16题：

    The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt.  With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）

    • A、time­based recovery
    • B、log sequence recovery
    • C、cancel­based recovery
    • D、change­based recovery

    正确答案:C

  • 第17题：

    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

    • A、 incomplete recovery
    • B、 complete recovery
    • C、 recovery using the Flashback Database feature
    • D、 recovery using the export/import utility

    正确答案:A

  • 第18题：

    At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）

    • A、 DBA_PENDING_TRANSACTIONS
    • B、 DBA_AUDIT_STATEMENT
    • C、 V$FLASHBACK_DATABASE_STATS
    • D、 FLASHBACK_TRANSACTION_QUERY

    正确答案:D

  • 第19题：

    问答题
    Femi，Martin and James catch trains to go to the same destination.　　Femi catches the 8∶15 a.m. train.　　Martin’s train journey takes twice as long as James’.　　Martin leaves 15 minutes before Femi and arrives at noon.　　James catches the 11∶30 a.m. trains.　　What time does James arrive at the destination?

    正确答案： 1∶30 p.m.
    解析：
    Femi上午8∶15上火车，Martin比Femi早上车15分钟并且在正中午到达，即Martin在上午8∶00上车12∶00下车，行程4小时。Martin的行车时间是James的两倍，即James的行程为2小时。James上午11∶30上火车，两小时后下车，所以下车时间为下午1∶30。

  • 第20题：

    单选题
    ou can visit Galloway Wildlife Conservation Park ______
    A

    at 9:00 a. m. on 7th December

    B

    at 11:00 a.m. on 7th December

    C

    at 9:00 a.m. on 7th September

    D

    at 11:00 a. m. on 7th September


    正确答案： A
    解析：
    【语篇解读】本文是一篇说明文，题材为旅游信息。文章介绍了Galloway野生动物保护公园。内容包括公园里的动物、公园的设施、游玩须知、票价等。
    细节理解题。根据文章中间部分Open from 1st February to 30th October. 10:00 a.m. to 6:00 p.m.可知，开放时间是2月1日到10月30日，上午10点到下午6点。故选D项。

  • 第21题：

    单选题
    The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）
    A

    by using the SQL access advisor

    B

    by using the Automatic Workload Repository report

    C

    by running the Automatic Database Diagnostic Monitor （ADDM）

    D

    by using the Automatic Workload Repository Compare Period report

    E

    by analyzing the output of the V$ACTIVE_SESSION_HISTORY view


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

  • 第22题：

    单选题
    On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）
    A

    Flashback Drop

    B

    Flashback Table

    C

    Flashback Database

    D

    Flashback Version Query

    E

    Flashback Transaction Query


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

  • 第23题：

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

  • 第24题：

    单选题
    Which IBM Resource would best help you determine the proper performance tuning of your System x hardware and the application workload of the software？（）
    A

    xREF Sheets

    B

    IBM Sizing Guides

    C

    Configuration & Options Guide - （COG）

    D

    Standalone Solutions Configuration Tool （SSCT）


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

相关内容