OCP - 随笔分类(第34页) - 巴啦啦大魔王

053-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 阅读全文

posted @ 2017-11-09 16:14 巴啦啦大魔王阅读(189) 评论(0) 推荐(0)

053-578

摘要：Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to theSYSTEM tablespace and two are assigned to the USERS tables 阅读全文

posted @ 2017-11-09 16:05 巴啦啦大魔王阅读(137) 评论(0) 推荐(0)

053-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 contr 阅读全文

posted @ 2017-11-09 16:03 巴啦啦大魔王阅读(127) 评论(0) 推荐(0)

053-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 阅读全文

posted @ 2017-11-09 15:59 巴啦啦大魔王阅读(159) 评论(0) 推荐(0)

053-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 com 阅读全文

posted @ 2017-11-09 15:55 巴啦啦大魔王阅读(115) 评论(0) 推荐(0)

053-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/ora 阅读全文

posted @ 2017-11-09 09:13 巴啦啦大魔王阅读(111) 评论(0) 推荐(0)

053-573

摘要：Upon starting your database, you receive the following error:SQL> startup ORACLE instance started.Total System Global Area 171581440 bytes Fixed Size 阅读全文

posted @ 2017-11-08 18:29 巴啦啦大魔王阅读(202) 评论(0) 推荐(0)

053-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 wit 阅读全文

posted @ 2017-11-08 18:19 巴啦啦大魔王阅读(113) 评论(0) 推荐(0)

053-571

摘要：Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived re 阅读全文

posted @ 2017-11-08 18:15 巴啦啦大魔王阅读(101) 评论(0) 推荐(0)

053-570

摘要：What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Tr 阅读全文

posted @ 2017-11-08 18:13 巴啦啦大魔王阅读(136) 评论(0) 推荐(0)

053-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 d 阅读全文

posted @ 2017-11-08 18:07 巴啦啦大魔王阅读(108) 评论(0) 推荐(0)

053-568

摘要：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 阅读全文

posted @ 2017-11-08 17:58 巴啦啦大魔王阅读(124) 评论(0) 推荐(0)

053-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. 阅读全文

posted @ 2017-11-08 17:55 巴啦啦大魔王阅读(143) 评论(0) 推荐(0)

053-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 阅读全文

posted @ 2017-11-08 17:50 巴啦啦大魔王阅读(119) 评论(0) 推荐(0)

054-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 阅读全文

posted @ 2017-11-08 17:42 巴啦啦大魔王阅读(108) 评论(0) 推荐(0)

053-564

摘要：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 阅读全文

posted @ 2017-11-08 17:30 巴啦啦大魔王阅读(134) 评论(0) 推荐(0)

053-563

摘要：How many individual archive-log destination directories are supported by Oracle Database11g?A. 7B. 1C. 10D. 11E. 21 Oracle provides support for up to 阅读全文

posted @ 2017-11-08 16:19 巴啦啦大魔王阅读(96) 评论(0) 推荐(0)

053-562

摘要：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 阅读全文

posted @ 2017-11-08 16:16 巴啦啦大魔王阅读(93) 评论(0) 推荐(0)

053-561

摘要：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 阅读全文

posted @ 2017-11-08 16:08 巴啦啦大魔王阅读(92) 评论(0) 推荐(0)

053-560

摘要：What is the proper command to shut down the database in a consistent manner?A. Shutdown abortB. Shutdown killC. Shutdown nowaitD. shutdown immediateE. 阅读全文

posted @ 2017-11-08 16:01 巴啦啦大魔王阅读(107) 评论(0) 推荐(0)

随笔分类 - OCP

公告