单项选择题

You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

A.The database would open normally.
B.The database would not open， and it would stop at mount stage.
C.The database would open after automatically performing instance recovery.
D.The database would not open， and you have to perform database recovery to open it.

点击查看答案

上一题目录下一题

相关考题

多项选择题

Which two operations can be flashed back using the Flashback technology？（）

A.DROP USER SMITH；
B.DROP TABLE EMPLOYEES；
C.DROP TABLESPACE USERS；
D.ALTER TABLE SALES_REP DROP PARTITION P1；
E.ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；

多项选择题

View this parameter setting in your database：
DB_CREATE_FILE_DEST=’D： \oracle\product\10.2.0\oradata\oracle’
You created a tablespace by using this command：
CREATE TABLESPACE USERS；
Which two statements are true about the USERS tablespace？（）

A.The tablespace has two data files.
B.An error is reported and tablespace creation fails.
C.Data files are created with names generated by the instance.
D.The tablespace can be extended without specifying the data file.
E.Data files belonging to the USERS tablespace cannot be renamed.

单项选择题

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.
What would you do in this situation？（）

A.recover using Oracle Flashback Database technology
B.restore the data files from backup and perform a complete recovery
C.restore only the corrupted data file and perform tablespace recovery
D.restore the data files from backup and perform cancel-based recovery
E.restore the entire database from the most recent backup and start the instance and open the database