You work as a database administrator for Supportcenter.cn. Y

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this?()

  • A、Enable instance failover
  • B、Configure shared server
  • C、Enable database failover
  • D、Enable connect-time failover
  • E、Enable Transparent Application Failover (TAF)

正确答案:D

第2题:

You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()

  • A、The trace file
  • B、The fixed views
  • C、The data dictionary views
  • D、The operating system log fields
  • E、The dynamic performance views.

正确答案:E

第3题:

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

第4题:

You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error: ERROR:   ORA-12154:TNS:couldnot resolve service name   Which network configuration files would you look into to resolve this error?()

  • A、snmp.ora
  • B、names.ora
  • C、spfile.ora
  • D、sqlnet.ora
  • E、listener.ora
  • F、tnsnames.ora

正确答案:D,F

第5题:

You work as a database administrator for Supportcenter.cn. 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

第6题:

You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()

  • A、Use a flashback query to retrieve the rows that were deleted
  • B、Useconventialincremental export and then import the affected object
  • C、Shutdown the database inNORMALmode and restart the database instance
  • D、Use DBMS_META package to reconstruct the object using undo segments
  • E、UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the data
  • F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

正确答案:B,E

第7题:

You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()

  • A、Set the UNDO_RETENTION parameter to AUTO.
  • B、Create an initial undo segment in undotablespace.
  • C、Set the UNDO_RETENTION parameter to 900 or more
  • D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
  • E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

正确答案:D,E

第8题:

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

第9题:

You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?()

  • A、You performed rollback after commit.
  • B、If a log switch occurs in your database.
  • C、Thearchiverfails to generate an archived log file.
  • D、Instance recovery fails to find one of the redo log files.
  • E、A long-running query is unable to get read-consistent image.
  • F、If you perform manual undo management operations in auto mode.

正确答案:E

第10题:

You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file?()

  • A、USER_DUMP_DEST
  • B、CORE_DUMP_DEST
  • C、ALERT_LOG_DEST
  • D、ALERT_DUMP_DEST
  • E、TRACE_DUMP_DEST
  • F、BACKGROUND_DUMP_DEST

正确答案:F

更多相关问题