READ Free Dumps For Oracle- 1z0-117

Question ID 2544	Examine the initializing parameters:   An index exists on the column used in the WHERE of a query. You execute the query for the first time today and notice that the query is not using the index. The CUSTOMERS table has 55000 rows. View the exhibit and examine the query and its execution plan.     What can be the two reasons for full table scan?
Option A	A.    The value of the OPTIMIZER_INDEX_COST_ADJ parameter is set to a low value.
Option B	B.    The blocks fetched by the query are greater than the value specified by the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
Option C	C.    The statistics for the CUSTOMERS table and the indexes stale.
Option D	D.    The OPTIMIZER_MODE parameter is set to ALL_ROWS.
Option E	E.    Histogram statistics for CUST_CITY_ID are missing.
Option F	F.    Average number of rows per block for the CUSTOMERS table is low.
Correct Answer	C,E

Explanation

Question ID 2545	You have created some materialized views to improve the performance of several queries. Which four must be true to enable sessions to benefit from improved response time made possible by these materialized views?
Option A	A.    Query rewrite must be enabled for the sessions.
Option B	B.    Bitmap indexes must exist on all the columns involved in the join operations for the defining   query of the MVIEWs.
Option C	C.    All or part of the query results must be obtainable from one or more MVIEWs.
Option D	D.    Bitmap join indexes must exist on all the columns involved in the join operations.
Option E	E.    Session users must have query rewrite privilege.
Option F	F.    The MVIEWs must be enabled for query rewrite.
Correct Answer	A,B,C,F

Explanation

Previous-Page 1 2. . . 18 19 20 21 22 23 24. . . 60 61 Next-Page

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