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-060





Question ID 2223

You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?

Option A

A.    It may advise the use of online table redefinition for tables in dictionary managed tablespace.
 

Option B

B.    It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
 

Option C

C.    It may advise the use of online table redefinition for tables in locally managed tablespaces
 

Option D

D.    It will detect and advise about chained rows.

 

Option E

E.    It may advise the use of segment shrink for free list managed tables.

Correct Answer a
Explanation


Question ID 2224

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?
 

Option A

 

 

 

A.    The index remains invisible.
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Option B

B.    The index is not updated by the DML statements on the indexed table.
 

Option C

C.    The index automatically becomes visible in order to have it updated by DML on the table.
 

Option D

D.    The index becomes unusable but the table is updated by the DML.


 

Option E

E.    The index is updated by the DML on the table.

 

 

 

 

 

 

 

 

 

 

 

Explanation

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