Chat with us

AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


DOWNLOAD & READ Free Dumps For Oracle- 1z0-020



You are reading online questions and answers for Oracle Exam 1z0-020 (Oracle8i New Features for Administrators ) 100% free... Please share this site which will help this community to grow...

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