摘要：
Upon starting your database, you receive the following error:SQL> startup ORACLE instance started.Total System Global Area 171581440 bytes Fixed Size 阅读全文
摘要：
What is the proper procedure to recover a lost tempfile?A. Restore the backup copy of the tempfile from the backup media.B. Re-create the tempfile wit 阅读全文
摘要：
Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived re 阅读全文
摘要：
What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Tr 阅读全文
摘要：
Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?A. Issue a checkpoint.B. Shut d 阅读全文
摘要：
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOGmode? (Choose all that apply.)A. Database datafilesB. Cont 阅读全文
摘要：
You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?A. Shut down the database. 阅读全文
摘要：
You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) and the database has crashed.What would be the appropriate order 阅读全文
摘要：
As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?A. Shut down the 阅读全文
摘要：
Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which 阅读全文
摘要：
How many individual archive-log destination directories are supported by Oracle Database11g?A. 7B. 1C. 10D. 11E. 21 Oracle provides support for up to 阅读全文
摘要：
Your archive-log destination directory runs out of space. What is the impact of this on the database?A. None. The database will switch over to the sta 阅读全文
摘要：
If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,what will be the result when you issue the command alte 阅读全文
摘要：
What is the proper command to shut down the database in a consistent manner?A. Shutdown abortB. Shutdown killC. Shutdown nowaitD. shutdown immediateE. 阅读全文
摘要：
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the dat 阅读全文
摘要：
Which view provides information on the backup status of the datafiles in the database?A. V$BACKUPB. V$BACKUP_STATUSC. V$BACKUP_DATAFILED. V$DATAFILE_B 阅读全文
摘要：
What will be the result of the following configuration?Log_archive_dest_1=location=c:\oracle\arch\mydbLog_archive_dest_2=location=z:\oracle\arch\mydbA 阅读全文
摘要：
Archived redo logs can be copied to more than one destination by Oracle.A. TrueB. False Oracle can be configured to copy archived redo logs to up to 1 阅读全文
摘要：
Which of the following parameters defines the location where Oracle should create archived redologs?A. LOG_ARCHIVE_1B. LOG_DESTINATION_1C. LOG_ARCHIVE 阅读全文
摘要：
Which is not a valid way of backing up a control file?A. Backing up the control file to traceB. Copying the existing control file of the database to t 阅读全文