多选题Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider befor

题目
多选题
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
A

the retention period to support flashback

B

the expected length of the longest-running query

C

the number of undo tablespaces in the database

D

the size of the Flash Recovery Area for the database instance

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

第1题:

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()

  • A、 You must use automatic undo management in the database.
  • B、 You must configure OMF in your database.
  • C、 You must configure ASM for storing the datafiles.
  • D、 You must multiplex the online redo log file.

正确答案:A

第2题:

You work as a database administrator for Supportcenter.cn. You want to administer your database servers, which are running on different host machines, using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()

  • A、Application Server Control
  • B、Oracle Management Service
  • C、Oracle Enterprise Manager Repository
  • D、Oracle Enterprise Manager Database Control

正确答案:C,D

第3题:

You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).

A. The backup as copy can only be taken to disk

B. The backup as copy can only be taken to tape

C. Backup can be performed only when the instance is shutdown

D. Backup will constitute all used and unused blocks in the database


参考答案:A, D

第4题:

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

第5题:

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

第6题:

Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()

  • A、the retention period to support flashback
  • B、the expected length of the longest-running query
  • C、the number of undo tablespaces in the database
  • D、the size of the Flash Recovery Area for the database instance

正确答案:A,B

第7题:

Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()

  • A、The retention period to support flashback
  • B、The expected length of the longest-running query
  • C、The number of undo tablespaces in the database
  • D、The size of the Flash Recovery Area for the database instance

正确答案:A,B

第8题:

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()

  • A、You must have change tracking enabled in your database
  • B、Your database must be running in NOARCHIVELOG mode
  • C、To back up a tablespace, it must be in backup mode
  • D、To back up a tablespace, it must first be taken offline

正确答案:C

第9题:

You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA?()

  • A、 SQL Tuning Advisor
  • B、 Undo Advisor
  • C、 ADDM
  • D、 Memory Advisor

正确答案:D

第10题:

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()

  • A、 The backup as copy can only be taken to disk
  • B、 The backup as copy can only be taken to tape
  • C、 Backup can be performed only when the instance is shutdown
  • D、 Backup will constitute all used and unused blocks in the database

正确答案:A,D

更多相关问题