单项选择题
What effect should the loss of an index tablespace have on an Oracle instance that is running？（）
A. instance hangs
B. instance gets aborted
C. instance continues running
D. instance gets restarted automatically
点击查看答案
相关考题
-
单项选择题
Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；
A. to undo the changes made to the EMP table since the specified time
B. to restore the EMP table that was wrongly dropped from the database
C. to view the transactions that have modified the EMP table since the specified time
D. to view the changes made to the EMP table for one or more rows since the specified time -
多项选择题
Intheparameterfileofyourproductiondatabase，theFAST_START_MTTR_TARGETparameterissetto300tooptimizeinstancerecovery.Whileobservingtheperformanceofthedatabaseduringinstancerecovery，youfindthattheredologfilesarenotsizedproperlytosupportthisactivity.Whichtwosourcescouldyouusetodeterminetheoptimalsizeoftheredologfiles？（）
A. the V$LOG view
B. the V$DBFILE view
C. the V$LOGFILE view
D. the V$INSTANCE_RECOVERY view
E. Oracle Enterprise Manager Database Control -
多项选择题
Younoticedthattheindextablespaceinyourdatabaserequiresarecovery.However，insteadofperformingamediarecovery，youdecidedtore-createtheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestore-createtheindexes？（）
A. ONLINE
B. REVERSE
C. PARALLEL
D. COMPRESS
E. NOLOGGING
F. COMPUTE STATISTICS
