2013年10月_Riveore

12月 11月 10月 09月

原创 OCP-1Z0-053-V12.02-626题

626.Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)? A. New channels for restore and recovery tasks B. New

2013-10-31 13:27:33 7278

原创 OCP-1Z0-053-V12.02-365题

365.Which of the following restrictions are not true with respect to tablespace point-in-time recovery? (Choose all that apply.) A. The target database must be in NOARCHIVELOG mode. B. No backup is

2013-10-31 13:13:16 5772 1

原创 OCP-1Z0-053-V12.02-366题

366.If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR? A. TS_OBJECTS_TO_BE_DROPPED B. TS_PTTR_OBJECT_DROPPED C. TS_PITR_

2013-10-31 12:46:23 4037

原创 OCP-1Z0-053-V12.02-367题

367.Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which state

2013-10-31 11:57:49 4298

原创 OCP-1Z0-053-V12.02-16题

16.Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_T

2013-10-31 11:27:29 8742

原创 OCP-1Z0-053-V12.02-21题

21.You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose a

2013-10-31 11:13:29 9114 1

原创 OCP-1Z0-053-V12.02-368题

368.When issuing the duplicate database command, you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter? A. To indicate the location of the auxiliary-instance online

2013-10-31 10:53:01 4556

原创 OCP-1Z0-053-V12.02-356题

356.Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database? A. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 cre

2013-10-31 10:42:50 6128

原创 OCP-1Z0-053-V12.02-361题

361.When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location? A. log_file_name_convert B. con

2013-10-31 10:16:50 4464

原创 OCP-1Z0-053-V12.02-355题

355.When youre performing active database duplication, a backup of what kind is required? A. A current RMAN backup-set backup is required. B. No backup is required. C. An RMAN image backup is requi

2013-10-31 09:52:29 4779 1

原创 OCP-1Z0-053-V12.02-289题

289.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same

2013-10-31 09:39:59 7041

原创 OCP-1Z0-053-V12.02-100题

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; DUPLICATE TARGET DATABASE TO auxdb SKIP REA

2013-10-31 09:33:02 10472 1

原创 OCP-1Z0-053-V12.02-101题

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 be recovered. B. The database files are co

2013-10-31 09:21:34 8388

原创 OCP-1Z0-052-V8.02-88题

88. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) A.The database files are corrupted when the database is open. B.The user has dropped an important t

2013-10-31 09:17:32 7922

原创 OCP-1Z0-052-V8.02-89题

89. Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.) A.failure when no standby database is configured B.failure because a data file is ren

2013-10-31 09:13:29 10291

原创 OCP-1Z0-052-V8.02-90题

90. Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.) A.Recover from failures in the RAC environment. B.Diagnose and repair a data file corruption online. C.D

2013-10-31 09:05:04 9625

原创 OCP-1Z0-053-V12.02-243题

243.Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.) A. failures because a data file is renamed by error B. failures when no standby datab

2013-10-31 08:52:09 7414

原创 OCP-1Z0-053-V12.02-260题

260.Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.) A. Diagnose and repair a data file corruption offline. B. Diagnose and repair a data file corruption online. C

2013-10-31 08:47:45 5368

原创 OCP-1Z0-052-V8.02-169题

169. You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table

2013-10-31 08:39:26 9979

原创 OCP-1Z0-052-V8.02-175题

175. What can you achieve by implementing reverse key index? A.Reverse the bytes of each column indexed including the row ID. B.Store a bitmap for each key value instead of a list of row IDs in the

2013-10-31 08:33:06 11785

原创 OCP-1Z0-052-V8.02-179题

179. The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single product and every

2013-10-30 14:54:43 9791

原创 OCP-1Z0-052-V8.02-181题

181. View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you recompile t

2013-10-30 14:23:57 8987 1

原创 OCP-1Z0-052-V8.02-182题

182. Which two statements are true regarding a PL/SQL package body? (Choose two.) A.It cannot be created without a package specification. B.It cannot invoke subprograms defined in other packages. C

2013-10-30 14:18:58 9438

原创 OCP-1Z0-052-V8.02-183题

