READ Free Dumps For Oracle- 1z0-117

Question ID 2538	View Exhibit1 and examine the structure and indexes for the MYSALES table.   The application uses the MYSALES table to insert sales record. But this table is also extensively used for generating sales reports. The PROD_ID and CUST_ID columns are frequently used in the WHERE clause of the queries. These columns have few distinct values relative to the total number of rows in the table. The MYSALES table has 4.5 million rows. View exhibit 2 and examine one of the queries and its autotrace output.     Which two methods can examine one of the queries and its autotrace output?
Option A	A.    Drop the current standard balanced B* Tree indexes on the CUST_ID and PROD_ID columns and re-create as bitmapped indexes.
Option B	B.    Use the INDEX_COMBINE hint in the query.
Option C	C.    Create a composite index involving the CUST_ID and PROD_ID columns.
Option D	D.    Rebuild the index to rearrange the index blocks to have more rows per block by decreasing the value for PCTFRE attribute.
Option E	E.    Collect histogram statistics for the CUST_ID and PROD_ID columns.
Correct Answer	B,C

Explanation

Question ID 2539	Examine the Exhibit to view the structure of an indexes for the SALES table.   The SALES table has 4594215 rows. The CUST_ID column has 2079 distinct values. What would you do to influence the optimizer for better selectivity?
Option A	A.    Drop bitmap index and create balanced B*Tree index on the CUST_ID column.
Option B	B.    Create a height-balanced histogram for the CUST_ID column.
Option C	C.    Gather statistics for the indexes on the SALES table.
Option D	D.    Use the ALL_ROWS hint in the query.
Correct Answer	D

Explanation

Previous-Page 1 2. . . 15 16 17 18 19 20 21. . . 60 61 Next-Page

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