2014年01月_Riveore

12月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创 OCP-1Z0-053-200题-187题-610

QUESTION 187Which 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 AdvisorD. The SQL Access Advi

2014-01-31 23:21:34 2930 1

原创 OCP-1Z0-053-200题-188题-369

QUESTION 188Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?A. The SGA Tuning AdvisorB. The SQL Access AdvisorC. The SQL Tuning Ad

2014-01-31 22:42:08 4058

原创 OCP-1Z0-053-200题-189题-403

QUESTION 189To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL T

2014-01-31 22:23:27 3005

原创 OCP-1Z0-053-200题-190题-405

QUESTION 190To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.

2014-01-31 22:22:10 2920

原创 OCP-1Z0-053-200题-191题-406

QUESTION 191Which of these appropriately describes the results of a manual SQL Tuning Advisor task?A. A list of SQL statements and recommendations for tuningB. A list of SQL statements that have

2014-01-31 22:12:10 3120

原创 OCP-1Z0-053-200题-193题-493

QUESTION 193Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)A. It detects changes in SQL execution plans.B. It produces results that can be

2014-01-31 22:05:21 3229

原创 OCP-1Z0-053-200题-195题-255

QUESTION 195Which 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 stores plans generated by the o

2014-01-31 11:30:47 2897

原创 OCP-1Z0-053-200题-196题-298

QUESTION 196While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that hasstale statistics available. What would the optimizer do in this situation?

2014-01-31 11:28:57 3321

原创 OCP-1Z0-053-200题-197题-509

QUESTION 197Which 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 existing SQL Tuning Set (STS)C.

2014-01-31 11:24:44 3748

原创 OCP-1Z0-053-200题-198题-44

QUESTION 198You have a very large table that your users access frequently. Which of the following advisors will recommendany indexes to improve the performance of queries against this table?A. T

2014-01-31 11:00:14 3047

原创 OCP-1Z0-053-200题-199题-159

QUESTION 199Which package provides API's for the SQL Tuning Advisor?A. DBMS_MONITORB. DBMS_STATSC. DBMS_SQLTUNED. DBMS_ADVISORAnswer: C同159题：http://blog.csdn.net/rlhua/article/details/14

2014-01-30 18:27:38 2757 1

原创 OCP-1Z0-053-200题-204题-255

QUESTION 204Which 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 stores plans generated by the o

2014-01-30 18:17:59 2861

原创 OCP-1Z0-053-200题-36题-615

QUESTION 36Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?A. Because row IDs may change

2014-01-28 15:54:25 3196

原创 OCP-1Z0-053-200题-35题-614

QUESTION 35Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11gRelease 2)? (Choose three.)A. Alert log fileB. Archived redo log filesC

2014-01-27 23:23:46 4295

原创 OCP-1Z0-053-200题-33题-612

QUESTION 33Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking, after the incremental level 0 b

2014-01-27 22:35:32 5296

原创 OCP-1Z0-053-V13.02-612题

612.Examine the following command used to perform incremental level 0 backup:RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking, after the incremental level 0 backup

2014-01-27 22:33:43 8730 1

原创 OCP-1Z0-053-200题-32题-611

QUESTION 32To accomplish user-managed backup for the USERS tablespace, you issued the following command to put thedatabase in backup mode:SQL> ALTER TABLESPACE users BEGIN BACKUP;While copying

2014-01-27 21:37:15 4216

原创 OCP-1Z0-053-V13.02-611题

611.To accomplish user-managed backup for the USERS tablespace, you issued the following commandto put the database in backup mode:SQL> ALTER TABLESPACE users BEGIN BACKUP;While copying the file

2014-01-27 21:35:39 5785

原创 OCP-1Z0-053-200题-31题-131

QUESTION 31View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance. Whatvalue would you recommend?A.

2014-01-27 15:25:59 3966

原创 OCP-1Z0-053-200题-126题-264

QUESTION 126Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed? (Choose two.)A. stored scripts in the recovery catalog.B. ba

