单项选择题
The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file?()
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.
