單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

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

單項(xiàng)選擇題

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

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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（）