OCP-1Z0-053
文章平均质量分 54
佳岳
佳岳
展开
-
OCP-V12-007
QUESTION 7 You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.翻译 2015-09-27 20:55:46 · 1090 阅读 · 1 评论 -
OCP-V13-009
QUESTION 9 Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage? A. It returns space usage of only BasicFile LOB chunks. B. It returns spac翻译 2015-09-27 21:15:04 · 951 阅读 · 1 评论 -
OCP-V13-017
QUESTION 17 The INV_HISTORY table is created using the command: SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by range (inv_date) interval (numtoymi翻译 2015-09-27 21:54:07 · 1430 阅读 · 1 评论 -
ocp-v13-036
QUESTION 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 ali翻译 2015-09-28 21:27:32 · 1108 阅读 · 0 评论 -
OCP-V13-040
QUESTION 40 Evaluate the following code: SQL>VARIABLE task_name VARCHAR2(255); SQL>VARIABLE sql_stmt VARCHAR2(4000); SQL>BEGIN :sql_stmt := ‘SELECT COUNT(*) FROM customers WHERE cust_state_province翻译 2015-09-28 21:30:05 · 1033 阅读 · 0 评论 -
OCP-V31-041
QUESTION 41 You have applications that have frequently executed queries, and produce small and static result sets. You configure the sqlnet.ora file in the client machine to set a nonzero value for t翻译 2015-09-28 22:10:19 · 1053 阅读 · 0 评论 -
ocp-v13-047
QUESTION 47 You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command? A. It will display a list of files that need increme翻译 2015-09-28 22:19:34 · 980 阅读 · 0 评论 -
OCP-V13-001
EXAM A QUESTION 1 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翻译 2015-09-27 20:42:18 · 1177 阅读 · 0 评论 -
OCP-V13-002
QUESTION 2 You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consider翻译 2015-09-27 20:43:27 · 832 阅读 · 1 评论 -
OCP-V13-005
QUESTION 5 Examine the section of the Health Check report given below: DBMS_HM.GET_RUN_REPORT(‘HM_RUN_1061’) Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode : REAC翻译 2015-09-27 20:50:40 · 1037 阅读 · 1 评论 -
ocp-v13-011
QUESTION 11 View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the Number of Transactions (per second) metric?A. Oracle uses statistical relevance to determin翻译 2015-09-27 21:47:21 · 1983 阅读 · 1 评论 -
OCP-V13-018
QUESTION 18 You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command: SQL> SELECT dbms_addm.get_report(翻译 2015-09-27 21:54:34 · 1759 阅读 · 1 评论 -
OCP-V13-020
QUESTION 20 View the Exhibit and examine the resource consumption details for the current plan in use by the database instance. Which two statements are true based on the output? (Choose two.) Exhi翻译 2015-09-27 21:55:47 · 1196 阅读 · 1 评论 -
OCP-V13-026
QUESTION 26You 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 version 10.1 catalog翻译 2015-09-28 13:17:49 · 891 阅读 · 1 评论 -
OCP-V13-039
QUESTION 39 View the Exhibit to examine the Automatic SQL Tuning result details. Which action would you suggest for the selected SQL statement in the Exhibit? A. Accept the recommended SQL profile.翻译 2015-09-28 21:29:28 · 943 阅读 · 0 评论 -
ocp-v13-046
QUESTION 46 What happens when you run the SQL Tuning Advisor with limited scope? A. Access path analysis is not performed for SQL statements. B. SQL structure analysis is not performed for SQL state翻译 2015-09-28 22:15:57 · 983 阅读 · 0 评论 -
OCP-V13-003
QUESTION 3 Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:翻译 2015-09-27 20:45:54 · 853 阅读 · 1 评论 -
ocp-v13-035
QUESTION 35 You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this? A. Edit the autom翻译 2015-09-28 21:26:37 · 1189 阅读 · 0 评论 -
OCP-V13-050
QUESTION 50 Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? A. when ASM disk goes offline B. when one or m翻译 2015-09-28 22:23:58 · 1358 阅读 · 0 评论 -
OCP-V13-008
QUESTION 8 Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs? A. It cannot be done in parallel. B. It can be done at the table level or pa翻译 2015-09-27 20:58:01 · 875 阅读 · 1 评论 -
OCP-V13-023
QUESTION 23 Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure? A. only encryption and compression settings for all SecureFile LOBs B. only encryption and deduplication settings翻译 2015-09-28 13:15:28 · 1151 阅读 · 1 评论 -
OCP-V13-024
QUESTION 24 Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.) A. ADR diagnostic files B.翻译 2015-09-28 13:16:09 · 926 阅读 · 1 评论 -
OCP-V13-030
QUESTION 30 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 windows. B. A DBA cannot change t翻译 2015-09-28 13:21:29 · 1413 阅读 · 1 评论 -
ocp-v13-031
QUESTION 31 Which two statements are correct about database transportation? (Choose two.) A. The source and target platforms must be the same B. Redo logs, control files and temp files are also tran翻译 2015-09-28 14:13:52 · 1440 阅读 · 0 评论 -
OCP-V13-042
QUESTION 42 You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this proces翻译 2015-09-28 22:11:08 · 951 阅读 · 0 评论 -
ocp-v13-045
QUESTION 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翻译 2015-09-28 22:15:08 · 1190 阅读 · 0 评论 -
ocp-v13-048
QUESTION 48 View the Exhibit to examine the error obtained during the I/O calibration process. There are no data files on raw devices. What is the reason for this error? A. The DISK_ASYNCH_IO parame翻译 2015-09-28 22:21:55 · 1114 阅读 · 0 评论 -
OCP-V13-006
QUESTION 6 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 version 10.1 catalo翻译 2015-09-27 20:53:12 · 894 阅读 · 1 评论 -
OCP-V13-015
QUESTION 15 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 databases are registered in the base rec翻译 2015-09-27 21:52:10 · 1080 阅读 · 1 评论 -
OCP-V13-021
QUESTION 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?翻译 2015-09-28 13:14:23 · 793 阅读 · 0 评论 -
OCP-V13-025
QUESTION 25 You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive? A. Drop the table. B. Partition the table翻译 2015-09-28 13:16:59 · 912 阅读 · 1 评论 -
OCP-V13-028
QUESTION 28 You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequentl翻译 2015-09-28 13:19:05 · 895 阅读 · 1 评论 -
ocp-v13-031
QUESTION 32 In your production database, you: -Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular intervals Set the control file autobackup to “on”翻译 2015-09-28 21:21:57 · 937 阅读 · 0 评论 -
ocp-v13-037
QUESTION 37 During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment翻译 2015-09-28 21:28:02 · 1050 阅读 · 0 评论 -
ocp-v13-043
QUESTION 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;翻译 2015-09-28 22:12:02 · 1355 阅读 · 0 评论 -
ocp-v13-044
QUESTION 44 You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table? A. The翻译 2015-09-28 22:12:32 · 985 阅读 · 0 评论 -
OCP-V13-004
QUESTION 4 Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.) A. a job B. a program C. a schedule D. a PL/SQL procedure Correct Answe翻译 2015-09-27 20:47:28 · 779 阅读 · 1 评论 -
OCP-V13-012
QUESTION 12 You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issue翻译 2015-09-27 21:48:15 · 997 阅读 · 1 评论 -
OCP-V13-014
QUESTION 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 co翻译 2015-09-27 21:51:21 · 1010 阅读 · 1 评论 -
OCP-V13-016
QUESTION 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_翻译 2015-09-27 21:52:40 · 1151 阅读 · 0 评论