183. The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users: CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dna

2013-10-30 14:13:49 10896 3

原创 OCP-1Z0-052-V8.02-184题

184. You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Y

2013-10-30 13:59:53 7450

原创 OCP-1Z0-052-V8.02-47题

47. Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TY

2013-10-30 12:46:04 10394

原创 Oracle DB 管理数据库的空间

• 描述4 KB 扇区磁盘的概念及使用 • 使用可移动表空间 • 描述可移动表空间的概念数据库存储数据库存储数据库包括物理结构和逻辑结构。由于物理结构和逻辑结构是分开的，因此管理数据的物理存储时不会影响对逻辑存储结构的访问。磁盘是数据库的主要存储介质，目前主要有512 字节的扇区，而拥有4 KB 大扇区的磁盘即将上市，它们可以用较低的开销提供更高

2013-10-30 11:42:42 2994

原创 OCP-1Z0-052-V8.02-187题

187. Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.) A.Avoid coding unnecessary long-running transactions. B.

2013-10-30 11:11:30 8736

原创 Oracle DB 复制数据库

• 列出创建副本数据库的目的 • 选择用于复制数据库的方法 • 使用RMAN 复制数据库 • 使用RMAN 备份复制数据库 • 基于正在运行的实例复制数据库使用副本数据库 • 使用副本数据库可执行以下任务： – 测试备份和恢复过程 – 通过创建导出文件并将对象导入生产数据库来恢复对象 • 创建副本数据库： – 使用RMAN 的DUPLICATE命令 –

2013-10-30 10:55:43 11901 4

原创 OCP-1Z0-052-V8.02-188题

188. You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not pe

2013-10-30 10:55:25 9830

原创 OCP-1Z0-052-V8.02-66题

66. You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.) A.Disable automatic checkpoint tuning. B.Check t

2013-10-30 10:20:41 9790

原创 OCP-1Z0-052-V8.02-44题

44. Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the pe

2013-10-30 10:14:09 10635

原创 Oracle DB 使用调度程序自动执行任务

• 使用调度程序来简化管理任务 • 创建作业、程序和调度 • 监视作业执行 • 使用基于时间或基于事件的调度来执行调度程序作业 • 描述窗口、窗口组、作业类和使用者组的用途 • 使用电子邮件通知 • 使用作业链来执行一系列相关任务 • 描述远程系统上的调度程序作业 • 使用高级调度程序概念来区分作业的优先级简化管理任务 Oracle 环境中的许

2013-10-30 09:59:33 9020 3

原创 OCP-1Z0-053-V12.02-497题

497.You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database:

2013-10-30 09:16:52 5650

原创 OCP-1Z0-053-V12.02-513题

513.What RMAN command is used to execute a tablespace point-in-time recovery? A. recover B. duplicate C. restore D. copy E. None of the above Answer: A 答案解析：参考：http://blog.csdn.net/rlhua/arti

2013-10-30 09:15:09 3870

原创 OCP-1Z0-053-V12.02-650题

650.Which three tasks can be performed using a duplicate database? (Choose three.) A. Testing the backup and recovery procedures B. Testing the upgrade of an Oracle database to a new release C. Tes

2013-10-30 09:07:21 6423

原创 OCP-1Z0-053-V12.02-680题

680.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database? (Choose Two) A.Creating the control file for the duplicate databa

2013-10-30 08:50:17 8451

原创 OCP-1Z0-052-V8.02-42题

42. Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false'); Which statement describes the effect of the above command? A.Automatic statistics collection is stop

2013-10-30 00:30:10 11550 1

原创 OCP-1Z0-052-V8.02-130题

130. Which two statements are true regarding listeners? (Choose two.) A.Listeners use only the TCP/IP protocol. B.Multiple listener processes can run simultaneously on a host. C.Multiple database i

2013-10-30 00:25:26 9771

原创 OCP-1Z0-052-V8.02-132题

132. The tnsnames.ora file has an entry for the service alias ORCL as follows: ORCL = ( DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521)) (CONNECT_DATA = (SERVER = DED

2013-10-30 00:14:07 7720