the retention period to support flashback
the expected length of the longest-running query
the number of undo tablespaces in the database
the size of the Flash Recovery Area for the database instance
第1题:
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?()
第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?()
第3题:
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?()
第4题:
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
第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?()
第6题:
UNTIL SEQUENCE
UNTIL SCN
UNTIL CHANGE
UNTIL CANCEL
第7题:
The backup as copy can only be taken to disk
The backup as copy can only be taken to tape
Backup can be performed only when the instance is shutdown
Backup will constitute all used and unused blocks in the database
第8题:
SQL Tuning Advisor
Undo Advisor
ADDM
Memory Advisor
第9题:
You must have change tracking enabled in your database
Your database must be running in NOARCHIVELOG mode
To back up a tablespace, it must be in backup mode
To back up a tablespace, it must first be taken offline
第10题:
The backup as copy can only be taken to disk
The backup as copy can only be taken to tape
Backup can be performed only when the instance is shutdown
Backup will constitute all used and unused blocks in the database
第11题:
ONLINE
REVERSE
PARALLEL
COMPRESS
NOLOGGING
COMPUTE STATISTICS
第12题:
ONLINE
REVERSE
PARALLEL
COMPRESS
NOLOGGING
COMPUTE STATISTICS
第13题:
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()
第14题:
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?()
第15题:
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()
第16题:
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).
第17题:
Segment Advisor
SQL Tuning Advisor
SQL Access Advisor
Segment Resource Estimation
Automatic Database Diagnostic Monitor (ADDM)
第18题:
You must use automatic undo management in the database.
You must configure OMF in your database.
You must configure ASM for storing the datafiles.
You must multiplex the online redo log file.
第19题:
The retention period to support flashback
The expected length of the longest-running query
The number of undo tablespaces in the database
The size of the Flash Recovery Area for the database instance
第20题:
You must have started the database instance in restricted mode.
You must have started the database instance inNORMALmode.
You must have started the database instance with server parameter file.
You must have started the database instance but must not have mounted.
You must have started the database instance but must not have opened.
第21题:
The retention period to support flashback
The expected length of the longest-running query
The number of undo tablespaces in the database
The size of the Flash Recovery Area for the database instance
第22题:
Application Server Control
Oracle Management Service
Oracle Enterprise Manager Repository
Oracle Enterprise Manager Database Control
第23题:
Set the UNDO_RETENTION parameter to AUTO.
Create an initial undo segment in undotablespace.
Set the UNDO_RETENTION parameter to 900 or more
Set the initialization parameter UNDO_MANAGEMENT to AUTO
Set the UNDO_MANAGEMENT parameter to the name of an undotablespace