利用Visual CertExam Suite自己制作模拟试题
准备类似下面格式的文本文件,然后运行Designer,选择import
Exam : 1Z0- 040
Title : Oracle Database 10g: New Features for Administrators
Ver : 03-27-07
Q1.
Which three methods can you use to run an Automatic Database Diagnostic
Monitor (ADDM) analysis over a specific time period? (Choose three.)
A. Enterprise Manager GUI
B. DBMS_TRACE package APIs
C. DBMS_ADVISOR package APIs
D. DBMS_MONITOR package APIs
E. $ORACLE_HOME/rdbms/admin/addmrpt.sql script
Answer: A, C, E
Explanation:
-----------------
To make use of ADDM, a PL/SQL interface called DBMS_ADVISOR has been
implemented. This PL/SQL interface may be called through the supplied
$ORACLE_HOME/rdbms/admin/addmrpt.sql script, called directly, or used in
combination with the Oracle Enterprise Manager application. Besides this
PL/SQL package a number of views (with names starting with the DBA_ADVISOR_
prefix) allow retrieval of the results of any actions performed with the
DBMS_ADVISOR API. The preferred way of accessing ADDM is through the
Enterprise Manager interface, as it shows a complete performance overview
including recommendations on how to solve bottlenecks on a single screen.
When accessing ADDM manually, you should consider using the ADDMRPT.SQL
script provided with your Oracle release, as it hides the complexities
involved in accessing the DBMS_ADVISOR package.
Q2.
Which background process does Automatic Shared Memory Management use to
coordinate the sizing of memory components?
A. PMON
B. SMON
C. MMNL
D. MMAN
E. MMON
Answer: D
The Automatic Shared Memory Management feature uses a new background process
named Memory Manager (MMAN). MMAN serves as the SGA Memory Broker and
coordinates the sizing of the memory components. The SGA Memory Broker keeps track
of the sizes of the components and pending resize operations
REF.: Metalink Note:268197.1: New Background Processes In 10g
Q3.
Which six files are maintained in the Flash Recovery Area? (Choose six.)
A. control file
B. RMAN files
C. password file
D. parameter file
E. flashback logs
F. data file copies
G. core dump files
H. archived log files
I. RMAN recovery scripts
J. control file autobackpus
Answer: A, B, E, F, H, J
The Flash Recovery Area is a unified storage location for all recovery-related files and
activities in an Oracle Database. It includes Control File, Archived Log Files, Flashback
Logs, Control File Autobackups, Data Files, and RMAN files.
|