1z0-020 Exam

- Covers the entire recommended syllabus
- Comprehensive questions and answers about 1z0-020 exam
- Verified Answers Researched by Industry Experts and almost 100% correct
- 1z0-020 exam questions updated on regular basis
- Same type as the certification exams, 1z0-020 exam preparation is in multiple-choice questions (MCQs)
- Tested by multiple times before publishing
- Try free 1z0-020 exam demo before you decide to buy it in Hiexam
- Technical support through Live Chat or Email

　
　
Exam : Oracle 1Z0-020
Title : Oracle8l:New Features for Administrators


1. 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

2. 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

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 statements are true? (Choose two)
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

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.
D. A load balancing algorithm will be used to distribute evenly load across nodes in a multi instance PQ environment.
Answer: BC

http://www.Hiexam.com The safer.easier way to get Other Oracle Certification Certification.