2014-01-27 15:21:59 3181

原创 OCP-1Z0-053-200题-30题-264

QUESTION 30Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?(Choose two.)A. Stored scripts in the recovery catalogB. Ba

2014-01-27 15:19:34 4780

原创 OCP-1Z0-053-V13.02-264题

264.Using the LIST command in Recovery Manager (RMAN), which two pieces of information in theRMAN repository can be listed? (Choose two.)A. stored scripts in the recovery catalogB. backups that

2014-01-27 15:18:15 7666

原创 OCP-1Z0-053-200题-29题-609

QUESTION 29Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 1050SQL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES';

2014-01-27 14:53:36 3685

原创 OCP-1Z0-053-200题-28题-608

QUESTION 28You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups.Identify two prerequisites to perform the backups. (Choose two.)A. The databa

2014-01-27 14:49:10 3172 1

原创 OCP-1Z0-053-200题-27题-607

QUESTION 27Examine the following scenario:- Database is running in ARCHIVELOG mode.- Complete consistent backup is taken everySunday.- On Tuesday the instance terminates abnormally because the

2014-01-27 14:46:57 4199

原创 OCP-1Z0-053-200题-26题-134

QUESTION 26You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERStablespace that has a single data file of 900 MB. Youhave tape drives of 300 MB ea

2014-01-27 11:36:52 5551

原创 OCP-1Z0-053-200题-25题-606

QUESTION 25Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN (choose all that apply)A. Limiting the input/output (I/O) bandwidth

2014-01-27 11:28:52 4724

原创 OCP-1Z0-053-V13.02-606题

606.Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATECHANNEL commands in RMAN (choose all that apply)A. Limiting the input/output (I/O) bandwidth consumpt

2014-01-27 11:27:31 10265 1

原创 OCP-1Z0-053-200题-24题-605

QUESTION 24What two are the prerequisites for enabling Flashback Database? (Choose two)A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT EXCLUSIVE modeC. The database

2014-01-27 11:09:33 3603

原创 OCP-1Z0-053-200题-23题-604

QUESTION 23You realize that the control file is damaged in your production database. After restoring the control file fromautobackup, what is the next step that you must do to proceed with the dat

2014-01-27 11:02:50 3494

原创 OCP-1Z0-053-200题-22题-603

QUESTION 22While performing a regular check on your recovery catalog you realized that the catalog database is runningout of space and you do not have options to increase the space.However, you

2014-01-27 10:59:03 3775

原创 OCP-1Z0-053-200题-21题-602

QUESTION 21On Friday at 11:30 am you decided to flash back thedatabase because of a user error that occurred at 8:30 am.Which option must you use to check whether a flashback operation can recover

2014-01-27 10:53:19 4220

原创 OCP-1Z0-053-V13.02-601题

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 prerequisites to perform this operation? (Choose

2014-01-27 10:47:48 9312 1

原创 OCP-1Z0-053-200题-20题-133

QUESTION 20You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup? (Choose two)A. The KEEP option overrides the configured retention policy

2014-01-27 10:47:22 4092

原创 OCP-1Z0-053-200题-19题-601

QUESTION 19You 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 prerequisites to perform this operation?

2014-01-26 15:22:23 4021

原创 OCP-1Z0-053-200题-17题-99

QUESTION 17View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE

2014-01-26 15:13:30 5753

原创 OCP-1Z0-053-200题-18题-100

QUESTION 18Examine 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

2014-01-26 15:12:27 5034 1

原创 OCP-1Z0-053-V13.02-99题

99.View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_res

2014-01-26 14:54:13 9178 2

原创 OCP-1Z0-053-200题-16题-98

QUESTION 16You plan to execute the following command to performa Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);Which two statements are true

2014-01-26 14:44:07 3568

原创 OCP-1Z0-053-200题-15题-15

QUESTION 15You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11g database. TheProd1, Prod2 and Prod3 Oracle Database 10g databases are registered in the re

2014-01-26 14:40:38 4333