ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库100200之间题.docx

1、ORACLE 11G OCP 管理2 WorkshopII 1Z0053 题库100200之间题QUESTION 100Examine the following command that is used to duplicate a database on the same host:RMAN RUNALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; Which two statements describe the effect after

2、the database is duplicated successfully? (Choose two)A.The data files of the read-only tablespaces in the target database are not duplicatedB.The read-only tablespaces in the target database are still defined in new the databaseC.The read-only tablespaces in the target database are changed to online

3、 after duplicationD.The data files of the read-only tablespaces in the target database get duplicatedE.The read-only tablespaces in the target database are not defined in the new databaseAnswer: ABSection: (none)QUESTION 101Identify two situations in which you can use Data Recovery Advisor for recov

4、ery. (Choose two.)A.The user has dropped an important table that needs to be recovered.B.The database files are corrupted when the database is open.C.You are not able to start up the database instance because the required database files are missing.D.The archived log files are missing for which back

5、up is not available.Answer: BCSection: (none)QUESTION 102Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/ora

6、cle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The environment variables have the following value:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1What is the location of the Automatic Diagnostic Repository (ADR) home?A./u01/app/oracle/product/11.1.0/db_1B./u01/app/oracleC.$OR

7、ACLE_HOME/bdumpD.$ORACLE_HOME/logAnswer: BSection: (none)QUESTION 103Observe the following PL/SQL block:BEGINdbms_spm.configure(SPACE_BUDGET_PERCENT, 30);END;Which statement is correct regarding the above PL/SQL block?A.It automatically purges the SQL management objects when SMB occupies more than 3

8、0% of the SYSAUX tablespace.B.It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).C.It reserves 30% of the space in the SYSTEM tablespace for SMB.D.It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.Answer: DSe

9、ction: (none)Explanation/Reference:QUESTION 104You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which sta

10、tements will be true in this scenario? (Choose all that apply.)A.The disk is immediately dropped from the disk group.B.The ASM tracks the extents that are modified during the outaC.The ASM migrates the extents from the unavailable disk to the remaining disks.D.The disk automatically goes offline.Ans

11、wer: BDSection: (none)QUESTION 105Which statements are true regarding table compression? (Choose all that apply.)A.It saves disk space and reduces memory usage.B.It saves disk space but has no effect on memory usage.C.It incurs extra CPU overhead during DML as well as direct loading operations.D.It

12、incurs extra CPU overhead during DML but not direct loading operations.E.It requires uncompress operation during I/O.Answer: ACSection: (none)QUESTION 106You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three ye

13、ars for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?A.Enable Flashback Data Archive for the tables.B.Specify undo retention guarantee for the database.C.Enable supplemental logging for the database.D.Q

14、uery V$UNDOSTAT to determine the amount of undo that will be generated and create an undotablespace for that size.E.Create Flashback Data Archive on the tablespace on which the tables are stored.Answer: ASection: (none)QUESTION 107Which components are needed for successful and most efficient recover

15、y.A.The backup RB3 and the current online redo log filesB.the backup RB2 and the archived redo log files after the log sequence number 15622C.Backup R81 and the archived redo log hies after the log sequence number 12871D.The backup RB3 and the archived redo log files after the log sequence number 16

16、721Answer: ASection: (none)Explanation/Reference:QUESTION 108You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore co

17、mmand. Which of these methods would you use to achieve this? (Choose all that apply.)A.Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.B.Restore the disk group

18、 with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.C.Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.D.Restore metadata in

19、 an existing disk group by passing the existing disk group name as an input parameter.Answer: BCDSection: (none)QUESTION 109Which statement describes the effect of table redefinition on the triggers attached to the table?A.All triggers on the table are invalidated and are automatically revalidated w

20、ith the next DML execution on the table.B.All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.C.All triggers on the table remain valid.D.Only triggers that are affected by the changes to the structure of the table are invalidated and a

21、utomatically revalidated with the next DML execution on the table.Answer: ASection: (none)QUESTION 110You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baselin

22、e. What is the correct action to achieve this?A.Create and populate a SQL Tuning Set from the AWR on every Monday.B.Change the RETENTION setting for the AWR snapshots to 7 days on Monday.C.Create a repeating baseline template.D.Insert a finding directive for future ADDM tasks.Answer: CSection: (none

23、)QUESTION 111Which three statements are true regarding persistent lightweight jobs? (Choose three.)A.Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.B.The user cannot set privileges on persistent lightweight jobs.C.Persistent lightweight jobs are us

24、eful when users need to create a large number of jobs in a short time.D.Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.E.The use of a template is mandatory to create persistent lightweight jobs.Answer: BCESection: (none)Explanation/Refer

25、ence:QUESTION 112Your database initialization parameter file has the following entry:SEC_MAX_FAILED_LOGIN_ATTEMPTS=3Which statement is true regarding this setting?A.It drops the connection after the specified number of login attempts fail for any user.B.It is enforced only if the password profile is

26、 enabled for the user.C.It locks the user account after the specified number of attempts.D.It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.Answer: ASection: (none)QUESTION 113Which statement is true regarding virtual private cata

27、logs?A.A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B.The virtual private catalog owner cannot create and modify the stored scripts.C.The set of views and synonyms that make up the virtual private catalog is stored in the sche

28、ma of the RMAN recovery catalog owner.D.To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.Answer: DSection: (none)QUESTION 114Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Data

29、base 11g? (Choose all that apply.)A.Generate reports on data failure such as data file failures.B.You can track the Service Request (SR) and implement repairs.C.You can package and upload diagnostic data to Oracle Support.D.You can manually run health checks to gather diagnostic data for a problem.A

30、nswer: BCDSection: (none)QUESTION 115What are the advantages of variable extent size support for large ASM files? (Choose two.)A.It improves resync operations when the disk comes online after being taken offline for maintenance purposes.B.It improves performance in the extended cluster configuration

31、 by reading from a local copy of an extent.C.Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.D.This feature enables faster file opens because of the reduction in the amount of memory that is requiredto store file extents.Answer: CDSection: (none)Explanation/Reference:QUESTION 116Which two are the uses of the ASM metadata