- 相关推荐
ocp培训考试相关
导语：OCP全称为Oracle认证数据库专家，是Oracle公司的Oracle数据库DBA认证课程，它是专为认证那些能够满足对ORACLE核心产品的服务与支持，并具有娴熟的操作能力与广泛理论知识的专业人士。一经认证，在行业内的专业资格将被确认，从而使个人或企业更具竞争实力。同时，OCP将帮助您在竞争激烈的市场中脱颖而出。通过对ORACLE产品的熟练应用，您将获得业界普遍的认可。与职务相关的认证，说明您是一个合格的技术人员。作为ORACLE认证专家，您将具有对业界最具挑战性的机遇更深的洞察力，并获取更多的收获。Oracle全世界的数据库市场份额在50%以上，在中国的客户更有中国移动、中国电信、阿里巴巴、腾讯等中国绝大多数的大型企业。小编在此整理了关于OCP的一系列信息，大家一起来了解吧
OCP认证分类：
Oracle OCP 10g和Oracle OCP 11g
培训费用分别是CNY：7000-8000以及8000-9000
考试费用：OCP认证一共有三门考试科目，每门价格为CNY898，三门合计CNY2694，总计CNY10494
OCP报考流程
(一)、确认考试日期，填写相关表格:
1、确定考试日期后，填写好报名表中的个人基本信息，提交报名所需的所有文件。
(二)、注册相关账号:
2、请于考试前2周，登陆VUE网站(http://www.pearsonvue.com/oracle/)，申请VUE 账号和Testing ID 账号。然后，到oracle官方的网站(http://certview.oracle.com )去注册自己的账户(SSO账户)，并且通过Certview系统绑定自己的pearsonvue账户，以便查询成绩，成绩可从oracle官方的网站(http://certview.oracle.com )查询到。
3、随后，各位会收到OU发来的教学评价表，且会接到Oracle的回访电话。请各位随时保持电话畅通。
(三)、考前准备工作:
4、考试前1周，请再次确认自己的相关账号是否可用，并详细阅读 《考场规则》，牢记考试时间、地点
5、考试当天，请携带本人身份证，第二证件，VUE账号，以及Testing ID、承诺函，提前半小时进入考场。
6、自报考之日起，学员需随时关注自己的邮箱，所有与考试取证相关的信息均会以邮件形式通知。
OCP补考流程
如果各位是在Oracle原厂参加的培训,则可以自己去Oracle原厂申请补考，并提供原厂的培训证明。反之，则只能通过WDP合作伙伴进行补考。
WDP合作伙伴不单独安排OCP和OCM的补考，学员若要参加补考需提前告知教务老师，等到下一次考试日期确定时，补考学员将与初考学员一起进行考试，但补考学员只需报考未通过科目。
OCP考试注意事项
1、 严格按照《考场规则》入场考试
2、 由于考试科目较多，所以实行电子签到，也就是说只有到了这个科目的开考时间才可以进行本科目的考试，不能提前开考也不能延后。
3、 若考试完毕，请交卷离开考场。不允许在考场内进行hands on的相关操作。
OCP成绩查询：
成绩查询网址为：http://certview.oracle.com，因为之前已经将VUE账号与sso账号绑定。所以直接登录该网站，即可看到自己考试的相关信息，以及考试成绩。
OCP考试证书申领：
电子证书将以邮件形式发送到各位学员手中，若想获取实物证书，需要到指定网站填写相关信息，OU负责统一邮寄。具体网址，以学员收到的邮件上所写的网址为准。
相关例题：
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 statements describe the consequences? (Choose two.)
| A. | The plan baselines can be evolved over time to produce better performance. |
| B. | The newly generated plans are directly placed into the SQL plan baseline without being verified. |
| C. | The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration. |
| D. | The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported. |
Answer: AC
Section: (none)
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 consideration while increasing the size of the moving window?
| A. | The collection level for the AWR should be set to BASIC. |
| B. | The moving window size must be less than Undo Retention. |
| C. | The moving window size should be greater than the Automatic Workload Repository (AWR) retention period. |
| D. | The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period. |
Answer: D
Section: (none)
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:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?
| A. | ALTER DATABASE DROP LOGFILE GROUP 1; |
| B. | ALTER DATABASE CLEAR LOGFILE GROUP 1; |
| C. | ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1; |
| D. | ALTER DATABASE DROP LOGFILE MEMBER 'D:REDO01.LOG'; |
Answer: C
Section: (none)
Explanation/Reference:
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 |
Answer: ABC
Section: (none)
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 :
REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time :
2007-05-12 22:11:20.835135 -07:00 Error Encountered : 0
Source Incident Id : 7418
Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)
| A. | Health Check was performed manually. |
| B. | Health Check was performed to check the disk image block corruptions. |
| C. | Health Check was performed to check interblock and intersegment corruption. |
| D. | Health Check was performed to verify the integrity of database files and report failures. |
| E. | Health Check was performed by the Health Monitor automatically in response to a critical error. |
Answer: AB
Section: (none)
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 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import. You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;
What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?
| A. | The scripts in the RCO11 catalog are overwritten. |
| B. | RMAN renames the local stored scripts in the RCO11 catalog. |
| C. | The RMAN session in which the command is executed aborts. |
| D. | RMAN renames the global scripts that are imported from the RCAT10 catalog. |
Answer: D
Section: (none)
Explanation/Reference:
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.
Which statement is true regarding the ACL created?
| A. | It is a list of remote database links stored in the XML file that are available to the users of the database. |
| B. | It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts. |
| C. | It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts. |
| D. | It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP. |
Answer: B
Section: (none)
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 partition level. |
| C. | It does not require additional storage because the operation is done online. |
| D. | Local and global indexes are maintained automatically during the operation. |
Answer: B
Section: (none)
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 space usage of only SecureFile LOB chunks. |
| C. | It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables. |
| D. | It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables. |
Answer: B
Section: (none)
QUESTION 10
Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
The recovery window is set to 7 days in RMAN.
The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?
| A. | The RMAN backup fails because the TOOLS tablespace is read-only |
| B. | The RMAN skips the backup of the tablespace because backup optimization is enabled |
| C. | The RMAN makes backup because optimization can be enabled only for backups to disk |
| D. | The RMAN makes the backup because no backup of the tablespace exists within the seven day window |
Answer: D
Section: (none)
Explanation/Reference:
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 determine when an adaptive threshold has been breached for the metric. |
| B. | The statistics for the metric values observed over the baseline time period are not examined to determine threshold values. |
| C. | Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline. |
| D. | The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero. |
Answer: A
Section: (none)
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 issued the following command:
RMAN>CHANGE BACKUPSET 231 NOKEEP;
What is the implication of this command?
| A. | The backup is d. |
| B. | The backup is marked unavailable. |
| C. | The backup overrides the backup retention policy. |
| D. | the backup becomes eligible for deletion according to the existing retention policy |
Answer: D
Section: (none)
QUESTION 13
View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the
Significance Level threshold type not available in the threshold setting?
| A. | because AWR baseline is not enabled |
| B. | because Current Open Cursors Count is not a basic metric |
| C. | because the STATISTICS_LEVEL parameter is set to BASIC |
| D. | because the AWR baseline is a system-defined moving window baseline |
Answer: B
Section: (none)
Explanation/Reference:
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 conflicts between two online patches. |
| D. | It is available for installing all patches on all platforms. |
| E. | It works only in a single database instance environment. |
Answer: BC
Section: (none)
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 recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
| A. | They execute and create a virtual catalog for pre-Oracle 11g clients. |
| B. | They produce an error because PROD1 and PROD2 databases belong to the older version. |
| C. | They produce an error because you need to connect as CATOWNER to execute this packaged procedure. |
| D. | They produce an error because you need to connect to the target database to execute this packaged procedure. |
Answer: A
Section: (none)
Explanation/Reference:
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_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?
| A. | Perform Export before TSPITR and Import after TSPITR |
| B. | Move objects to another schema that has the same tablespace assigned |
| C. | Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN) |
| D. | Perform Incomplete Recovery before TSPITR with the System Change Number (SCN) |
Answer: A
Section: (none)
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
(numtoyminterval(1,'month')) (partition p0
values less than (to_date('01-01-2005','dd-mm-yyyy')), partition p1 values less than (to_date('01-01-2006','dd-mm-yyyy')));
The following data has been ed into the INV_HISTORY table :
INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006')) INTO PARTITION sys_py;
What would be the outcome of this command?
| A. | It executes successfully, and the transition point is set to '1-apr-2006'. |
| B. | It executes successfully, and the transition point is set to '15-apr-2006'. |
| C. | It produces an error because the partitions specified for merging are not adjacent. |
| D. | It produces an error because the date values specified in the merge do not match the date values stored in the table. |
Answer: C
Section: (none)
Explanation/Reference:
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('my_instance_analysis_mode_task') FROM dual;
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments. What would you do to achieve this?
| A. | Add a finding directive for the ADDM task. |
| B. | Add a segment directive for the ADDM task. |
| C. | Add a parameter directive for the ADDM task. |
| D. | Disable the Segment Advisor from the Automatic Maintenance Task. |
Answer: B
Section: (none)
QUESTION 19
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?
| A. | It remains valid. |
| B. | It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used. |
| C. | It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table. |
| D. | It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used. |
Answer: A
Section: (none)
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.)
Exhibit:
| A. | An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error |
| B. | A user belonging to DSS_QUERIES can log in to a new session but the session will be queued |
| C. | The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management |
| D. | The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention |
Answer: BC
Section: (none)
Explanation/Reference:
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? (Choose all that apply.)
| A. | The source database backup must be copied over the net for test database. |
| B. | The source database must be run in ARCHIVELOG mode if the database is open. |
| C. | The source database must be shut down cleanly if the database is in mounted state. |
| D. | A net service name should be set up and a listener configured with the target as well as the source database. |
Answer: BCD
Section: (none)
QUESTION 22
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.
Which is the most efficient method of performing this task?
| A. | disabling the index |
| B. | making the index invisible |
| C. | making the index unusable |
| D. | using the MONITORING USAGE clause for the index |
Answer: B
Section: (none)
Explanation/Reference:
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 for only SecureFile CLOBs |
| C. | deduplication, encryption, and compression settings for all SecureFile LOBs |
| D. | deduplication, encryption, and compression settings only for SecureFile CLOBs |
Answer: C
Section: (none)
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. | all the optimizer statistics |
| C. | initialization parameter settings |
| D. | PL/SQL functions, procedures, and packages |
| E. | the table and index definitions and actual data |
Answer: BCE
Section: (none)
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 |
| C. | Truncate the table. |
| D. | Add a column to the table. |
| E. | Rename a column in the table. |
Answer: D
Section: (none)
QUESTION 26
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 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;
Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)
| A. | They import all metadata from the RCAT10 catalog. |
| B. | They unregister the database from the RCAT10 catalog. |
| C. | They do not register the databases registered in the RCAT10 catalog. |
| D. | They register all databases registered in the RCAT10 catalog. |
Answer: AD
Section: (none)
Explanation/Reference:
QUESTION 27
You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery [Choose two]
| A. | Change the RMAN archived log deletion policy. |
| B. | Use the RMAN CROSSCHECK command to reclaim the archived log space. |
| C. | Change the RMAN retention policy to retain backups for a shorter period of time. |
| D. | Use OS command to move files from the flash recovery area to some other location |
Answer: BD
Section: (none)
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 frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:
SQL> EXECUTE
DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');
You need statistics to be collected more quickly. What can you do to achieve this?
| A. | Set DYNAMIC_SAMPLING to level 4. |
| B. | Set the STATISTICS_LEVEL parameter to BASIC. |
| C. | Set the INCREMENTAL value to TRUE for the partition table. |
| D. | Increase the value of STALE_PERCENT for the partition table. |
Answer: C
Section: (none)
QUESTION 29
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)
| A. | A single ADR can support multiple ADR homes for different database instances. |
| B. | The alert files are stored in XML file format in the TRACE directory of each ADR home. |
| C. | If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE. |
| D. | The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file. |
Answer: AC
Section: (none)
Explanation/Reference:
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 the duration of the maintenance window after it is created. |
| C. | In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours. |
| D. | A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window. |
Answer: AD
Section: (none)
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 transported |
| C. | The transported database must have the same database identifier (DBID) as the source database and cannot be changed |
| D. | The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported |
| E. | Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format |
Answer: DE
Section: (none)
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"
-Are maintaining image copies of the database files
You have lost the server parameter tile (SPFILE) and the control file. Which option must you consider before restoring the SPFILI: and the control file by using the control file autobackup?
| A. | setting DBID for the database |
| B. | using the RMAN SWITCH command |
| C. | using the RMAN SWITCH command |
| D. | starting up the database Instance In the NOMOUNT state |
Answer: C
Section: (none)
QUESTION 33
You want to perform the following operations for the DATA ASM disk group:
-Verify the consistency of the disk.
-Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly.
-Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?
| A. | ALTER DISKGROUP data CHECK; |
| B. | ALTER DISKGROUP data CHECK DISK; |
| C. | ALTER DISKGROUP data CHECK FILE; |
| D. | ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1; |
Answer: A
Section: (none)
Explanation/Reference:
QUESTION 34
Examine the following RMAN command:
BACKUP DATABASE
TAG TESTDB
KEEP UNTIL 'SYSDATE+1'
RESTORE POINT TESTDB06;
Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)
| A. | Only data files and the control file are backed up. |
| B. | Archived redo logs are backed up only if the database is open during the backup. |
| C. | The backup is d after one day, regardless of the default retention policy settings. |
| D. | The backup becomes obsolete after one day, regardless of the default retention policy settings. |
Answer: BD
Section: (none)
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 automatic maintenance window group configuration. |
| B. | Set the CURSOR_SHARING parameter to EXACT for the database instance. |
| C. | Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE. |
| D. | Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance. |
Answer: C
Section: (none)
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 alias metadata directory and the file directory are linked correctly. |
| C. | It repairs blocks by always reading them from the mirror copy and writing them to the original location. |
| D. | It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly. |
Answer: AD
Section: (none)
Explanation/Reference:
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 variable setting affect the installation?
| A. | The installation terminates with an error. |
| B. | The installation proceeds with the default value without warnings and errors. |
| C. | The installation proceeds with the default value but it would not be an OFA-compliant database. |
| D. | The installation proceeds with the default value but a message would be generated in the alert log file. |
Answer: D
Section: (none)
QUESTION 38
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?
| A. | statistics recommendations |
| B. | SQL Profile recommendations |
| C. | Index-related recommendations |
| D. | restructuring of SQL recommendations |
Answer: B
Section: (none)
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. |
| B. | Collect statistics for the related objects. |
| C. | Run the Access Advisor for the SQL statement. |
| D. | Run the Segment Advisor for recommendations. |
Answer: C
Section: (none)
Explanation/Reference:
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 =''CA''';
:task_name := 'MY_QUICKTUNE_TASK';
DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,
:task_name, :sql_stmt);
END;
What is the outcome of this block of code?
| A. | It creates a task and workload, and executes the task. |
| B. | It creates a task and workload but does not execute the task. |
| C. | It produces an error because a template has not been created. |
| D. | It produces an error because the SQL Tuning Set has not been created. |
Answer: A
Section: (none)
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 the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?
| A. | to avoid round trips to the server by enabling caching of query results in client memory |
| B. | to improve performance by storing a copy of the data from the private SQL area of the PGA |
| C. | to enhance the query performance by creating a cache in the client memory for sorting operations |
| D. | to avoid the storing of query plans and results in the server by creating a cache in the client memory |
Answer: A
Section: (none)
Explanation/Reference:
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 process? (Choose all that apply.)
| A. | the SQL text |
| B. | the execution plan |
| C. | the execution context |
| D. | the execution frequency |
| E. | the system change number (SCN) |
Answer: ACD
Section: (none)
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;
Transaction T3 UPDATE hr.regions SET region_name='North and South Poles' WHERE region_id = 5;
You want to back out transaction T2. Which option would you use?
| A. | It is possible, but transaction T3 also backs out. |
| B. | It is possible with the NOCASCADE_FORCE option. |
| C. | It is possible with the NONCONFLICT_ONLY option. |
| D. | It is not possible because it has conflicts with transaction T3. |
Answer: B
Section: (none)
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 Automatic Memory Manager (AMM) |
| B. | The SQL Tuning Advisor |
| C. | The Segment Advisor |
| D. | The SQL Access Advisor |
Answer: D
Section: (none)
Explanation/Reference:
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. | It improves performance as fewer extent pointers are needed in the shared pool. |
| D. | It improves performance by reading from a copy of an extent closest to the node. |
Answer: D
Section: (none)
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 statements. |
| C. | SQL Profile recommendations are not generated for SQL statements. |
| D. | Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. |
Answer: B
Section: (none)
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 incremental backup |
| B. | It will display a list of files that need backup after five days |
| C. | It will display a list of files that were backed up in the last five days |
| D. | It will display a list of files that have not been backed up in the last five days |
| E. | It will apply the current retention policy to determine the files that need to be backed up |
Answer: D
Section: (none)
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 parameter is set to TRUE. |
| B. | The FILESYSTEMIO_OPTIONS parameter is set to NONE. |
| C. | Another session runs the I/O calibration process concurrently. |
| D. | The pending area has not been created before running the I/O calibration process. |
Answer: B
Section: (none)
Explanation/Reference:
QUESTION 49
Which statement about recovering from the loss of a redo log group is true?
| A. | If the lost redo log group is ACTIVE, you should first attempt to clear the log file. |
| B. | If the lost redo log group is CURRENT, you must clear the log file. |
| C. | If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option. |
| D. | If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option. |
Answer: D
Section: (none)
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 more ASM files are dropped |
| C. | when some disks in a disk group are offline |
| D. | when some disks in a failure group for a disk group are rebalancing |
Answer: C
Section: (none)
QUESTION 51
To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:
SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;
What is the significance of this setting?
| A. | It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance. |
| B. | It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again. |
| C. | It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance. |
| D. | It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes. |
Answer: B
Section: (none)
Explanation/Reference:
QUESTION 52
You have the following requirements in relation to the detection of block corruption for your database instance:
Check for logical self-consistency of data blocks when modified in memory.
Checksums are calculated before and after the block change.
Checks are performed for the lost writes to the physical standby database.
Which method would help you perform the above checks automatically?
| A. | Set the DB_SECUREFILE parameter to PERMITTED. |
| B. | Set the DB_ULTRA_SAFE parameter to DATA_ONLY. |
| C. | Set the DB_LOCK_CHECKSUM parameter to TYPICAL. |
| D. | Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL. |
Answer: B
Section: (none)
QUESTION 53
You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use?
| A. | The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm. |
| B. | The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm. |
| C. | The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm. |
| D. | Only the BZIP2 compression algorithm can be used to make compressed backups to disk. |
Answer: A
Section: (none)
QUESTION 54
Evaluate the following function code:
CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESULT_CACHE RELIES_ON
(EMPLOYEES) IS avgsal NUMBER(6);
BEGIN
SELECT AVG(SALARY)INTO avgsal
FROM EMPLOYEES
WHERE DEPARTMENT_ID = dept_id;
RETURN avgsal;
END get_dept_avg;
Which statement is true regarding the above function?
| A. | The cached result becomes invalid when any structural change is done to the EMPLOYEES table. |
| B. | If the function execution results in an unhandled exception, the exception result is also stored in the cache. |
| C. | Each time the function is invoked in a different session, the current result in the result cache gets overwritten. |
| D. | If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value. |
Answer: A
Section: (none)
Explanation/Reference:
QUESTION 55
Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab
2.$ORACLE_HOME/dbs/oranfstab
3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?
| A. | 1, 2, 3 |
| B. | 3, 2, 1 |
| C. | 2, 3, 1 |
| D. | 1, 3, 2 |
Answer: C
Section: (none)
QUESTION 56
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement:
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;
What will be the result of executing this statement?
| A. | One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach. |
| B. | One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach. |
| C. | Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name. |
| D. | None of the tables are recovered from the Recycle Bin, and the statement returns an error. |
Answer: B
Section: (none)
QUESTION 57
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?
| A. | ASMB |
| B. | PMON |
| C. | RBAL |
| D. | SMON |
Answer: A
Section: (none)
Explanation/Reference:
QUESTION 58
Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?
| A. | AWR baselines are always created as repeating baselines. |
| B. | AWR baselines can be created on the basis of two time values. |
| C. | AWR baselines are always created with infinite expiration duration. |
| D. | AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration. |
Answer: B
Section: (none)
QUESTION 59
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?
| A. | ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; |
| B. | ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE |
| C. | ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE |
| D. | ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING; |
Answer: C
Section: (none)
QUESTION 60
For which two situations would you use functionality provided by the Resource Manager? (Choose two.)
| A. | setting idle timeout limits on resource plans |
| B. | saving storage space by using compressed backup sets |
| C. | creating jobs that will run automatically at a scheduled time |
| D. | assigning priorities to jobs to manage access to system resources |
| E. | creating alerts to perform notification when tablespaces are low on available space resources |
Answer: AD
Section: (none)
QUESTION 61
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?
| A. | SQL Repair Advisor |
| B. | SQL Optimizer |
| C. | SQL Access Advisor |
| D. | SQL Tuning Advisor |
Answer: D
Section: (none)
Explanation/Reference:
QUESTION 62
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?
| A. | Data Pump Export and Import |
| B. | conventional export and import |
| C. | the CONVERT command of RMAN |
| D. | the BACKUP AS COPY. command of RMAN |
Answer: D
Section: (none)
QUESTION 63
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?
| A. | point-in-time recovery |
| B. | execute the ROLLBACK command with transaction number |
| C. | flashback the database to before the transaction was committed |
| D. | determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery |
Answer: D
Section: (none)
QUESTION 64
You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?
| A. | The archived redo log files will be overwritten. |
| B. | The archived redo log files are d automatically. |
| C. | The archived redo log files should be moved to some other location. |
| D. | The archived redo log files are still maintained because the file names are unique. |
Answer: D
Section: (none)
QUESTION 65
An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?
| A. | TEST_TBS is a small file tablespace. |
| B. | TEST_TBS is a bigfile tablespace (BFT). |
| C. | TEST_TBS is the default temporary tablespace. |
| D. | TEST_TBS is a dictionary-managed tablespace. |
Answer: D
Section: (none)
Explanation/Reference:
QUESTION 66
Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)
| A. | set SHARED_POOL_SIZE to zero |
| B. | set STATISTICS_LEVEL to BASIC |
| C. | set SGA_TARGET to a non-zero value |
| D. | set DB_CACHE_SIZE to a non-zero value |
| E. | set STATISTICS_LEVEL to TYPICAL or ALL |
Answer: AC
Section: (none)
QUESTION 67
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)
| A. | fixed tables |
| B. | heap tables |
| C. | external tables |
| D. | temporary tables |
| E. | Index-Organized Tables (IOTs) |
Answer: BE
Section: (none)
QUESTION 68
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';
Which statement regarding the above command is correct?
| A. | It will create the tablespace TEMP1 in group G1. |
| B. | It will create the tablespace TEMP1 in group G3. |
| C. | It will not add the tablespace TEMP1 to any group. |
| D. | It will create the tablespace TEMP1 in the default group. |
Answer: C
Section: (none)
QUESTION 69
The EMP table exists in your schema. You want to execute the following query:
SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)
WHERE ename = 'ALLEN';
What are the minimum requirements for the statement to execute successfully? (Choose all that apply)
| A. | ARCHIVELOG mode must be enabled |
| B. | Row Movement must be enabled for the table |
| C. | FLASHBACK must be set to ON for the database |
| D. | The UNDO_MANAGEMENT parameter must be set to AUTO |
| E. | The UNDO_RETENTION parameter must be set appropriately |
Answer: DE
Section: (none)
Explanation/Reference:
QUESTION 70
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?
| A. | The EMPLOYEES table will be changed to read-only mode during the shrink operation. |
| B. | The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over. |
| C. | The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation. |
| D. | Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation. |
Answer: C
Section: (none)
QUESTION 71
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?
| A. | Create two custom ADDM tasks. |
| B. | Modify the AWR snapshot time interval to two hours. |
| C. | Create a new scheduler window for a time period of two hours. |
| D. | Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours. |
Answer: B
Section: (none)
QUESTION 72
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.
You can use Segment Advisor to _____.
| A. | identify the segments that you should shrink |
| B. | modify the storage parameters for the tablespace |
| C. | automatically shrink the segments with unused space |
| D. | check the alerts generated for the tablespace that is running low on space |
Answer: A
Section: (none)
Explanation/Reference:
QUESTION 73
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)
| A. | You are backing up to tape and your tape device performs its own compression. |
| B. | You are making image copies, and you have not enabled tablespace compression. |
| C. | You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited. |
| D. | You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage. |
| E. | You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage. |
Answer: CDE
Section: (none)
QUESTION 74
Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)
| A. | Define the POWER option while adding or removing the disks. |
| B. | Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT. |
| C. | Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES. |
| D. | Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES. |
Answer: AB
Section: (none)
QUESTION 75
View the Exhibit.
As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals.
Which background process performs this activity?
| A. | CKPT |
| B. | SMON |
| C. | MMON |
| D. | DBWR |
Answer: C
Section: (none)
Explanation/Reference:
QUESTION 76
Identify three key features of ASM. (Choose three.)
| A. | file striping |
| B. | allocation unit mirroring |
| C. | automatic disk rebalancing |
| D. | automatic file size increment |
| E. | automatic undo management |
Answer: ABC
Section: (none)
QUESTION 77
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :
SQL> shutdown immediate;
What is the result of executing this command?
| A. | The ASM instance is shut down, but the other instances are still running. |
| B. | It results in an error because other database instances are connected to it. |
| C. | All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. |
| D. | HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode. |
Answer: B
Section: (none)
Explanation/Reference:
QUESTION 78
You enable block change tracking. You issue the following command:
BACKUP INCREMENTAL LEVEL 0 DATABASE;
The next day, you issue the following command:
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which statement about the use of the change tracking file is true?
| A. | RMAN reads the block change tracking file only when it performs the incremental level 0 backup. |
| B. | RMAN reads the block change tracking file when it performs both incremental backups. |
| C. | RMAN reads the block change tracking file only when it performs the incremental level 1 backup. |
| D. | RMAN does not read the block change tracking file when it performs either incremental backup. |
Answer: C
Section: (none)
QUESTION 79
You executed the following command:
RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';
Which statement regarding the above command is correct?
| A. | The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy. |
| B. | The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup. |
| C. | Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. |
| D. | Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails. |
Answer: C
Section: (none)
QUESTION 80
Which two statements regarding a SQL profile are true? (Choose two.)
| A. | It is built by Automatic Tuning Optimizer. |
| B. | It cannot be stored persistently in the data dictionary. |
| C. | It can be used by the query optimizer automatically. |
| D. | It can be created manually by using the CREATE PROFILE command. |
Answer: AC
Section: (none)
Explanation/Reference:
QUESTION 81
Evaluate the following command and its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)
| A. | FREE_SPACE indicates only the space that is currently unallocated. |
| B. | ALLOCATED_SPACE indicates only the space currently allocated and in use. |
| C. | FREE_SPACE indicates only the space that is currently allocated and available for reuse. |
| D. | ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse. |
| E. | FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated. |
Answer: DE
Section: (none)
QUESTION 82
Identify the three predefined server-generated alerts. (Choose three.)
| A. | Drop User |
| B. | Tablespace Space Usage |
| C. | Resumable Session Suspended |
| D. | Recovery Area Low On Free Space |
| E. | SYSTEM Tablespace Size Increment |
Answer: BCD
Section: (none)
QUESTION 83
Which three actions are required to configure the Flashback Database? (Choose three.)
| A. | set Flash Recovery Area |
| B. | enable Flashback logging |
| C. | create FLASHBACK tablespace |
| D. | start the database in the ARCHIVELOG mode |
| E. | start the database in the NOARCHIVELOG mode |
Answer: ABD
Section: (none)
QUESTION 84
View the Exhibit and examine the Data Pump architecture.
Identify the numbered components.
| A. | 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API |
| B. | 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader |
| C. | 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump |
| D. | 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump |
Answer: A
Section: (none)
Explanation/Reference:
QUESTION 85
You executed the following command to drop a user:
DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)
| A. | All the objects of scott are moved to the Recycle Bin. |
| B. | Any objects in the Recycle Bin belonging to scott are purged. |
| C. | All the objects owned by scott are permanently dropped from the database. |
| D. | All the objects of scott in the Recycle Bin must be purged before executing the DROP command. |
| E. | Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command. |
Answer: BC
Section: (none)
QUESTION 86
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.
The steps to recover the damaged data files are follows:
1. Mount the database
2. Open the database
3. Recover the data file
4. Restore the data file
5. Make the data file offline
6. Make the data file online
Which option identifies the correct sequence that you must use to recover the data files?
| A. | 2, 4, 3 |
| B. | 1, 4, 3, 2 |
| C. | 2, 5, 4, 3, 6 |
| D. | 5, 2, 4, 3, 6 |
| E. | 1, 5, 4, 3, 6, 2 |
Answer: E
Section: (none)
Explanation/Reference:
QUESTION 87
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two).
| A. | The backup as copy can only be taken to disk |
| B. | The backup as copy can only be taken to tape |
| C. | Backup can be performed only when the instance is shutdown |
| D. | Backup will constitute all used and unused blocks in the database |
Answer: AD
Section: (none)
QUESTION 88
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:
Which statement is true about the outcome?
| A. | Only one channel is allocated and the backup is created in the flash recovery area |
| B. | Only one channel is allocated and the backup is created in the destination specified for channel |
| C. | Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2 |
| D. | Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA |
Answer: A
Section: (none)
Explanation/Reference:
QUESTION 89
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?
| A. | Open the database in NORMAL mode |
| B. | Open the database in read-only mode |
| C. | Open the database in RESTRICTED mode |
| D. | Open the database with the RESETLOGS option |
Answer: D
Section: (none)
QUESTION 90
View the exhibit and examine the output. Which statement can be an inference from the output? Exhibit:
| A. | The FRA disk group has an asynchronous I/O bottleneck |
| B. | The least number of I/Os are performed on the last data file in the list |
| C. | The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list |
| D. | The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group |
Answer: A
Section: (none)
Explanation/Reference:
QUESTION 91
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:
SQL> SELECT * FROM sales;
Which process would retrieve the result from the database and return it to the client program?
| A. | User process |
| B. | Server process |
| C. | System Monitor (SMON) |
| D. | Process Monitor (PMON) |
| E. | Checkpoint process (CKPT) |
Answer: B
Section: (none)
QUESTION 92
You observed the following output for a user session:
What do you infer from the preceding output?
| A. | Resumable set for session with sid 18 |
| B. | The user session has entered into a deadlock |
| C. | The database instance is enabled to use asynchronous commit |
| D. | The threshold warning limit is exceeded for the tablespace that is used by the user session |
Answer: A
Section: (none)
QUESTION 93
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option? (Choose two)
| A. | Control files |
| B. | Password files |
| C. | Inactive online redo log file |
| D. | Archived log files required to perform recovery |
| E. | Newly created tablespace which is not backed up |
Answer: AD
Section: (none)
Explanation/Reference:
QUESTION 94
Multiple RMAN sessions are connected to the database instance.
Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?
| A. | Implement RMAN multiplexing |
| B. | Set the DEBUG ON in the RMAN script |
| C. | Specify the command ID in the RMAN script |
| D. | Use a tag with the RMAN BACKUP command |
Answer: C
Section: (none)
QUESTION 95
Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:
RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO auxdb; }
Which statement is true about the duplicate database in this scenario?
| A. | It contains data till the last backup |
| B. | It contains all data from target database until the current time |
| C. | It contains all data from only the committed transactions in the target database |
| D. | It contains all data except that which is used by the transactions in the current online redo file of target database |
Answer: D
Section: (none)
QUESTION 96
Examine the following command:
SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed?
| A. | The shrink operation touches every block in the BOOKING table |
| B. | The high-water mark (HWM) for the BOOKING table is shifted from its original position |
| C. | The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table |
| D. | The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation |
Answer: C
Section: (none)
Explanation/Reference:
QUESTION 97
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.
Which two statements are true regarding the outcome of this action? (Choose two)
| A. | All the related indexes and views are automatically dropped |
| B. | The flashback drop feature can recover only the table structure |
| C. | Only the related indexes are dropped whereas views are invalidated |
| D. | The flashback drop feature can recover both the table structure and its data |
Answer: CD
Section: (none)
QUESTION 98
You plan to execute the following command to perform a Flashback Database operation in your database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);
Which two statements are true about this? (Choose two)
| A. | The database must have multiplexed redo log files |
| B. | The database must be in the MOUNT state to execute the command |
| C. | The database must be in the NOMOUNT state to execute the command |
| D. | The database must be opened in RESTRICTED mode before this operation |
| E. | The database must be opened with the RESETLOGS option after the flashback operation |
Answer: BE
Section: (none)
QUESTION 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_resources_manager.validate_pending_area ( );
What could be the reason?
Exhibit:
| A. | The pending area is automatically submitted after the plan creation |
| B. | The procedure must be executed before creating the resources plan directive |
| C. | The SYS_GROUP resource consumer group is not included in the resource plan directive |
| D. | The OTHER_GROUPS resources consumer group is not included in the resource plan directive |
Answer: D
Section: (none)
Explanation/Reference:
【ocp培训考试相关】相关文章：
科目一考试的相关事宜10-21
科目一考试的相关技巧07-19
科目四的考试相关信息09-26
科目一考试处罚相关条例06-19
最新科目二考试的相关规则10-10
科目四理论考试内容及相关题目09-13
2017年执业医师报名考试相关简介09-11
客服培训考试10-18
报考银行从业资格考试相关问题资询08-19
雅思考试需要注意的相关事项07-21