Read online free dumps for Oracle- 1z0-020

Here you can read online questions and answers for Oracle Exam 1z0-020 (Oracle8i New Features for Administrators ) 100% free...

Question ID 7725

Which two statements are true? (Choose two)

Option A

Dimensions are based on summaries.

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

Option C

Summaries without dimensions are used for faster aggregation.

Option 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
Description
Update Date and Time 2017-08-04 07:29:32

Question ID 7727

Which two statements are true? (Choose two)

Option A

Composite partitioning supports local indexes.

Option B

Composite partitioning supports hash-partitioned global indexes.

Option C

Composite partitioning supports range-partitioned global indexes

Option D

Composite partitioning supports composite-partitioned global indexes.

Correct Answer BD
Description
Update Date and Time 2017-08-04 07:30:58