CUUG内部OCP题库解析-053-文档7
CUUG内部OCP题库解析-053-文档7题库新特点：oracle 11g版本的ocp 053认证考试是所有这几科里数量最多的考试了，cuug整理了近期的053考题，并进行了讲解。下面的题是（053考试-第7个文档）里的一些考题。其他题找相关文档，或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/1966.Which two initialization parameters would you set to enableAutomatic Shared Memory Management? (Choose two.)A. set SHARED_POOL_SIZE to zero B. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALLAnswer: CE67.On which two database objects can the VERSIONS clause of theFlashback Versions Query be used? (Choose two.)A. fixed tables B. heap tablesC. external tables D. temporary tablesE. Index-Organized Tables (IOTs) Answer: BE68.You have three temporary tablespace groups named G1, G2, and G3 inyour 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: C69.The EMP table exists in your schema. You want to execute thefollowing query: SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)WHERE ename = 'ALLEN'What are the minimum requirements for the statement to executesuccessfully? (Choose all that apply)A.ARCHIVELOG mode must be enabledB.Row Movement must be enabled for the tableC.FLASHBACK must be set to ON for the databaseD.The UNDO_MANAGEMENT parameter must be set to AUTOE.The UNDO_RETENTION parameter must be set appropriatelyAnswer: DE70.You executed the following SQL statement to shrink the EMPLOYEEStable 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 theshrink operation.B. The indexes created on the EMPLOYEES table will need to be rebuilt afterthe shrink operation is over.C. The shrink behavior will be cascaded to all dependent segments of thetable that support a shrink operation.D. Data manipulation language (DML) operations will not be possible on theEMPLOYEES table during the COMPACTION phase of the shrink operation.Answer: C-cascade 会级联对其依赖对象（比如索引）进行压紧操作71.The Automatic Database Diagnostic Monitor (ADDM) analysis runs every60 minutes on your database. Your database is facing a series of interrelatedproblems over a period of two hours. Yo u need to ensure that the ADDManalysis 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 retentionperiod to two hours.Answer: B72.You have 100 segments in the USERS tablespace. You realize that theUSERS tablespace is running low on space. You can use Segment Advisor to _.A. identify the segments that you should shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low onspace Answer: AThe Segment Advisor generates the following types of advice:l If the Segment Advisor determines that an object has a significant amount of free space, it recommends online segment shrink. If the object is a table that is not eligible for shrinking, as in the case of a table in a tablespace without automatic segment space management, the Segment Advisor recommends online table redefinition.l If the Segment Advisor determines that a table could benefit from compression with the OLTP compression method, it makes a recommendation to that effect. (Automatic Segment Advisor only. See?"Automatic Segment Advisor".)l If the Segment Advisor encounters a table with row chaining above a certainthreshold, it records that fact that the table has an excess of chained rows.73.You are using Recovery Manager (RMAN) to perform backups. Inwhich three situations would you perform a compressed backup? (Choosethree.)A. You are backing up to tape and your tape device performs its owncompression.B. You are making image copies, and you have not enabled tablespacecompression.C. You are using disk-based backups and disk space in your FlashRecovery Area, or other disk-based backup destinations are limited.D. You are performing your backups to some device over a network wherereduced network bandwidth is more important than CPU usage.E. You are using some archival backup media, such as CD or DVD, wherereducing backup sizes saves media costs and archival storage.Answer: CDE74.Immediately after adding a new disk to or removin
