单项选择题
The data file belonging to theSYSTEMtablespaceis 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 theSYSTEMauto 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.
相关考题
-
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.Youhavebeenaskedtouseacentralizedadministrativetooltoadministeryourdatabaseserversandapplicationservers.Inordertoachievetheobjective,whichcomponentwouldyouconfigureoneachdatabaseserver?()
A.Database Control
B.Management Server
C.Management Repository
D.Application Server Control
E.Oracle Management Agent -
多项选择题
YourbossatCertkiller.comwantsyoutoclarifyOracle10g.WhichtwostepsareperformedthefirsttimeanyUPDATEstatementisissuedaftertheinstanceisstarted?()
A.Creating the parse tree of the statement
B.Writing the modified data blocks to the data files
C.Writing the modified data to the archived redo log files
D.Updating the control file to indicate the most recent checkpoint
E.Updating the data file header to indicate the most recent checkpoint
F.Reading the blocks to database buffer cache if they are not already there -
单项选择题
Youexecutedthefollowingcommandtobackupthecontrolfile:ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatdoyoufindinthetracefile?()
A.Image of the control file
B.Location of the control file
C.Contents of the control file in text format
D.SQL command to re-create the database
E.SQL command to re-create the control file
F.Contents of the control file in binary format
