Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Oracle 1Z0-020
Title
: Oracle8l:New
Features for
Administrators
Version : V5.73
1. Which two statements are true? (Choose two)
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
A. Dimensions are based on summaries.
B. The ALTER MATERIALIZED VIEW CONSIDER FRESH statement directs Oracle to
consider the materialized view fresh, and therefore eligible for query rewrite in the
TRUSTED or STALE_TOLERATED mode only.
C. Summaries without dimensions are used for faster aggregation.
D. Additional query rewrites at a higher level of aggregation can take place if summaries
are created at the lowest level of aggregation.
Answer: AD
2. Which two statements are true? (Choose two)
A. Composite partitioning supports local indexes.
B. Composite partitioning supports hash-partitioned global indexes.
C. Composite partitioning supports range-partitioned global indexes
D. Composite partitioning supports composite-partitioned global indexes.
Answer: BD
3. Which tool, integrated with Oracle universal installer, can be used by third-party
vendors to install their products as art of an Oracle installation?
A. Oracle Software Packager.
B. Java Run-Time environment.
C. Database migration assistant.
D. Optimal flexible architecture.
Answer: A
4. Which two options are valid for LOBs during their creation? (Choose two)
A. REDO
B. NOREDO
C. LOGGING
D. NOLOGGING
E. RECOVERABLE
F. UNRECEOVERABLE
Answer: CD
5. You set the PARALLEL_AUTOMATIC_TUNING initialization parameter to FALSE. What
happens? (Choose two)
A. Parallel execution buffers are allocated from the large pool.
B. Parallel execution buffers are allocated from the shared pool.
C. Only tables with a degree of parallelism specified will be scanned in parallel.
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
D. A load balancing algorithm will be used to distribute evenly load across no