CUUG内部OCP题库解析-053-文档8

CUUG内部OCP题库解析-053-文档8题库新特点：oracle 11g版本的ocp 053认证考试是所有这几科里数量最多的考试了，cuug整理了近期的053考题，并进行了讲解。下面的题是（053考试-第2个文档）里的一些考题。其他题找相关文档，或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/1981.Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space;TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACETEMP 250609664 101048576 149561088Which 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 andavailable 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 andavailable for reuse, and the space that is currently unallocated.Answer: DE考点：临时表空间的空间是共享的，当一个事物完成后，原来所占的空间就会释放，允许给其它事务使用。82.Identify the three predefined server-generated alerts. (Choose three.) A. Drop UserB. Tablespace Space UsageC. Resumable Session SuspendedD. Recovery Area Low On Free SpaceE. SYSTEM Tablespace Size IncrementAnswer: BCD预警是当数据库处于不理想状态且需要引起注意时发出的通知。默认情况下，Oracle DB通过Enterprise Manager Database Control 提供预警。也可选择配置Enterprise Manager 以向管理员发送有关问题状况的电子邮件，还可在控制台上显示预警信息。另外，还可为系统的多个相关度量设置阈值。如果数据库偏离正常读数太多而达 到了这些阈值，Oracle Database 11g会预先发送通知。提前通知潜在的问题，可使 用户迅速作出响应，并通常在用户注意到这些问题之前就解决这些问题。 默认情况下受监视的度量大约有60 个，其中包括：. 中断作业计数. 等待所用的数据库时间百分比(%). 转储区占用率(%). 参照基线的SQL 响应时间百分比(%). 表空间占用率(%). 一般意外事件Alerts are automatically generated when a problem occurs or when data does notmatch expected values for metrics, such as the following:l Physical Reads Per Second l User Commits Per Second l SQL Service Response TimeExamples of alerts not based on threshold levels are: l Snapshot To o Oldl Resumable Session Suspendedl Recovery Area Space Usage83.Which three actions are required to configure the Flashback Database?(Choose three.)A. set Flash Recovery Area B. enable Flashback loggingC. create FLASHBACK tablespaceD. start the database in the ARCHIVELOG modeE. start the database in the NOARCHIVELOG modeAnswer: ABD84.View the Exhibit and examine the Data Pump architecture. Identify thenumbered components.A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path APIB. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle LoaderC. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data PumpD. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data PumpAnswer: A85.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 executingthe DROP command.E. Any objects in the Recycle Bin belonging to scott will not be affected by theabove DROP command.Answer: BC86.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 file5. Make the data file offline 6. Make the data file onlineWhich option identifies the correct sequence that you must use to recover the data files?A. 2, 4, 3B. 1, 4, 3, 2C. 2, 5, 4, 3, 6D. 5, 2, 4, 3, 6E. 1, 5, 4, 3, 6, 2Answer: B87.You want to perform an RMAN backup of database as a copy. Which twofactors will you consider while performing the backup operation? (Choosetwo).A. The backup as copy can only be taken to diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the instance is shutdownD. Backup will constitute all used and unused blocks in the databaseAnswer: AD88.In your database, the flash recovery area (FRA) is configured as the defaultfor RMAN backups. You executed the following commands to configure thesettings in RMAN:Which statement is true about the outcome?A. Only one channel is allocated and the backup is created in the flash recoveryareaB. Only one channel is allocated and the backup is created in the destinationspecified for channelC. Two channels are allocated and backup sets are created in the destinationsspecified for channels 1 and 2D. Three channels are allocated and backup sets are created in the destinationsspecified for channels 1, 2, and FRAAnswer: A89.Yo