单项选择题

Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）

A.Restore the data file for the SYSTEM tablespace then open the database.
B.Restore all redo logs form last night's backup, then restart the database.
C.Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered.
D.Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.

<上一题目录下一题>

热门试题

单项选择题You have configured the following： RMAN> CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’； new RMAN configuration parameters： CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’； new RMAN configuration parameters are successfully stored RMAN> SHOW DEVICE TYPE； RMAN configuration parameters are： CONFIGURE DEVICE TYPE SBT PARALLELISM 1； # CONFIGURE DEVICE TYPE DISK PARALLELISM 1； # RMAN> CONFIGURE DEVICE TYPE SET PARALLELISM 5； RMAN> SHOW DEVICE TYPE； RMAN configuration parameters are： CONFIGURE DEVICE TYPE SBT PARALLELISM 5； CONFIGURE DEVICE TYPE DISK PARALLELISM 1； # How many channels are allocated to SBT？（）

A.0， because channels have not been defined.
B.3， as indicated by the degree of parallelism.
C.1， the default value when device is configured.
D.5， as indicated by the last parallelism command.

单项选择题Whichtoolcanbeusedtocreateandconfigurelistenerstoreceiveclientconnections？（）

A.Oracle Net Manager
B.Oracle Net Control Utility
C.Oracle Net Configuration Assistant

单项选择题You issue this SQL statement： ALTER DATABASE RENAME FILE ’ ORADATA u02 user_data01.dbf’ TO ’ ORADATA u04 user_data01.dbf’； What does this SQL statement do？（）

A.It updates the control file with the new location of the data file.
B.It updates only the data dictionary with the new location of the data file.
C.It changes the location of the user_data01.dbf file in the operating system.
D.It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.

单项选择题YouareconfiguringforOracleSharedServer.Whichserviceisrequired？（）

A.Oracle Net Service
B.Oracle HTTP Service
C.Oracle Paging Service
D.Internet Directory Service

单项选择题Whichstepisrequiredforrecoverfromaninstancefailure？（）

A.Start up only.
B.Restore needed data files， then start up.
C.Complete restore from backup， then start up.
D.Perform point in time recovery， then start up.