单项选择题

A.Shut down the instance， copy the control file to the ……

You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）

A.Shut down the instance， copy the control file to the third location and open the database.
B.Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
C.Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.
D.Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
E.Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.

<上一题目录下一题>

热门试题

单项选择题ThedatafilebelongingtotheSYSTEMtablespaceiscorruptedandnobackupofthefileisavailable.Howdoyourecoverthedatafile？（）

A.The data file cannot be recovered.
B.The date file can be restored from the SYSTEM auto backup.
C.Take thetablespaceoffline，drop，kand re-create it.
D.Recovery Manager （RMAN） is used to recover the data file.
E.The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youhavebeenaskedtouseacentralizedadministrativetooltoadministeryourdatabaseserversandapplicationservers.Inordertoachievetheobjective，whichcomponentwouldyouconfigureoneachdatabaseserver？（）

A.Database Control
B.Management Server
C.Management Repository
D.Application Server Control
E.Oracle Management Agent

多项选择题WhichtwostatementsaboutAutomaticStorageManagement（ASM）aretrue？（）

A.ASM provides mirroring on file by file basis.
B.ASM provides automatic load balancing across all ASM disks.
C.ASM supports the Oracle database and operating system files.
D.ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.

多项选择题Whichthreestatementsaretrueregardingthefine-grainedauditing（FGA）？（）

A.FGA is possible on SELECT statements only.
B.The audit trail for FGA is stored in the FGA_LOG$ table.
C.The audit trail for FGA is stored in the AUD_LOG$ table.
D.FGA enables a SQL predicate to define when to audit an event.
E.FGA audits DELETE statements only when audit columns are specified.
F.FGA includes the SQL statement used by the user as part of the audit event entry.

单项选择题Yourdatabaseisfunctionalwithpeakloadforonehour.Youwanttopreservetheperformancestatisticscollectedduringthisperiodsothattheycanbeusedforcomparisonwhileanalyzingtheperformanceofthedatabaseinthefuture.Whatactionwouldyoutaketoachievethistask？（）

A.Set the STATISTICS_LEVEL initialization parameter to ALL.
B.Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
C.Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.