单项选择题

In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

A.Nothing happens
B.Oracle will automatically switch redo logs when detected
C.Oracle eventually won't allow new records to be added to the database
D.The instance crashes

<上一题目录下一题>

热门试题

单项选择题YouareanalyzinghowOracleprocessesuserstatements.SQLandPL SQLparseinformationisstoredinwhichofthefollowingdatabasememoryareas?（）

A.Library cache
B.Row cache
C.Dictionary cache
D.Large area
E.Buffer cache

单项选择题Youaredesigningthephysicaldatabaselayoutonyourhostmachine.WhatistherelationshipbetweentablespacesanddatafilesintheOracledatabase?（）

A.One tablespace has only one datafile
B.Many tablespaces can share one datafile
C.One tablespace can have many datafiles
D.One datafile can contain many tablespaces

单项选择题Duringregulardatabaseoperation,whichbackgroundprocesswilltakesmallerblocksoffreespaceinadictionary-managedtablespaceandmovethingsaroundtomakebiggerpiecesoffreespace?（）

A.DBW0
B.LGWR
C.ARCH
D.SMON
E.PMON

单项选择题Youareconfiguringyourindextobestoredinatablespace.WhichofthefollowingstorageparametersareNOTappropriateforindexes?（）

A.OPTIMAL
B.INITIAL
C.PCTINCREASE
D.NEXT

单项选择题ouareimplementingcontrolfilemultiplexing.WhichofthefollowingchoicesidentifiesthemethodyoucanuseinordertogeneratethecontrolfilecopiesthatOraclewillmaintain?（）

A.Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B.Make a copy of the control file with the database shut down
C.Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D.Make a copy of the control file with the database still running