Posts

Showing posts with the label 1z0-020 Oracle8i: New Features for Administrators Part 1

1z0-020 Oracle8i: New Features for Administrators Part 1

Oracle8i: New Features for Administrators Part 1 get Full version on:  http://www.updateddumps.com/ QUESTION 1 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. Correct Answer: AD Section: (none) Explanation Explanation/Reference: QUESTION 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 i...