摘要: Which statements are true regarding table compression? (Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space 阅读全文
posted @ 2017-11-16 17:08 巴啦啦大魔王 阅读(81) 评论(0) 推荐(0) 编辑
摘要: Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/ 阅读全文
posted @ 2017-11-16 17:06 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0) 编辑
摘要: Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backu 阅读全文
posted @ 2017-11-16 17:04 巴啦啦大魔王 阅读(72) 评论(0) 推荐(0) 编辑
摘要: You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level? 阅读全文
posted @ 2017-11-16 17:00 巴啦啦大魔王 阅读(85) 评论(0) 推荐(0) 编辑
摘要: You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable 阅读全文
posted @ 2017-11-16 16:59 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0) 编辑
摘要: You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You alsohave a table named MY_TABLE in your schema. You execute t 阅读全文
posted @ 2017-11-16 16:57 巴啦啦大魔王 阅读(137) 评论(0) 推荐(0) 编辑
摘要: You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?A. The BZIP2 compression 阅读全文
posted @ 2017-11-16 16:56 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0) 编辑
摘要: Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are bac 阅读全文
posted @ 2017-11-16 16:54 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0) 编辑
摘要: You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BA 阅读全文
posted @ 2017-11-16 16:51 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0) 编辑
摘要: You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transfer 阅读全文
posted @ 2017-11-16 16:46 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0) 编辑
摘要: You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is p 阅读全文
posted @ 2017-11-16 16:45 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0) 编辑
摘要: Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?A. a cumulative level 1 backupB. a different 阅读全文
posted @ 2017-11-16 16:36 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0) 编辑
摘要: Which statement about using RMAN stored scripts is true?A. To create and execute an RMAN stored script, you must use a recovery catalog.B. When execut 阅读全文
posted @ 2017-11-16 16:34 巴啦啦大魔王 阅读(125) 评论(0) 推荐(0) 编辑
摘要: You have enabled resumable space allocation in your database by setting theRESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements a 阅读全文
posted @ 2017-11-16 16:31 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0) 编辑
摘要: Which statement about recovering from the loss of a redo log group is true?A. If the lost redo log group is ACTIVE, you should first attempt to clear 阅读全文
posted @ 2017-11-16 16:27 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0) 编辑
摘要: Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the databa 阅读全文
posted @ 2017-11-16 16:25 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0) 编辑
摘要: You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when youperform tape backups. Which action should you take?A. Set th 阅读全文
posted @ 2017-11-16 16:20 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0) 编辑
摘要: Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance.To what value will the 阅读全文
posted @ 2017-11-16 16:15 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0) 编辑
摘要: You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You r 阅读全文
posted @ 2017-11-16 16:05 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0) 编辑
摘要: Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?A. A 阅读全文
posted @ 2017-11-16 16:01 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0) 编辑