Oracle OCP解析
文章平均质量分 87
Oracle OCP认证题目解析
梅森上校
十多年软件行业从业经验,热爱技术,精于项目管理和研发团队建设。闲暇至于,喜欢欣赏音乐,看看电影;摆弄摆弄茶道,让身心得以调整和休息。
展开
-
Oracle OCP 1Z0-050(181-183题)解析
Oracle OCP 1Z0-050(181-183题)解析QUESTION 181:Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, ...原创 2018-10-10 23:04:06 · 257 阅读 · 0 评论 -
Oracle OCP 1Z0-050(171-180题)解析
Oracle OCP 1Z0-050(171-180题)解析QUESTION 171:You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databa...原创 2018-10-10 22:58:18 · 821 阅读 · 0 评论 -
Oracle OCP 1Z0-050(161-170题)解析
QUESTION 161:Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)A. Automatic Database Diagnostics MonitorB. Automatic SQL Tuning Advi...原创 2018-10-10 22:47:06 · 464 阅读 · 0 评论 -
Oracle OCP 1Z0-050(151-160题)解析
Oracle OCP 1Z0-050(151-160题)解析QUESTION 151:Exhibit:View the Exhibit to examine the output for the V$DIAG_INFO view.Which statements are true regarding the location of diagnostic traces? (Cho...原创 2018-10-10 22:37:57 · 634 阅读 · 0 评论 -
Oracle OCP 1Z0-050(141-150题)解析
Oracle OCP 1Z0-050(141-150题)解析QUESTION 141:The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?...原创 2018-10-10 20:45:00 · 673 阅读 · 0 评论 -
Oracle OCP 1Z0-050(131-140题)解析
Oracle OCP 1Z0-050(131-140题)解析QUESTION 131: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 b...原创 2018-10-10 20:20:12 · 642 阅读 · 0 评论 -
解析 Oracle 12c OCP 1Z0-060[V8.6]—001
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.A user issues a query on a t...原创 2018-10-10 11:18:23 · 875 阅读 · 0 评论 -
Oracle OCP 1Z0-050(121-130题)解析
Oracle OCP 1Z0-050(121-130题)解析QUESTION 121:Exhibit:View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Ex...原创 2018-10-07 14:34:27 · 1136 阅读 · 0 评论 -
Oracle OCP 1Z0-050(111-120题)解析
Oracle OCP 1Z0-050(111-120题)解析QUESTION 111:Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issu...原创 2018-10-07 11:45:37 · 715 阅读 · 0 评论 -
Oracle OCP 1Z0-050(101-110题)解析
Oracle OCP 1Z0-050(101-110题)解析QUESTION 101: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)...原创 2018-10-07 01:57:36 · 2384 阅读 · 0 评论 -
Oracle OCP 1Z0-050(91-100题)解析
Oracle OCP 1Z0-050(91-100题)解析QUESTION 91:Which statements are true regarding system-partitioned tables? (Choose all that apply.)A. Only a single partitioning key column can be specified.B. The...原创 2018-10-06 01:20:54 · 972 阅读 · 0 评论 -
Oracle OCP 1Z0-050(81-90题)解析
Oracle OCP 1Z0-050(81-90题)解析QUESTION 81:You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?A. Partitio...原创 2018-10-04 23:19:47 · 345 阅读 · 0 评论 -
Oracle OCP 1Z0-050(71-80题)解析
Oracle OCP 1Z0-050(71-80题)解析QUESTION 71:Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)A. SQL Tuning SetB. Cursor cacheC. Stored...原创 2018-10-03 23:17:44 · 333 阅读 · 0 评论 -
Oracle OCP 1Z0-050(61-70题)解析
Oracle OCP 1Z0-050(61-70题)解析QUESTION 61:Exhibit:View the Exhibit to examine the parameters set for your database instance.You execute the following command to perform I/O calibration after t...原创 2018-10-03 22:24:16 · 567 阅读 · 0 评论 -
Oracle OCP 1Z0-050(51-60题)解析
Oracle OCP 1Z0-050(51-60题)解析QUESTION 51:Which two statements are true with respect to the maintenance window? (Choose two.)A. A DBA can enable or disable an individual task in all maintenance wi...原创 2018-10-01 22:21:50 · 1157 阅读 · 0 评论 -
Oracle OCP 1Z0-050(41-50题)解析
Oracle OCP 1Z0-050(41-50题)解析QUESTION 41:Exhibit #1:Exhibit #2:View the Exhibit exhibit1 to examine the series of SQL commands.View the Exhibit exhibit2 to examine the plans available in ...原创 2018-10-01 15:54:10 · 473 阅读 · 0 评论 -
Oracle OCP 1Z0-050(40题)解析
QUESTION 40:Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)A. Generate reports on data failure such as data file fai...原创 2018-10-01 15:41:12 · 241 阅读 · 0 评论 -
Oracle OCP 1Z0-050(39题)解析
Oracle OCP 1Z0-050(39题)解析QUESTION 39:Evaluate the following function code:CREATE FUNCTION get_dept_avg(dept_id NUMBER)RETURN NUMBERRESULT_CACHE RELIES_ON (EMPLOYEES)ISavgsal NUMBER(6);...原创 2018-10-01 15:26:20 · 283 阅读 · 0 评论 -
Oracle OCP 1Z0-050(38题)解析
Oracle OCP 1Z0-050(38题)解析You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database vers...原创 2018-10-01 12:13:24 · 298 阅读 · 0 评论 -
Oracle OCP 1Z0-050(37题)解析
Oracle OCP 1Z0-050(37题)解析QUESTION 37:Which statements are true regarding the Query Result Cache? (Choose all that apply.)A. It can store the results from normal as well as flashback queries.B....原创 2018-10-01 12:01:47 · 168 阅读 · 0 评论 -
Oracle OCP 1Z0-050(36题)解析
Oracle OCP 1Z0-050(36题)解析QUESTION 36:Evaluate the following command:SQL> CREATE TABLE design_data (id NUMBER,doc CLOB)LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);Which statement is true r...原创 2018-10-01 00:01:27 · 228 阅读 · 0 评论 -
Oracle OCP 1Z0-050(35题)解析
Oracle OCP 1Z0-050(35题)解析QUESTION 35:Which statement is true regarding virtual private catalogs?A. A virtual private catalog owner can create a local stored script, and have read/write access to...原创 2018-09-30 13:40:04 · 159 阅读 · 0 评论 -
Oracle OCP 1Z0-050(34题)解析
Oracle OCP 1Z0-050(34题)解析QUESTION 34:Your database initialization parameter file has the following entry:SEC_MAX_FAILED_LOGIN_ATTEMPTS=3Which statement is true regarding this setting?A. It d...原创 2018-09-30 13:26:08 · 166 阅读 · 0 评论 -
Oracle OCP 1Z0-050(33题)解析
Oracle OCP 1Z0-050(33题)解析QUESTION 33:Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?A. AWR baselines are always created with infi...原创 2018-09-30 13:21:18 · 210 阅读 · 0 评论 -
Oracle OCP 1Z0-050(32题)解析
Oracle OCP 1Z0-050(32题)解析QUESTION 32:View the following SQL statements:Transaction T1INSERT INTO hr.regions VALUES (5,'Pole');COMMIT;Transaction T2UPDATE hr.regions SET region_name='Pole...原创 2018-09-30 12:13:30 · 199 阅读 · 0 评论 -
Oracle OCP 1Z0-050(31题)解析
Oracle OCP 1Z0-050(31题)解析QUESTION 31:In which two aspects does hot patching differ from conventional patching? (Choose two.)A. It takes more time to install or uninstall compared with convention...原创 2018-09-30 12:00:38 · 149 阅读 · 0 评论 -
Oracle OCP 1Z0-050(30题)解析
Oracle OCP 1Z0-050(30题)解析QUESTION 30:Which three statements are true regarding persistent lightweight jobs? (Choose three.)A. Persistent lightweight jobs modify several tables in the data dictio...原创 2018-09-30 11:21:21 · 363 阅读 · 0 评论 -
Oracle OCP 1Z0-050(29题)解析
Oracle OCP 1Z0-050(29题)解析QUESTION 29:You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline ...原创 2018-09-30 10:55:52 · 246 阅读 · 0 评论 -
Oracle OCP 1Z0-050(28题)解析
Oracle OCP 1Z0-050(28题)解析QUESTION 28:You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, ...原创 2018-09-30 10:11:48 · 149 阅读 · 0 评论 -
Oracle OCP 1Z0-050(27题)解析
Oracle OCP 1Z0-050(27题)解析QUESTION 27:What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?题目大意是:设置ASM首选的镜像读(充分利用cluster配置)的优势是什么?A. It improves ...原创 2018-09-30 10:05:53 · 171 阅读 · 0 评论 -
Oracle OCP 1Z0-050(26题)解析
Oracle OCP 1Z0-050(26题)解析QUESTION 26:Evaluate the following code:SQL>VARIABLE task_name VARCHAR2(255);SQL>VARIABLE sql_stmt VARCHAR2(4000);SQL>BEGIN:sql_stmt := 'SELECT COUNT(*) F...原创 2018-09-30 09:54:35 · 259 阅读 · 0 评论 -
Oracle OCP 1Z0-050(25题)解析
Oracle OCP 1Z0-050(25题)解析QUESTION 25:Which statement describes the effect of table redefinition on the triggers attached to the table?A. All triggers on the table are invalidated and are automat...原创 2018-09-29 00:09:24 · 460 阅读 · 0 评论 -
Oracle OCP 1Z0-050(24题)解析
Oracle OCP 1Z0-050(24题)解析QUESTION 24:Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?A. only encryption and deduplication settings for only SecureFile CLOBsB. only encr...原创 2018-09-28 23:41:57 · 218 阅读 · 0 评论 -
Oracle OCP 1Z0-050(23题)解析
Oracle OCP 1Z0-050(23题)解析QUESTION 23:Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)A. It reads the blocks from a good copy of an ASM mirr...原创 2018-09-28 23:13:28 · 163 阅读 · 0 评论 -
Oracle OCP 1Z0-050(22题)解析
Oracle OCP 1Z0-050(22题)解析QUESTION 22:Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';What is the impact of this setting on the usage of SecureFiles? A. It f...原创 2018-09-28 22:25:37 · 177 阅读 · 0 评论 -
Oracle OCP 1Z0-050(21题)解析
Oracle OCP 1Z0-050(21题)解析QUESTION 21:Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?A. It returns space usage of only SecureFile L...原创 2018-09-28 22:07:17 · 177 阅读 · 0 评论 -
Oracle OCP 1Z0-050(16-20题)解析
QUESTION 16:While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.Which two state...原创 2018-09-28 20:32:59 · 298 阅读 · 0 评论 -
Oracle OCP 1Z0-050(11-15题)解析
QUESTION 11:USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted form...原创 2018-09-28 15:55:10 · 242 阅读 · 0 评论 -
Oracle OCP 1Z0-050(1-10题)解析
Oracle OCP 1Z0-050(1-10题)解析QUESTION 1: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 reco...原创 2018-09-27 21:22:19 · 378 阅读 · 0 评论