單項選擇題

Data file DF1 belongs to tablespace TS1.，and the database is in ARCHIVELOG mode. You did an incomplete recover in the following steps：
1. Take data file DF1 offline.
2. Copy a backup copy of DF1 into the current DF1 location.
3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past.
4. Bring DF1 online.
5. Execute ALTER DATABASE OPEN RESETLOGS.
To guarantee that the database is recoverable in the future， what is the least amount of work needed？（）

A.Back up the data file.
B.Bring tablespace TS1 online.
C.Copy redo logs to the backup directory.
D.Make a complete backup right after opening the database.

你可能感興趣的試題

單項選擇題

An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）

A.EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
B.ALTER TABLE … COALESCE ；
C.ALTER INDEX …REBUILD ONLINE；
D.CREATE TABLE …AS SELECT_ONLINE；

多項選擇題

The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you issue these SELECT statements in the order shown below：
SELECT * FROM employees WHERE department_id=50；
SELECT * FROM employees WHERE department_id=70；
There is an index on the DEPARTMENT ID column of the 1，000，000 row EMPLOYEES table. Ninety percent of the employees are part of the DEPARTMENT_ID 50. In which two scenarios will Oracle9i share the corresponding cursors for the two statements？（）

A.A
B.B
C.C
D.D

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

你可能感興趣的試題

An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）

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

An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）