2013年11月_Riveore

12月 11月 10月 09月

原创 Oracle OCP 11G 052答案解析目录

Oracle OCP 11G 052答案解析目录(V8.02&V9.02)V8.021：http://blog.csdn.net/rlhua/article/details/126242752：http://blog.csdn.net/rlhua/article/details/127536533：http://blog.c

2013-11-26 11:13:14 81244 27

原创 Oracle OCP 11G 052 V8.02与V9.02版本对比

052 v8.02与V9.02对比12345678910111213141516171819202122232425262728293031323334353637383940414243

2013-11-26 11:02:28 7509 1

原创关于OCP11g解析——2014-07-30

第一轮解析结束了。知道的，了解的，实验出来的，看官方文档的。都已经差不多解析出来了。剩下还没有解析出来的题，都是我不怎么了解的题。接下来，可能不会每天发布20到题了。要慢慢的开始研究那些没有解析出来的题。也要开始复习那些已经解析出来的题。大家一起共同努力。2013-11-13

2013-11-14 11:41:51 16642 23

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

443.Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)A. SET_ATTRIBUTE_NULLB. ALTER_JOBC. ALTER_JOB_PARAMETERSD. ALTERE. SET_ATTRIBUTEAnswer:

2013-11-29 15:56:26 5924

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

297.View the Exhibit for some of the parameter settings. You start a session and issue the following command:SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;What is the outco

2013-11-29 15:45:15 6100

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

319.What is the end result of these commands if they are successful?RMAN> show retention policy;RMAN configuration parameters for database with db_unique_nameORCL are: CONFIGURE RETENTION POLICY

2013-11-29 15:26:33 6933

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

321.True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile totrace.A. TrueB. FalseAnswer: B答案解析：sqlplus下：sys@TEST1107> alter database backup

2013-11-29 14:50:24 6858 3

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

324.Your database is up and running and one of your three control files is accidentally erased. You startRMAN and run the following command:RESTORE CONTROLFILE FROM AUTOBACKUP;Which of the follo

2013-11-29 14:46:42 5097

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

325.Which of the following are valid until command options when attempting point-in-time recovery inRMAN? (Choose all that apply.)A. until timeB. until changeC. until sequenceD. until SCNE

2013-11-29 13:10:54 5729

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

329.If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status ofMEDIA_CORRUPT, what RMAN command would you run to correct the problem?A. recover lost blocks;B. recover corrupt blo

2013-11-29 13:02:45 5960

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

358.What command is used to reset a database to a previous incarnation?A. reset incarnationB. incarnation resetC. reset database to incarnationD. reset database incarnationE. reset databse i

2013-11-29 11:13:36 6565

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

376.A user named Arren is executing this query:select table_name, operation, undo_sqlfromflashback_transaction_query t,(select versions_xid as xidfrom employees versions between scn minvalue

2013-11-29 10:37:30 5659

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

379.Users notify you that their application is failing every time they try to add new records. Because ofpoor application design, the actual ORA error message is unavailable. What might be the probl

2013-11-29 10:27:45 8122 4

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

245.Which statements are true regarding system-partitioned tables? (Choose all that apply.)A. Only a single partitioning key column can be specified.B. All DML statements must use partition-extend

2013-11-28 16:39:02 8769

原创 OCP-1Z0-052-V9.02-201题

201.Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index? A. The DML operations re-create the bitmap index blocks

2013-11-26 15:32:55 11529 1

原创 OCP-1Z0-052-V9.02-115题

115.Which of these is true about undo tablespace? A. Undo tablespace is a temporary tablespace B. Undo tablespace has only one datafile C. Undo tablespace has a datafile which is reused in cy

2013-11-26 15:32:19 11480 9

原创 OCP-1Z0-052-V9.02-177题

177.Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.) A. It can be increased up to the value of the SGA_MAX_SIZE parameter. B. Increasing the value o

2013-11-26 15:22:06 10122

原创 OCP-1Z0-052-V9.02-116题

116.Your database is in shutdown state. What will happend if you issue next command: SQL> startup A. instance will started B. instance started and DB is mounted C. instance started, DB

