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,


READ Free Dumps For Oracle- 1z0-117





Question ID 2508

You plan to bulk load data INSERT INTO . . . SELECT FROM statements.
Which two situations benefit from parallel INSERT operations on tables that have no materialized views defined on them?
 

Option A

A.    Direct path insert of a million rows into a partitioned, index-organized table containing one million rows and a conventional B*tree secondary index.
 

Option B

B.    Direct path insert of a million rows into a partitioned, index-organized table containing 10 rows and a bitmapped secondary index.
 

Option C

C.    Direct path insert of 10 rows into a partitioned, index-organized table containing one million rows and conventional B* tree secondary index.
 

Option D

D.    Direct path insert of 10 rows into a partitioned, index-organized table containing 10 rows and a bitmapped secondary index
 

Option E

E.    Conventional path insert of a million rows into a nonpartitioned, heap-organized containing 10 rows and having a conventional B* tree index.
 

Option F

F.    Conventional path insert of 10 rows into a nonpartitioned, heap-organized table one million rows and a bitmapped index.
 

Correct Answer A,B
Explanation


Question ID 2509

Which are the two prerequisites for enabling star transformation on queries?
 

Option A

A.    The STAR TRANSFORMATION _ENABLED parameter should be set to TRUE or TEMP_DISABLE.
 

Option B

B.    A B-tree index should be built on each of the foreign key columns of the fact table(s),
 

Option C

C.    A bitmap index should be built on each of the primary key columns of the fact table(s).
 

Option D

D.    A bitmap index should be built on each of the foreign key columns of the fact table(s).

 

Option E

E.    A bitmap index must exist on all the columns that are used in the filter predicates of the query.

Correct Answer A,E
Explanation

Send email to admin@getfreedumps for new dumps request!!!