單項選擇題

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS
tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.
What would you do to recover the data file（）

A.Take the USERS tablespace offline and re-create the lost data file.
B.Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
C.Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
D.Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

你可能感興趣的試題

單項選擇題

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario()

A.The minimum memory size for the database buffer cache is set to 100 mb.
B.The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb
C.The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
D.The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb

單項選擇題

Which statement is true about the Manageability Monitor （MMON） background process（）

A.It transfers statistics from memory to disk at regular intervals.
B.It coordinates the rebalance activity for disk groups when ASM is used.
C.It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.
D.It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

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

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）

你可能感興趣的試題

Which statement is true about the Manageability Monitor （MMON） background process（）

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

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS
tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.
What would you do to recover the data file（）