2018年OCP 052最新考试题库解析-20180608
题库新特点:
更加灵活,题库的顺序与考试时的顺序每场都在变化
更加考验知识点的掌握,题库答案为二,考试时要求选择最佳一个答案
整理:CUUG
1、Which three are true about undo segments and undo tablespaces in the same database and instance?
?A. Multiple transactions run by the same Oracle user can share a single undo segment.
?B. Multiple transactions run by different Oracle users can share a single undo segment.
?C. A serial transaction can use multiple undo segments.
?D. Undo segments are automatically dropped shortly after transactions that use them commit. ?E. A new undo segment is always created for each transaction.
?F. A database can have multiple undo tablespaces.
?Correct Answer: ABF
2、Which two are true about the Data Recovery Advisor?
?A. It can be used only for databases that are running in ARCHIVELOG mode.
?B. It can be used when the database is closed.
?C. It can be used to validate database recovery strategies.
?D. It provides intelligent database problem analysis.
?E. It can be used to validate database backup strategies.
?F. It can be used only for databases with FLASHBACK enabled.
?Correct Answer: CD
3、Which two are true about Oracle Data Pump in Oracle Database 11g Release 2?
?A. If the directory used in the export operation has existing dump files, it overwrites them. ?B. It allows encryption to be performed without using a password.
?C. It supports the renaming of tables during import.
?D. It supports the export of specific views as tables.
?E. It allows compression levels to be defined for the export.
?Correct Answer: BE