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





Question ID 1923

An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.
You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.
Which is the most efficient method of performing this task?
 

Option A

A.    disabling the index

 

Option B

B.    making the index invisible
 

Option C

C.    making the index unusable
 

Option D

D.    using the MONITORING USAGE clause for the index

Correct Answer B
Explanation


Question ID 1924

Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

Option A

A.    only encryption and compression settings for all SecureFile LOBs
 

Option B

B.    only encryption and deduplication settings for only SecureFile CLOBs
 

Option C

C.    deduplication, encryption, and compression settings for all SecureFile LOBs

 

Option D

D.    deduplication, encryption, and compression settings only for SecureFile CLOBs

Correct Answer C
Explanation

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