單項(xiàng)選擇題

A media failure has occurred. This has resulted in all the members of the next 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 allows only queries； no other statements are allowed.
B. The database re-creates the missing redo log files automatically.
C. The database continues to function normally with the existing files.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.

你可能感興趣的試題

單項(xiàng)選擇題

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

A. the RMAN LIST command
B. the DBNEWID utility
C. the RMAN REPORT command
D. the RMAN BLOCKRECOVER command
E. the RMAN CROSSCHECK command
F. the ANALYZE command

單項(xiàng)選擇題

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）

A. use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
B. restore the entire database from the most recent backup and open it
C. recover the table by using the Flashback Table feature
D. perform point-in-time recovery to recover the table

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

你可能感興趣的試題

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）