ITPub博客

（580）What does the SCN represent?A. The system change number,which is a point in time relative to transactions within a given database.B. A number that represents time.Thus,at 1300 hours,the SCN is the same on all databases.C. The security change number,which represents the security cod...

（579）You have lost all your online redo logs. As a result,your database has crashed.You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.SQL>startup ORACLE instance started....

（578）Your ARCHIVELOG-mode database has lost three datafiles and shut down.One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace.You can choose from the following steps to recover your database:a. Restore the three database datafiles that were lost.b. Iss...

（577）What methods are available to recover lost control files?(Choose all that apply.)A. Backup control file.B. Emergency control file.C. The create controlfile command.D. The restore controlfile SQL*Plus command.E. No backup is required. The database will re-create the control ...

（576）Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode,back to last Tuesday the 20th.Your last backup is from Monday the 19th.What do you do?A. Restore the 19ths backup,restore all archived redo logs,recover the database to the 20th,and op...

（575）You have lost all your database control files.To recover them,you are going to use the results of the alter database backup controlfile to trace command.Your datafiles and your online redo logs are all intact.Which of the following is true regarding your recovery?A. You will ne...

（574）A user sends you an email with the following error message:create table idtable (id number)*ERROR at line 1:ORA-01110:data file 4: '/oracle01/oradata/orcl/users01.dbf'ORA-27041:01116:error in opening database file 4 ORA-unab...

（573）Upon starting your database,you receive the following error:SQL>startup ORACLE instance started.Total System Global Area 171581440 bytesFixed Size 1298640 bytesVariable Size 146804528 bytesDatabase Buffers 20971520 bytesRedo Buffers 2506752 bytesDatabase mounted....

（572）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 with the create tempfile command.C. Copy an existing tempfile from another database.D. Re-create the tempfile with the create table...

（571）Which files are required for a full recovery of the database in ARCHIVELOG mode?(Choose three.)A. Database datafilesB. Online redo logsC. Archived redo logsD. Backup control fileE. Control file from a backup答案：（A、C、D）

（570）What methods of point-in-time recovery are available?(Choose all that apply.)A.Change-basedB.Cancel-basedC.Time-basedD.Sequence number-basedE.Transaction number-based答案：（A、B、C、D）解析：In an RMAN DBPITR operation,you specify a target SCN,log sequence,restor...

（569）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 down the database.c. Issue an alter database open command to open the database.d. Startup mount the database.e. Issue an alter ...

（568）Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?(Choose all that apply.)A. Database datafilesB. Control filesC. Archived redo logsD. Online redo logsE. Flashback logs答案：（A、B、D）

（567）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.B. Restore a control-file copy from backup media.C. Use the create control file command to create a new control file.D. Copy ...

（566）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 of operations to correct the situation?a. Mount the database with the startup mount command.b. Take the SYSTEM datafile offline with ...

（565）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 databaseB. Clear the online redo logC. Back up the databaseD. Checkpoint the databaseE. Call Oracle support答案：（D）...

（564）Your database has experienced a loss of datafile users_01.dbf,which is associated with a tablespace called USERS.The database is still running.Which answer properly describes the order of the steps that you would use to recover from this error?1. Shut down the database.2. Take the ...

（563）How many individual archive-log destination directories are supported by Oracle Database11g?A. 7B. 1C. 10D. 11E. 21答案：（C）解析：LOG_ARCHIVE_DEST_nwhere:n is an integer from 1 to 31.Archive destinations 1 to 10 are available for local or remot...