随笔分类 -  归档

摘要:Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?A. shutdown immediate from R 阅读全文
posted @ 2017-11-09 17:40 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
摘要:Consider the following command:Backup database plus archivelog delete input;How many backup sets would be created by this command if the following wer 阅读全文
posted @ 2017-11-09 16:53 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)
摘要:You are trying to recover your database. During the recovery process, you receive the following error:ORA-00279: change 5033391 generated at 08/17/200 阅读全文
posted @ 2017-11-09 16:27 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
摘要: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)
摘要: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)
摘要: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)
摘要: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)
摘要: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)
摘要: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)
摘要: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)
摘要: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)
摘要: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 阅读全文
posted @ 2017-11-08 15:21 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-08 15:14 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
摘要:Which of the following parameters defines the location where Oracle should create archived redologs?A. LOG_ARCHIVE_1B. LOG_DESTINATION_1C. LOG_ARCHIVE 阅读全文
posted @ 2017-11-08 14:58 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
摘要:What is the correct order of steps to perform an online database backup?A. alter database begin backup;B. alter database end backup;C. Back up the dat 阅读全文
posted @ 2017-11-08 14:35 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
摘要:Which is the correct command to put the database in ARCHIVELOG mode?A. alter database archivelogB. alter system enable archivelog modeC. alter databas 阅读全文
posted @ 2017-11-08 14:28 巴啦啦大魔王 阅读(86) 评论(0) 推荐(0)
摘要:What are the different logging modes available in Oracle Database 11g? (Choose two.)A. NOLOG modeB. NOARCHIVELOG modeC. LOGGING modeD. HOTDATABASE mod 阅读全文
posted @ 2017-11-08 14:26 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
摘要:You backed up the database at 8 a.m. today using an online backup. Accounting made a largechange to the underlying data between 10 a.m. and noon. Whic 阅读全文
posted @ 2017-11-08 14:22 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0)
摘要:Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain thatthey dont want you to shut down the database to perform t 阅读全文
posted @ 2017-11-08 13:58 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0)
摘要:If a log file becomes corrupted, it may cause the database to stall. How would you correct such asituation?A. Recover the online redo log from backup. 阅读全文
posted @ 2017-11-06 13:26 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)