11 2017 档案

052-2
摘要：Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)A. All AWR tables belong to the SYSTEM schemaB. The AWR cont 阅读全文
posted @ 2017-11-30 18:27 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
052-1
摘要：View the Exhibit and examine the attributes of an undo tablespace.In an OLTP system, the user SCOTT has started a query on a large table in the peak t 阅读全文
posted @ 2017-11-30 18:07 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
051-174
摘要：Which statement is true regarding transactions? (Choose all that apply.)A. A transaction can consist only of a set of DML and DDL statements.B. A part 阅读全文
posted @ 2017-11-30 17:48 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
Oracle中的Exists、In、ANY、ALL
摘要：Exists：子查询至少返回一行时条件为true。 Not Exists：子查询不返回任何一行时条件为true。 In：与子查询返回结果集中某个值相等。-- in null不会显示为null的值，因为null是未知的所以不会有=null，要查询为null的请用is null Not In：与子查询返 阅读全文
posted @ 2017-11-30 15:37 巴啦啦大魔王 阅读(303) 评论(0) 推荐(0)
051-144
摘要：View the Exhibit and examine the structure of the PRODUCTS table.You want to display the category with the maximum number of items.You issue the follo 阅读全文
posted @ 2017-11-30 14:35 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
051-139
摘要：Which three statements are true about multiple-row subqueries? (Choose three.)A. They can contain a subquery within a subquery.B. They can return mult 阅读全文
posted @ 2017-11-30 14:11 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
051-133
摘要：Which two statements are true regarding subqueries? (Choose two.)(关于子查询哪两句话是正确的？)A. A subquery can retrieve zero or more rows.（子查询能检索 0 行或多行）B. Only t 阅读全文
posted @ 2017-11-30 13:38 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0)
051-127
摘要：Examine the data in the CUSTOMERS table: CUSTNO CUSTNAME CITY You want to list all cities that have more than one customer along with the customer det 阅读全文
posted @ 2017-11-29 18:20 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
oracle 函数
摘要：1.coalesce（expr1,expr2........) 返回从左起始第一个不为空的值，如果所有参数都为空，那么返回空值。2.NULLIF(expr1,expr2)如果expr1等于expr2返回null否则返回expr1.3.DUMP函数用来判断数据类型select dump(1111) f 阅读全文
posted @ 2017-11-28 16:47 巴啦啦大魔王 阅读(154) 评论(0) 推荐(0)
oracle索引
摘要：索引两大类 B树索引和位图索引。1.当表被删除后，对应的索引也自动删除 2.表中的非延迟 PRIMARY KEY 或者 UNIQUE KEY 约束自动创建一个唯一索引 3.对于执行的每一个 DML 操作，对应的索引也自动更新 4.FOREIGN KEY 和 NOT NULL、 CHECK 约束都不创 阅读全文
posted @ 2017-11-27 15:03 巴啦啦大魔王 阅读(156) 评论(0) 推荐(0)
oracle序列
摘要：序列的两个伪列：currval 序列的当前值，反复引用时该值不变。nextval序列的下一个值，每次引用按步长自增。 CREATE SEQUENCE se1INCREMENT BY 10START WITH 50MAXVALUE 100CYCLENOCACHE 第一次要引用一下 nextval伪列s 阅读全文
posted @ 2017-11-27 14:35 巴啦啦大魔王 阅读(173) 评论(0) 推荐(0)
oracle建表语句
摘要：create table 表名 (字段名 --长度);一般表名要以字母开头表名的长度为 1-30 个字符 ，可以包含字母、数字下划线(_),美元符($),井字号(#) 表的列最多为 1000 个 ，有 DEFAULT 值的列可以存储空值 相同的 schema 里，表和视图的名字不能相同 1）表，视图 阅读全文
posted @ 2017-11-24 17:27 巴啦啦大魔王 阅读(496) 评论(0) 推荐(0)
oracle数据类型
摘要：字符型char 固定字符，最长2000个--char默认值是char(1)varchar2 可变长字符，最长4000个,最小值是1--VARCHAR2 数据类型必须要指定 size nchar/nvarchar2 NCHAR/NVARCHAR2类型的列使用国家字符集raw和long raw 固定/可 阅读全文
posted @ 2017-11-24 15:46 巴啦啦大魔王 阅读(209) 评论(0) 推荐(0)
oracle转义符
摘要：1.q select q''a%'' from dual; '为分隔符--注意当使用单引号为分隔符时，被转义的字符串中与转义单引号相连的不能时单引号--例:select q''xxx'' from dual;这其中x不能为单引号select q'!a'!' from dual;!为分隔符 开始分隔符 阅读全文
posted @ 2017-11-24 14:11 巴啦啦大魔王 阅读(283) 评论(0) 推荐(0)
oraclle 复合查询
摘要：Union(并集去重排序)，对两个结果集进行并集操作，重复行只取一次，同时进行默认规则的排序； Union All(并集不去重不排序)，对两个结果集进行并集操作，包括所有重复行，不进行排序； Intersect(交集去重排序)，对两个结果集进行交集操作，重复行只取一次，同时进行默认规则的排序，不忽略 阅读全文
posted @ 2017-11-24 11:38 巴啦啦大魔王 阅读(198) 评论(0) 推荐(0)
051-5
摘要：Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three)A. SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;B. SELECT TO_CHAR(18 阅读全文
posted @ 2017-11-24 10:57 巴啦啦大魔王 阅读(194) 评论(0) 推荐(0)
转载 ORA-21561: 生成 OID 失败
摘要：SQLPLUS登陆数据库的时候，无法登录到数据库，只有shutdown abort一个命令能有效果，其余命令均无效，看出问题前后台提示：ORA-21561: OID generation failed ，然后就通知我密码不对，但我用PL/SQL是可以进到数据库里，查了半天竟然是/etc/hosts文 阅读全文
posted @ 2017-11-22 10:48 巴啦啦大魔王 阅读(892) 评论(0) 推荐(0)
053-附加题1
摘要：What happens if you shutdown abort ASM instance?A. The RDBMSs connected will shutdown abort tooB. CLUSTER SERVICE will shutdownC. ASM wil do instance 阅读全文
posted @ 2017-11-17 13:40 巴啦啦大魔王 阅读(155) 评论(0) 推荐(0)
053-159
摘要：Which package provides API's for the SQL Tuning Advisor?A. DBMS_MONITORB. DBMS_STATSC. DBMS_SQLTUNED. DBMS_ADVISOR 运行 SQL 调整顾问程序运行 SQL Tuning Advisor 阅读全文
posted @ 2017-11-17 13:32 巴啦啦大魔王 阅读(122) 评论(0) 推荐(0)
053-509
摘要：Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)A. A single SQL statement provided by a userB. An ex 阅读全文
posted @ 2017-11-17 13:25 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
053-298
摘要：While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available.What would th 阅读全文
posted @ 2017-11-17 13:23 巴啦啦大魔王 阅读(145) 评论(0) 推荐(0)
053-255
摘要：Which two statements about the SQL Management Base (SMB) are true? (Choose two.)A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It 阅读全文
posted @ 2017-11-17 13:21 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
053-253
摘要：You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL planbaseline. The STA generates a SQL profile for the SQL sta 阅读全文
posted @ 2017-11-17 13:19 巴啦啦大魔王 阅读(175) 评论(0) 推荐(0)
053-493
摘要：Which three statements about performance analysis by SQL Performance Analyzer are true?(Choose three.)A. It detects changes in SQL execution plans.B. 阅读全文
posted @ 2017-11-17 13:18 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
053-487
摘要：When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.Which two statements describe the 阅读全文
posted @ 2017-11-17 11:37 巴啦啦大魔王 阅读(166) 评论(0) 推荐(0)
053-610
摘要：Which of the following advisors is run in every maintenance window by the auto-task system?A.The Memory AdvisorB.The SQL Tuning AdvisorC.The Undo Advi 阅读全文
posted @ 2017-11-17 11:21 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
053-61
摘要：Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance impr 阅读全文
posted @ 2017-11-17 11:13 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
053-44
摘要：You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance o 阅读全文
posted @ 2017-11-17 11:11 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
053-270
摘要：Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)A. Segment AdvisorB. SQL Access Adviso 阅读全文
posted @ 2017-11-17 11:10 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
053-123
摘要：What two statements are true regarding the recommendations received from the SQL Access Advisor?(Choose two.)A. It cannot generate recommendations tha 阅读全文
posted @ 2017-11-17 10:59 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
053-232
摘要：What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)A. selection of SQL plan baselinesB. part 阅读全文
posted @ 2017-11-17 10:58 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
053-141
摘要：Exhibit: View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TA 阅读全文
posted @ 2017-11-17 10:23 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)
053-101
摘要：Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A. The user has dropped an important table that needs to 阅读全文
posted @ 2017-11-17 10:21 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0)
053-132
摘要：You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but yo 阅读全文
posted @ 2017-11-17 10:20 巴啦啦大魔王 阅读(162) 评论(0) 推荐(0)
053-113
摘要：Which statement is true regarding virtual private catalogs?A. A virtual private catalog owner can create a local stored script, and have read/write ac 阅读全文
posted @ 2017-11-17 10:19 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
053-262
摘要：In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)A. partitioning recommendations B. statistics colle 阅读全文
posted @ 2017-11-17 10:17 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0)
053-294
摘要：Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?A. Segment 阅读全文
posted @ 2017-11-17 10:15 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
053-494
摘要：Which statement about Automatic Memory Management with Oracle 11g is true?A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or 阅读全文
posted @ 2017-11-17 10:14 巴啦啦大魔王 阅读(137) 评论(0) 推荐(0)
053-60
摘要：For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. 阅读全文
posted @ 2017-11-17 09:17 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
053-105
摘要：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 巴啦啦大魔王 阅读(82) 评论(0) 推荐(0)
053-102
摘要：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 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)
053-218
摘要：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 巴啦啦大魔王 阅读(73) 评论(0) 推荐(0)
053-208
摘要：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 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
053-211
摘要：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 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0)
053-56
摘要：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 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0)
053-53
摘要：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 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
053-236
摘要：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 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)
053-78
摘要：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 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
053-485
摘要：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 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
053-59
摘要：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 巴啦啦大魔王 阅读(85) 评论(0) 推荐(0)
053-234
摘要：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 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0)
053-295
摘要：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 巴啦啦大魔王 阅读(127) 评论(0) 推荐(0)
053-275
摘要：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 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
053-49
摘要：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 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0)
053-3
摘要：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 巴啦啦大魔王 阅读(97) 评论(0) 推荐(0)
053-204
摘要：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 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0)
053-491
摘要：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 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
053-205
摘要：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 巴啦啦大魔王 阅读(97) 评论(0) 推荐(0)
053-57
摘要：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 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0)
053-149
摘要：You perform a backup using the following BACKUP command:RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;Which statement is true of this command?A. A dif 阅读全文
posted @ 2017-11-16 15:58 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
053-47
摘要：You issue the following command on the RMAN prompt.REPORT NEED BACKUP DAYS 5;Which statement is true about executing this command?A. It will display a 阅读全文
posted @ 2017-11-16 15:57 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
053-150
摘要：You have enabled backup optimization in RMAN. You issue the following RMAN command toconfigure a redundancy-based retention policy:CONFIGURE RETENTION 阅读全文
posted @ 2017-11-16 15:55 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
053-4
摘要：Which three components does the Scheduler use for managing tasks within the Oracle environment?(Choose three.)A. a jobB. a programC. a scheduleD. a PL 阅读全文
posted @ 2017-11-16 15:53 巴啦啦大魔王 阅读(122) 评论(0) 推荐(0)
053-151
摘要：Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)A. MEMORY_TARGET can be increased up to the value 阅读全文
posted @ 2017-11-16 15:13 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
053-272
摘要：You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;What will be the outcome 阅读全文
posted @ 2017-11-16 15:11 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
053-152
摘要：You are performing incomplete recovery using RMAN. You execute the following RUN block:RUN{SET UNTIL SCN 1107600;RESTORE DATABASE;RECOVER DATABASE;}Wh 阅读全文
posted @ 2017-11-16 15:06 巴啦啦大魔王 阅读(150) 评论(0) 推荐(0)
053-288
摘要：You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You 阅读全文
posted @ 2017-11-16 15:03 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
053-153
摘要：You are managing an ASM instance. You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK dis 阅读全文
posted @ 2017-11-16 15:02 巴啦啦大魔王 阅读(151) 评论(0) 推荐(0)
053-281
摘要：You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perf 阅读全文
posted @ 2017-11-16 15:01 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
053-154
摘要：A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message: Which is the recommended sequ 阅读全文
posted @ 2017-11-16 14:59 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
053-155
摘要：Observe the structure of the table employees: The table contains 8475 records. One of the employees wants to know the names of all employees of the co 阅读全文
posted @ 2017-11-16 14:56 巴啦啦大魔王 阅读(85) 评论(0) 推荐(0)
053-143
摘要：Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)A. Database must be running in archivelog mode.B. Automatic undo manage 阅读全文
posted @ 2017-11-16 14:54 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
053-504&213
摘要：View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you exec 阅读全文
posted @ 2017-11-16 14:52 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
053-230
摘要：You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEB 阅读全文
posted @ 2017-11-16 14:46 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
053-156
摘要：What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?A. The number of DBWR processes increasesB. The number of ASMB processes i 阅读全文
posted @ 2017-11-16 14:44 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)
053-31
摘要：Which two statements are correct about database transportation? (Choose two.)A. The source and target platforms must be the sameB. Redo logs, control 阅读全文
posted @ 2017-11-16 14:42 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
053-157
摘要：The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?A. The Oracle database will perform block checki 阅读全文
posted @ 2017-11-16 14:41 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
053-496
摘要：Which two statements are true regarding an Automatic Storage Management (ASM) instance?(Choose two.)A. As ASM instance mounts an ASM control fileB. An 阅读全文
posted @ 2017-11-16 14:39 巴啦啦大魔王 阅读(180) 评论(0) 推荐(0)
053-128
摘要：You want to track and store all transactional changes to a table over its lifetime. To accomplish thistask, you enabled Flashback Data Archive with th 阅读全文
posted @ 2017-11-16 14:38 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0)
053-167
摘要：View the Exhibits exhibit1 and exhibit2.Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are re 阅读全文
posted @ 2017-11-16 14:36 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0)
053-250
摘要：You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.The bulk load operation must also b 阅读全文
posted @ 2017-11-16 14:34 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)
053-674
摘要：View the Exhibit to observe the error.You receive this error regularly and have to shutdown the database instance to overcome the error.Automatic Shar 阅读全文
posted @ 2017-11-16 14:32 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
053-158
摘要：You create two resource plans, one for data warehouse loading jobs at night and the other forapplication jobs at day time. You want the resource plans 阅读全文
posted @ 2017-11-16 14:31 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
053-268
摘要：You are using Recovery Manager (RMAN) for backup and recovery operations with a recoverycatalog. You have been taken database backups every evening. O 阅读全文
posted @ 2017-11-16 14:29 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0)
053-160
摘要：Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)A. It's only supported for the backups performed on the t 阅读全文
posted @ 2017-11-16 14:26 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
053-673
摘要：In Recovery Manager (RMAN), you are taking image copies of the datafiles of your productiondatabase and rolling them forward as regular intervals. You 阅读全文
posted @ 2017-11-16 14:25 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
053-510
摘要：You executed the following command in Recovery Manager (RMAN):RMAN> REPORT NEED BACKUP days 3;What is the output of this command?A. a list of files th 阅读全文
posted @ 2017-11-16 14:21 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
053-161
摘要：You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your product 阅读全文
posted @ 2017-11-16 14:19 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
053-16
摘要：Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start th 阅读全文
posted @ 2017-11-16 14:17 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0)
053-20
摘要：View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based 阅读全文
posted @ 2017-11-16 14:15 巴啦啦大魔王 阅读(63) 评论(0) 推荐(0)
053-271
摘要：Examine the output of the query that you executed to list the objects in the recycle bin : You verified that no table named SALES_TAB exists in the sc 阅读全文
posted @ 2017-11-16 14:12 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
053-235
摘要：The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration.You executed the following command to startup the Automati 阅读全文
posted @ 2017-11-16 14:09 巴啦啦大魔王 阅读(219) 评论(0) 推荐(0)
053-277
摘要：The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST an 阅读全文
posted @ 2017-11-16 14:08 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
053-38
摘要：The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL T 阅读全文
posted @ 2017-11-16 14:06 巴啦啦大魔王 阅读(90) 评论(0) 推荐(0)
053-212
摘要：Note the following parameters settings in your database:SGA_MAX_SIZE = 1024M SGA_TARGET = 700MDB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou issued the f 阅读全文
posted @ 2017-11-16 14:05 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
053-69
摘要：The EMP table exists in your schema. You want to execute the following query:SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MIN 阅读全文
posted @ 2017-11-16 14:02 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
053-10
摘要：Consider the following scenario for your database:-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most rece 阅读全文
posted @ 2017-11-16 14:00 巴啦啦大魔王 阅读(63) 评论(0) 推荐(0)
053-242
摘要：You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain aseparation of responsibilities along with a consolidation of 阅读全文
posted @ 2017-11-16 13:58 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
053-227
摘要：You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these 阅读全文
posted @ 2017-11-16 13:57 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
053-671
摘要：Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met bef 阅读全文
posted @ 2017-11-16 13:55 巴啦啦大魔王 阅读(78) 评论(0) 推荐(0)
053-489
摘要：For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A.viewsB.fixed tablesC.heap tablesD.extern 阅读全文
posted @ 2017-11-16 13:51 巴啦啦大魔王 阅读(71) 评论(0) 推荐(0)
053-670
摘要：After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best optio 阅读全文
posted @ 2017-11-16 13:49 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0)
053-669
摘要：User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash b 阅读全文
posted @ 2017-11-16 13:48 巴啦啦大魔王 阅读(127) 评论(0) 推荐(0)
053-668
摘要：Examine the following RMAN script:RMAN> run {debug on;allocate channel c1 type disk;backup datafile 5;}Which statement describes the purpose of the sc 阅读全文
posted @ 2017-11-16 13:46 巴啦啦大魔王 阅读(95) 评论(0) 推荐(0)
053-667
摘要：What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?A. An upper limit on how far you can flash back the database, depending on the informa 阅读全文
posted @ 2017-11-16 13:45 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
053-666
摘要：You are working in an online transaction processing (OLTP) environment. You use theFLASHBACKTABLE command to flash back the CUSTOMERS table. Before ex 阅读全文
posted @ 2017-11-16 13:43 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
053-665
摘要：Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)A. The ADR base keeps all diagnostic information in binary 阅读全文
posted @ 2017-11-16 13:42 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
053-664
摘要：You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are tru 阅读全文
posted @ 2017-11-16 13:41 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
053-663
摘要：Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is ru 阅读全文
posted @ 2017-11-16 13:39 巴啦啦大魔王 阅读(132) 评论(0) 推荐(0)
053-662
摘要：To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change trackin 阅读全文
posted @ 2017-11-16 13:38 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
053-661
摘要：View the Exhibit and examine the output. You execute the following RMAN command to perform thebackup operation:RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE 阅读全文
posted @ 2017-11-16 13:36 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
053-660
摘要：You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVE 阅读全文
posted @ 2017-11-16 13:35 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0)
053-146
摘要：You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is conf 阅读全文
posted @ 2017-11-16 13:34 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0)
053-659
摘要：Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)A. ALTER DISKGROUP misc MOUNT;B. ALTER DISKGROUP misc DR 阅读全文
posted @ 2017-11-16 13:32 巴啦啦大魔王 阅读(180) 评论(0) 推荐(0)
053-658
摘要：Indentify two advantages of using recovery catalog instead of the control file of the database inRecovery Manager (RMAN). (Choose two.)A. You can use 阅读全文
posted @ 2017-11-16 13:30 巴啦啦大魔王 阅读(154) 评论(0) 推荐(0)
053-657
摘要：The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you 阅读全文
posted @ 2017-11-16 13:28 巴啦啦大魔王 阅读(168) 评论(0) 推荐(0)
053-656
摘要：The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN sessi 阅读全文
posted @ 2017-11-16 13:27 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
053-654
摘要：You are using Recovery Manager (RMAN) with a recovery catalog to back up your productiondatabase. The backups and the archived redo log files are copi 阅读全文
posted @ 2017-11-16 13:25 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
053-655
摘要：Examine the following ALTER command:SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;What is the purpose of the command?A. It cancels all pending disk drops 阅读全文
posted @ 2017-11-16 13:25 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
053-652
摘要：Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the 阅读全文
posted @ 2017-11-16 13:18 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
053-651
摘要：The user SYS creates a job by using the following command: Which two statements are true about the job that was created by the preceding command? (Cho 阅读全文
posted @ 2017-11-16 13:17 巴啦啦大魔王 阅读(160) 评论(0) 推荐(0)
053-650
摘要：Which three tasks can be performed using a duplicate database? (Choose three.)A. Testing the backup and recovery proceduresB. Testing the upgrade of a 阅读全文
posted @ 2017-11-16 13:16 巴啦啦大魔王 阅读(78) 评论(0) 推荐(0)
053-649
摘要：Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK 'ORCL: FRA3' NAME misc1, 'ORCL: FR 阅读全文
posted @ 2017-11-16 11:41 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
053-648
摘要：Note the following statements that use flashback technology: 1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLAS 阅读全文
posted @ 2017-11-16 11:40 巴啦啦大魔王 阅读(91) 评论(0) 推荐(0)
053-647
摘要：You executed the following commands in a database session: What could have caused the recycle bin to clean up?A. There is demand for space from the ne 阅读全文
posted @ 2017-11-16 11:33 巴啦啦大魔王 阅读(160) 评论(0) 推荐(0)
053-646
摘要：View the exhibit and examine the TRANS table's storage information. After a massive deleteoperation, you executed the following statement to shrink th 阅读全文
posted @ 2017-11-16 11:31 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
053-645
摘要：Which two statements are true about a job chain? (Choose two.)A. A job chain can contain a nested chain of jobs.B. The jobs in a job chain cannot have 阅读全文
posted @ 2017-11-16 11:28 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
053-644
摘要：View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).Why does the 阅读全文
posted @ 2017-11-16 11:26 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
053-643
摘要：View the Exhibit.You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage m 阅读全文
posted @ 2017-11-16 11:25 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
053-642
摘要：In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While i 阅读全文
posted @ 2017-11-16 11:21 巴啦啦大魔王 阅读(125) 评论(0) 推荐(0)
053-641
摘要：Which three functions are performed by the SQL Tuning Advisor? (Choose three.)A. Building the SQL profileB. Recommending optimization of materialized 阅读全文
posted @ 2017-11-16 11:20 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
053-640
摘要：Examine the parameter setting in your database: Which statement is correct about the database?A. Automatic memory management is disabled because PGA_A 阅读全文
posted @ 2017-11-16 11:17 巴啦啦大魔王 阅读(79) 评论(0) 推荐(0)
053-639
摘要：You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?A. Set MEMORY_TARGET to zeroB. Set the 阅读全文
posted @ 2017-11-16 11:12 巴啦啦大魔王 阅读(104) 评论(0) 推荐(0)
053-638
摘要：Which three statements are true about persistent configuration? (Choose three.)A. A user cannot set privileges on the persistent lightweight jobsB. Pe 阅读全文
posted @ 2017-11-16 11:08 巴啦啦大魔王 阅读(74) 评论(0) 推荐(0)
053-637
摘要：Which three statements are true about windows? (Choose three.)A. Only one window can be open at any given timeB. Consumer groups are associated with w 阅读全文
posted @ 2017-11-16 11:06 巴啦啦大魔王 阅读(83) 评论(0) 推荐(0)
053-636
摘要：Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)A. Backup 阅读全文
posted @ 2017-11-16 11:05 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
053-635
摘要：While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space 阅读全文
posted @ 2017-11-16 11:02 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
053-634
摘要：Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which too 阅读全文
posted @ 2017-11-16 10:58 巴啦啦大魔王 阅读(74) 评论(0) 推荐(0)
053-633
摘要：Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform? (Choose three. 阅读全文
posted @ 2017-11-16 10:56 巴啦啦大魔王 阅读(126) 评论(0) 推荐(0)
053-632
摘要：Note the following parameter settings: Which setting is NOT allowed? A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;C. 阅读全文
posted @ 2017-11-16 09:02 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0)
053-679
摘要：Which mode of database shutdown requires an instance recovery at the time of the next database startup?A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONAL 数据库在关 阅读全文
posted @ 2017-11-15 17:47 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
053-631
摘要：View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN> BACKUP DATABASE FILE 阅读全文
posted @ 2017-11-15 17:44 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
053-630
摘要：Which two statements are true about encrypting RMAN backup? (Choose two.)A. The transparent encryption of backups uses the encryption walletB. The dat 阅读全文
posted @ 2017-11-15 17:41 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
053-629
摘要：Which option is best practice for creating a recovery catalog owner in the catalog database? A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to t 阅读全文
posted @ 2017-11-15 17:40 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0)
053-628
摘要：The database is running in the ARCHIVELOG mode. It has three redo log groups with one membereach. One of the redo log groups has become corrupted. You 阅读全文
posted @ 2017-11-15 17:39 巴啦啦大魔王 阅读(76) 评论(0) 推荐(0)
053-627
摘要：In Recovery Manager (RMAN), you are taking image copies of the data files of your productiondatabase and rolling them forward at regular intervals. Yo 阅读全文
posted @ 2017-11-15 17:37 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
053-626
摘要：Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?A. New chan 阅读全文
posted @ 2017-11-15 17:34 巴啦啦大魔王 阅读(179) 评论(0) 推荐(0)
053-625
摘要：Your database is running in ARCHIVELOG mode.One of the data files,USERDATA01.dbf,inthe USERS tablespace is damaged and you need to recover the file un 阅读全文
posted @ 2017-11-15 17:20 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
053-624
摘要：You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the 阅读全文
posted @ 2017-11-15 17:17 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
053-623
摘要：You issued the following commands to configure setting in RMAN;RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sb 阅读全文
posted @ 2017-11-15 17:16 巴啦啦大魔王 阅读(158) 评论(0) 推荐(0)
053-622
摘要：You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What 阅读全文
posted @ 2017-11-15 17:14 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
053-678
摘要：Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)A.Flash recovery area must be definedB.Undo retention guarantee 阅读全文
posted @ 2017-11-15 17:13 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
053-621
摘要：You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed u 阅读全文
posted @ 2017-11-15 17:09 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
053-620
摘要：You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two sce 阅读全文
posted @ 2017-11-15 17:07 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
053-619
摘要：View the Exhibit and note the contents of V$DIAG_INFO.Which statement is true about the ADR? A. The text alert log file will be available in Diag Trac 阅读全文
posted @ 2017-11-15 17:06 巴啦啦大魔王 阅读(78) 评论(0) 推荐(0)
053-618
摘要：You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO 阅读全文
posted @ 2017-11-15 17:04 巴啦啦大魔王 阅读(86) 评论(0) 推荐(0)
053-617
摘要：A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP 阅读全文
posted @ 2017-11-15 17:03 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
053-616
摘要：The EMP table has some discrepancy in data entry with a particular employee ID. You execute thequery as shown in the Exhibit to retrieve all versions 阅读全文
posted @ 2017-11-15 17:01 巴啦啦大魔王 阅读(71) 评论(0) 推荐(0)
053-615
摘要：Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed 阅读全文
posted @ 2017-11-15 16:59 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
053-614
摘要：Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?(Choose three.)A. Alert log fi 阅读全文
posted @ 2017-11-15 16:58 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
053-613
摘要：You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?A. Enable the f 阅读全文
posted @ 2017-11-15 16:11 巴啦啦大魔王 阅读(152) 评论(0) 推荐(0)
053-612
摘要：Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking 阅读全文
posted @ 2017-11-15 16:10 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
053-611
摘要：To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:SQL> ALTER TABLESPACE 阅读全文
posted @ 2017-11-15 16:09 巴啦啦大魔王 阅读(97) 评论(0) 推荐(0)
053-131
摘要：Exhibit: View the Exhibit to examine the parameter values. You are planning to set the value for theMEMORY_TARGET parameter of your database instance. 阅读全文
posted @ 2017-11-15 16:07 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
053-265
摘要：View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the PRODCAT_VW view. PRODCAT_VW is used in the GET_DATA p 阅读全文
posted @ 2017-11-15 16:04 巴啦啦大魔王 阅读(78) 评论(0) 推荐(0)
053-264
摘要：Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.) A. stored scrip 阅读全文
posted @ 2017-11-15 16:02 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
053-609
摘要：Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';ENAME SAL JAMES 1050SQL> UPDATE emp SET sal=sal+sa 阅读全文
posted @ 2017-11-15 16:00 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
053-608
摘要：You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the b 阅读全文
posted @ 2017-11-15 15:58 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
053-607
摘要：Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance term 阅读全文
posted @ 2017-11-15 15:57 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
053-134
摘要：You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 阅读全文
posted @ 2017-11-15 15:52 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)
053-606
摘要：Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN (choose all that apply)A. Limitin 阅读全文
posted @ 2017-11-15 15:48 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0)
053-605
摘要：What two are the prerequisites for enabling Flashback Database? (Choose two)A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT 阅读全文
posted @ 2017-11-15 15:47 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
053-604
摘要：You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that 阅读全文
posted @ 2017-11-15 15:46 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
053-603
摘要：While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options t 阅读全文
posted @ 2017-11-15 15:44 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
053-602
摘要：On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.Which option must you use to check wheth 阅读全文
posted @ 2017-11-15 15:41 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
053-133
摘要：You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)A. The backup contains 阅读全文
posted @ 2017-11-15 15:40 巴啦啦大魔王 阅读(68) 评论(0) 推荐(0)
053-601
摘要：You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prere 阅读全文
posted @ 2017-11-15 15:36 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
053-100
摘要：Examine the following command that is used to duplicate a database on the same host:RMAN> RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLI 阅读全文
posted @ 2017-11-15 15:35 巴啦啦大魔王 阅读(72) 评论(0) 推荐(0)
053-99
摘要：View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which r 阅读全文
posted @ 2017-11-15 15:34 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
053-98
摘要：You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/ 阅读全文
posted @ 2017-11-15 15:31 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
053-672
摘要：You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11g database. The Prod1, Prod2 and Prod3 Oracle Database 10 阅读全文
posted @ 2017-11-15 15:30 巴啦啦大魔王 阅读(114) 评论(0) 推荐(0)
053-675
摘要：Which two client requests are captured during database replay Capture? (Choose two)A. Flashback queriesB. Shared server requestsC. Login and logoff ac 阅读全文
posted @ 2017-11-15 15:26 巴啦啦大魔王 阅读(152) 评论(0) 推荐(0)
053-97
摘要：The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the 阅读全文
posted @ 2017-11-15 15:24 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
053-96
摘要：Examine the following command:SQL> ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?A. The 阅读全文
posted @ 2017-11-15 15:22 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
053-95
摘要：Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days a 阅读全文
posted @ 2017-11-15 15:21 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
053-94
摘要：Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions: What c 阅读全文
posted @ 2017-11-15 15:18 巴啦啦大魔王 阅读(180) 评论(0) 推荐(0)
053-93
摘要：The database is configured in ARCHIVELOG mode and regular complete database backups are taken.The loss of which two types of files may require a recov 阅读全文
posted @ 2017-11-15 15:16 巴啦啦大魔王 阅读(148) 评论(0) 推荐(0)
053-92
摘要：You observed the following output for a user session: What do you infer from the preceding output?A. Resumable set for session with sid 18B. The user 阅读全文
posted @ 2017-11-15 15:14 巴啦啦大魔王 阅读(174) 评论(0) 推荐(0)
053-91
摘要：Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process wou 阅读全文
posted @ 2017-11-15 15:12 巴啦啦大魔王 阅读(259) 评论(0) 推荐(0)
053-90
摘要：View the exhibit and examine the output. Which statement can be an inference from the output?Exhibit: A. The FRA disk group has an asynchronous I/O bo 阅读全文
posted @ 2017-11-15 15:10 巴啦啦大魔王 阅读(209) 评论(0) 推荐(0)
053-89
摘要：You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are c 阅读全文
posted @ 2017-11-15 15:06 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
053-88
摘要：In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the se 阅读全文
posted @ 2017-11-15 15:04 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
053-87
摘要：You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two).A. T 阅读全文
posted @ 2017-11-15 15:02 巴啦啦大魔王 阅读(85) 评论(0) 推荐(0)
053-86
摘要：Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup 阅读全文
posted @ 2017-11-15 15:00 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
053-677
摘要：What are the prerequisites for performing flashback transactions? (Choose all that apply)A.Supplemental log must be enabledB.Supplemental log must be 阅读全文
posted @ 2017-11-15 14:56 巴啦啦大魔王 阅读(122) 评论(0) 推荐(0)
053-676
摘要：Which command creates an image copy?A. backup as copyB. backup copyC. copy as backupD. copy back 阅读全文
posted @ 2017-11-15 14:52 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
053-712
摘要：Why does the number of blocks for the table remain the sale after the shrink operation?A.Because the table did not contain migrated or chained rows B. 阅读全文
posted @ 2017-11-15 14:26 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
053-711
摘要：The following command is executed to shut down an Automatic Storage Management (ASM) instance:SQL>SHUTDOWN ABORT;Which two statements describe the con 阅读全文
posted @ 2017-11-15 14:15 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
053-710
摘要：You executed the following commands in a database session: Which statement is true about the contents of the recycle bin in this situation?A.They rema 阅读全文
posted @ 2017-11-15 14:14 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
053-709
摘要：A database has three online redo log groups with one member each. A redo log member with the status ACTICE is damages while the database is running.Wh 阅读全文
posted @ 2017-11-15 14:12 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)