必威体育精装版ocp考试题库Oracle.1Z0-052解析.docx

Exam A QUESTION 1 You perform differential incremental level 1 backups of your database on each working day and level 0backup on Sundays, to tape.Which two statements are true about differential incremental backups? (Choose two.)A.The backup performed on Sundays contains all the blocks that have ever been used in the database.B.The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.C.The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.D.The backup performed on Monday contains all the blocks that have changed since the level 0 backup, and every other working day contains all the blocks that have changed since the level 1 backup.答案：AD解析：题目的意思是，在星期天执行0级备份，在其他时候执行1级备份，备份路径为磁带上级别0增量备份包含指定数据文件中的所有块，但从未使用过的块除外，等同于一个数据文件完全备份，完全备份策略不能与增量备份策略共用，它是独立，级别1有两种类型，一种是微分备份，它备份上一个级别0或1之后发生了变化的块。一种是累积备份，它备份上一个级别0备份以来所有发生了变化的块因此A正确，B错误，C错误这个时累计备份（Cumulative Incremental ），D正确，这个就是differential incrementalQUESTION 2 View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities:SQL SELECT substr(component, 0, 10) COMP, current_size CS,user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0;What do you infer from this?A.The database instance is running with manual PGA management.B.The database instance is running with manual shared memory management.C.The database instance has the MEMORY_TARGET value set to a nonzero value.D.All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.MM is set to 100 MB.答案：C解析：从图中可以看出sga_target和pga_target三次都不一样，说明启用了amm因此选择C， V$MEMORY_DYNAMIC_COMPONENTS：动态查询各个内存组件的大小QUESTION 3 Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) A.The database files are corrupted when the database is open.B.The us