单项选择题
A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）
A. The database re-created the missing redo log files automatically.
B. The database continues to function normally with the existing files.
C. The database allows only queries， no other statements are allowed.
D. The database returns and error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.
相关考题
-
单项选择题
Inyourtestdatabase，youhavecreatedtheORDERStableasanindex-organizedtable（IOT）.Tofacilitatefasterquerying，youhavecreatedamappingtableandabitmapindexontheORDER_FILLEDcolumn.Youobservethatthequeryperformancedegreeswhenusersperformalargevolumeoftransactions.Whileinvestigatingthereason，youfindthatthemappingtablesegmentisfragmented，leadingtopoorperformance.Whichoptionwouldyouusetodefragmentthemappingtablewithoutaffectingtheoriginaltabledata？（）
A. Export and import the mapping table.
B. Drop and re-create the mapping table.
C. Truncate the mapping table and reinsert the values.
D. Use the ALTER TABLE .. REBUILD command to defragment the mapping table. -
多项选择题
YourdatabaseisfunctioninginARCHIVELOGmode.Inwhichtwosituationswouldyouperformacancel-basedrecovery？（）
A. You find that one of the redo log members in each redo log group is lost.
B. You find that a data file that belongs to the USERS tablespace is damaged.
C. You find that a data file that belongs to the SYSTEM tablespace is damaged.
D. You find that the current redo log group is damaged and is not available for recovery.
E. You realized while performing a recovery that an archived redo log file needed for recovery is lost. -
单项选择题
WhichstatementistruewhilecreatingsubplansusingResourceManager？（）
A. The subplan must belong to the consumer group， SYS_GROUP.
B. The total CPU usage at any given level must be less than 100%.
C. The subplans can be used to restrict the degree of parallelism for a user.
D. You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
