OCP11g解析
文章平均质量分 67
OCP11g,051,052,053每题的解析
Riveore
这个作者很懒,什么都没留下…
展开
-
OCP-1Z0-053-V13.02-43题
43.View the following SQL statements:Transaction T1 INSERT INTO hr.regions VALUES (5,'Pole');COMMIT;Transaction T2 UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5; COMMIT;Transacti原创 2013-11-13 10:20:16 · 10894 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-70题
70. You configured the Flash Recovery Area (FRA) for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Are原创 2013-11-14 08:51:08 · 13096 阅读 · 1 评论 -
OCP-1Z0-052-V8.02-100题
100. In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table? (Choose all that apply.)A.if a table is not in a clusterB.if a table h原创 2013-11-14 09:16:15 · 12631 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-36题
36.Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)A. It repairs blocks that have read disk I/O errors.B. It checks whether the alias metadat原创 2013-11-14 09:26:33 · 11952 阅读 · 2 评论 -
OCP-1Z0-053-V13.02-45题
45.What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?A. It improves resync operations.B. This feature enables much faster file opens.C. It impr原创 2013-11-14 09:54:04 · 9622 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-60题
60.For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. saving storage space by using compressed b原创 2013-11-14 10:20:56 · 9680 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-651题
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? (Choose two.)A. The job is enabled by def原创 2013-11-14 11:42:15 · 8927 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-652题
652.Tape streaming is not happening while performing RMAN tape backup. On investigation, you find thatit is not because of the incremental backup or the empty file backup and that RMAN is sending da原创 2013-11-14 11:42:27 · 10466 阅读 · 1 评论 -
OCP-1Z0-051-V9.02-13题
13. View the Exhibit and examine the structure of the PRODUCTS table.You need to generate a report in the following format:CATEGORIES5MP Digital Photo Camera's category is PhotoY Box's categor原创 2013-11-15 10:21:03 · 12994 阅读 · 0 评论 -
OCP-1Z0-051-V9.02-16题
16. Evaluate the following query:SQL> SELECT promo_name q'{'s start date was }' promo_begin_date AS "Promotion Launches"FROM promotions;What would be the outcome of原创 2013-11-15 10:26:20 · 10031 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-135题
135. In which situation would you use static database registration for a listener?A.when multiple databases are to be registered with the listenerB.when DBAs need to connect remotely to start up t原创 2013-11-15 11:14:17 · 10078 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-24题
24. Which two statements correctly describe the relation between a data file and the logical databasestructures? (Choose two.)A.An extent cannot spread across data files.B.A segment cannot sprea原创 2013-11-15 14:53:04 · 12383 阅读 · 3 评论 -
OCP-1Z0-053-V13.02-1题
1.While deploying a new application module, the software vendor ships the application software alongwith appropriate SQL plan baselines for the new SQLs being introduced. Which two statements descri原创 2013-11-17 15:07:09 · 22361 阅读 · 4 评论 -
OCP-1Z0-053-V13.02-2题
2.You plan to have a larger moving window size for the default system-defined moving window baselinebecause you want to use the adaptive threshold.Which statement factors in this consideration whi原创 2013-11-17 20:52:08 · 14499 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-14题
14.Which two statements are true regarding hot patching? (Choose two.)A. It requires relinking of the Oracle binary.B. It does not require database instance shutdown.C. It can detect conflicts b原创 2013-11-17 21:23:34 · 9090 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-93题
93. You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files to clustered tabl原创 2013-11-18 09:26:23 · 10385 阅读 · 0 评论 -
OCP-1Z0-052-V8.02-69题
69. You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new loca原创 2013-11-18 09:46:30 · 11091 阅读 · 2 评论 -
OCP-1Z0-053-V13.02-13题
13.View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is theSignificance Level threshold type not available in the threshold setting?A. because AWR basel原创 2013-11-18 15:31:54 · 3958 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-125题
125.Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)A. It is used to change failure priority only for HIGH or LOW priorities.B. It is used原创 2013-11-20 13:56:11 · 8405 阅读 · 1 评论 -
OCP-1Z0-053-V13.02-126题
126.Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)A. You can add or remove the trace files to the package.原创 2013-11-20 14:10:06 · 6509 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-127题
127.The application tables owned by the user TEST in a test database need to be exported to the APPSschema in the production database by using Data Pump. Which option of Data Pump Import would you原创 2013-11-20 14:13:54 · 5510 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-130题
130.Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)A. Undo retention guarantee for the database must be configured.B. Supplemental log原创 2013-11-20 14:26:18 · 8778 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-131题
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.What value would you assign?A. 1440原创 2013-11-20 14:34:02 · 8142 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-132题
132.You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, abig file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which原创 2013-11-20 14:41:58 · 10586 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-133题
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 data files, the server parameter file, and t原创 2013-11-20 14:54:13 · 9910 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-139题
139.Which two prerequisites are needed for performing workload capture and replay? (Choose two.)A. Close all sessions performing queries using database links.B. running the database in shared serv原创 2013-11-20 15:07:06 · 6582 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-140题
140.Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for原创 2013-11-20 15:11:42 · 7388 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-141题
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 TABLE emp (empno NUMBER(3), ename VARCHAR原创 2013-11-20 15:19:19 · 7187 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-144题
144.In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in theinitialization parameter file. You issued the following command:SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum原创 2013-11-20 15:25:58 · 6802 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-168题
168.Exhibit:View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command. Whichstatement is true about the block corruption detected by the command?A. No action is ta原创 2013-11-20 15:38:00 · 7747 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-176题
176.Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?A. Archive log generation is suspended until the tablespaces are taken ou原创 2013-11-20 16:04:03 · 7231 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-192题
192.What is the purpose of the until change option of the restore command?A. It allows you to select the SCN that you want to restore to.B. It allows you to select the log sequence number you want原创 2013-11-20 16:21:42 · 5950 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-193题
193.What is the purpose of the recover command? (Choose all that apply.)A. Recover database datafiles from physical disk backup sets.B. Recover required incremental backups from physical disk back原创 2013-11-20 16:29:50 · 7648 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-198题
198.What are the two different types of database duplication? (Choose two.)A. ActiveB. PassiveC. OnlineD. Backup-basedE. Failure drivenAnswer: AD答案解析:参考:http://blog.csdn.net/rlhua/arti原创 2013-11-20 16:31:23 · 6156 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-201题
201.Examine the following PL/SQL block:SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob;BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();DBMS_OUTPUT.PUT_LINE(report);END;Which stat原创 2013-11-20 16:39:17 · 9899 阅读 · 0 评论 -
OCP-1Z0-053-V13.02-202题
202.In which two aspects does hot patching differ from conventional patching? (Choose two.)A. It consumes more memory compared with conventional patching.B. It can be installed and uninstalled via原创 2013-11-21 00:04:56 · 8557 阅读 · 0 评论 -
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 · 11173 阅读 · 6 评论 -
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 · 11065 阅读 · 3 评论 -
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 · 7361 阅读 · 0 评论 -
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 · 7480 阅读 · 2 评论