2013-11-26 14:31:21 6403

原创 OCP-1Z0-052-V9.02-72题

72.Examine the following output: SQL> SELECT index_name,status FROM dba_indexes WHERE status='UNUSABLE'; INDEX_NAME STATUS EIND UNUSABLE Which two statements about the above index ar

2013-11-26 14:21:37 11502

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

102. You want to import schema objects of the HR user using Oracle Data Pump from the developmentdatabase, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com iscreated

2013-11-26 10:25:55 10196 2

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

117. View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not automatically tuned? (Choosethree.)A.LOG_B

2013-11-26 10:24:45 9367 1

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

507.Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in theusers tablespace is damaged and you need to recover the file until the point of failure. The backup fo

2013-11-25 14:19:39 6892 1

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

131. Which naming method uses the tnsnames.ora file to store the connect descriptor used by the clientwhile connecting to the database instance from a remote machine?A.host naming methodB.local

2013-11-24 01:07:36 8887

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

641.Which three functions are performed by the SQL Tuning Advisor? (Choose three.)A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missi

2013-11-22 16:12:42 8271

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

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 more than one dependency.C. A job of th

2013-11-22 15:52:09 8115

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

664.You want to take a complete database backup using RMAN. The backup should consist only the usedblocks from your database.Which two statements are true about this backup operation? (Choose two.

2013-11-22 15:39:04 7633

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

48. The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time, the maintenance window closes before the

2013-11-22 14:24:43 11481

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

22. Identify the logical structure that will never have more than one data segment created for it. A.external tableB.partitioned tableC.partitioned indexD.nonclustered tableE.global temporar

2013-11-22 10:28:59 11381

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

14. These are points that describe the contents of different memory components:1: Descriptive information or metadata about schema objects that are queried by using SQL statements2: The run-time a

2013-11-22 09:48:38 11752

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

8. Observe the information in the columns:1: The SGA a. Text and parsed forms of all SQL statements2: The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved3: U

2013-11-22 09:20:59 11339

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

238.View the Exhibit to examine the output for the V$DIAG_INFO view.Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)A. The path to the location

2013-11-21 16:37:08 6812

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

233.Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You importedSQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLEparameter

2013-11-21 16:28:36 6608

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

232.What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)A. selection of SQL plan baselinesB. partitioning of tables and indexesC. creatio

2013-11-21 16:07:48 8243

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

228.Evaluate the following statements:CREATE TABLE purchase_orders (po_id NUMBER(4),po_date TIMESTAMP, supplier_id NUMBER(6), po_total NUMBER(8,2),CONSTRAINT order_pk PRIMARY KEY(po_id))

2013-11-21 14:38:45 8095 2

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

226.Examine the following PL/SQL block:DECLAREmy_plans pls_integer;BEGINmy_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id => ?9twu5t2dn5xd?;END;Which statement is true about the pl

2013-11-21 14:20:21 6707

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

225.View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. You executedthe following commands:SQL> VAR tname VARCHAR2(60);SQL> BEGIN :tname := 'my_instance_analysis_

2013-11-21 14:05:39 9469 1

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

221.To generate recommendations to improve the performance of a set of SQL queries in an application,you execute the following blocks of code:BEGIN dbms_advisor.create_task(dbms_advisor.sqlaccess_

2013-11-21 10:20:34 7496 2

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

219.You executed the following PL/SQL block successfully:VARIABLE tname VARCHAR2(20)BEGIN dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage',FINDING_NAME=>'CPU Usage', MIN_AC

2013-11-21 09:59:28 7407

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

216.Which three elements can a job chain process involve? (Choose three)A. an eventB. a scheduleC. a programD. another chainE. a lightweight jobAnswer: BDE答案解析：参考：http://docs.oracle.co

2013-11-21 09:49:07 11076 3

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

212.Note the following parameters settings in your database:SGA_MAX_SIZE = 1024MSGA_TARGET = 700MDB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou issued the following command to increase the valu

2013-11-21 09:40:02 11182 6