v12.02专题
OCP-1Z0-053-V12.02-595题
595.Which dynamic view displays the status of block-change tracking? A. V$BLOCK_CHANGE B. V$BLOCK_CHANGE_TRACKING C. V$BLOCKCHANGE D. V$BLOCK_TRACKING Answer: B 答案解析： V$BLOCK_CHANGE_TRACKING
OCP-1Z0-053-V12.02-584题
584.How is block-change tracking enabled? A. With alter database enable block change tracking B. With alter system enable block change tracking C. With an init.ora parameter change D. With an spfi
OCP-1Z0-053-V12.02-234题
234.Which type of backup contains only the blocks that have changed since the last level 0 incremental backup? A. a cumulative level 1 backup B. a differential level 1 backup C. a full backup D.
OCP-1Z0-053-V12.02-548题
548.What are the different logging modes available in Oracle Database 11g? (Choose two.) A. NOLOG mode B. NOARCHIVELOG mode C. LOGGING mode D. HOTDATABASE mode E. ARCHIVELOG mode Answer: BE
OCP-1Z0-053-V12.02-549题
549.Which is the correct command to put the database in ARCHIVELOG mode? A. alter database archivelog B. alter system enable archivelog mode C. alter database enable archive D. alter database arch
OCP-1Z0-053-V12.02-388题
388.Flashback Database relies on which technologies to recover to a point in time? A. Flashback Data Archive B. Flashback logs in the flash recovery area C. FlashbUndo tablespace D. RMAN command
OCP-1Z0-053-V12.02-313题
313.What command would you issue to enable automated backups of control files? A. alter database controlfile autobackup on B. alter system controlfile autobackup on C. configure controlfile auto
OCP-1Z0-053-V12.02-381题
381.Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query? A. XID B. VERSIONS_PK C. VERSIONS_XID D. VERSIONS_UNIQUE Answer: C 答案解析： 参考：闪回版本查询：http://blog.cs
OCP-1Z0-053-V12.02-390题
390.Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.) A. SCN B. Timestamp C. Named recovery point D. Transaction ID E. Session ID Answer: ABC 答案解
OCP-1Z0-053-V12.02-391题
391.When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.) A. Tablespace name B. Storage quota C. Retention D. Table name E. Create a d
OCP-1Z0-053-V12.02-530题
530.When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instances disk groups? A. TRANSACTIONAL B. IMMEDIATE C. ABO
OCP-1Z0-053-V12.02-173题
173.Which of the following is not a configurable attribute for an individual disk group? A. AU_SIZE B. COMPATIBLE.RDBMS C. COMPATIBLE.ASM D. DISK_REPAIR_TIME E. DG_DROP_TIME Answer: E 答案解析：
OCP-1Z0-053-V12.02-76题
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 A
OCP-1Z0-053-V12.02-525题
525.What components are present in an ASM instance? (Choose three.) A. SGA B. Database processes C. Database datafiles D. Control files E. Database parameter file or spfile Answer: ABE 答案解析： 参
OCP-1Z0-053-V12.02-57题
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 答
OCP-1Z0-053-V12.02-529题
529.Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup? A. ASM_DISKMOUNT B. ASM_DISKGROUP C. ASM_DISKSTRING D. ASM_MOUNTGR
OCP-1Z0-053-V12.02-186题
186.What is the purpose of the RMAN recovery catalog? (Choose all that apply.) A. Make backups faster B. Store RMAN metadata C. Store RMAN scripts D. Provide the ability to do centralized backup r
OCP-1Z0-053-V12.02-188题
188.You can back up the RMAN recovery catalog with RMAN. A. True B. False Answer: A 答案解析： 参考： http://blog.csdn.net/rlhua/article/details/13169205 恢复目录是一个Ora cle D B，因此与任何数据库一样，需要进行 备份。Ora
OCP-1Z0-053-V12.02-187题
187.RMAN provides more granular catalog security through which feature? A. Virtual private database B. Virtual private catalog C. RMAN virtual database D. RMAN secure catalog E. Oracle Database V
OCP-1Z0-053-V12.02-211题
211.You want to disable resumable space allocation for all sessions. Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions? A. 0
OCP-1Z0-053-V12.02-180题
180.Which command is used to open the database after an incomplete recovery? A. alter database open B. alter database open repairlog C. alter database open resetlogs D. alter database open resetlo
OCP-1Z0-053-V12.02-174题
174.What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode? A. MMON B. LGWR C. ARCH D. ARWR E. COPY Answer: C 答案解析： ARCH指归档进程，只有在归档模式下的数据库才会
OCP-1Z0-053-V12.02-75题
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
OCP-1Z0-053-V12.02-373题
373.Which of the following Oracle features utilize the undo tablespace? (Choose all that apply) A. Flashback Query B. Flashback Drop C. Flashback Table D. Flashback Database E. Transaction Pro
OCP-1Z0-053-V12.02-82题
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 Tab
OCP-1Z0-053-V12.02-354题
354.Which command is used to begin a tablespace point-in-time recovery? A. Restore tablespace B. Recover tablespace C. Tablespace recover D. Recover to time E. recover datafile Answer: B 答案解