單項選擇題

You are working as a DBA in a company. The datafiles in the database are as follows：

On Monday， you tried to start up the database but failed because all the control files were missing. You recreated the control file using the script you have created by issuing the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command. What is the prerequisite for recreating the control file？（）

A. All the datafiles should be listed in the CREATE CONTROLFILE statement.
B. The DATA2.dbf and DATA3.dbf datafiles should be listed in the CREATE CONTROLFILE statement.
C. The SYSTEM01.dbf datafile should be listed in the CREATE CONTROLFILE statement.
D. The SYSAUX01.dbf datafile should be listed in the CREATE CONTROLFILE statement.

你可能感興趣的試題

單項選擇題

Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）

A. The queries that are currently executing will abort and an error message will be returned to the user.
B. The queries that are currently executing will execute normally but future queries will not executed.
C. Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.
D. The currently executing and future queries will execute normally， but will be slower

單項選擇題

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

A. by using the Flashback Database feature
B. by using RMAN incomplete recovery
C. by performing a user-managed incomplete recovery
D. by dropping and re-creating the index tablespace

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久