单项选择题
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.
Which method would you use to recover the data file？（）
A.Restore all the data files and open the database
B.Create the data file and performtablespacerecovery
C.No need to restore any file， just recover the database
D.Restore only the system data file and recover the database
E.Restore only lost date file and performtablespacerecovery
相关考题
-
多项选择题
YouworkasadatabaseadministratorforCertkiller.com.Inthemiddleofatransaction，ausersessionwasabnormallyterminatedbuttheinstanceisstillupandthedatabaseisopen.Whichtwostatementsaretrueinthisscenario？（）
A.Event Viewer gives more details on the failure.
B.The alert log file gives detailed information about the failure.
C.PMON rolls back the transaction and releases the locks.
D.SMON rolls back the transaction and releases the locks.
E.The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
F.Data modified by the transaction up to the last commit before the abnormal termination is retained in the database. -
单项选择题
YourbossatCertkiller.comwantsyoutoclarifyOracle10g.Whichconditioninyourdatabaseforcesyoutoperformonlyconsistentbackups？（）
A.The database is in mount state.
B.One of the tablespaces is offline.
C.One of the tablespaces is read only.
D.The database operates in ARCHIEVELOG mode.
E.The database operates in NOARCHIEVELOG mode. -
多项选择题
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（）
A.Increase the size of redo log files
B.Increase the size of redo log buffer
C.Increase the number of redo log files
D.Place the redo log files on a separate disk
E.Decrease the number of redo log groups to two
F.Increate the number Log Writer （LGWR） process
