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 1919

You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:
SQL> SELECT dbms_addm.get_report(lmy_instance_analysis_mode_task') FROM dual;
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments. What would you do to achieve this?
 

Option A

A.    Add a finding directive for the ADDM task.
 

Option B

B.    Add a segment directive for the ADDM task.
 

Option C

C.    Add a parameter directive for the ADDM task.

 

Option D

D.    Disable the Segment Advisor from the Automatic Maintenance Task.

Correct Answer B
Explanation


Question ID 1920

A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?

Option A

A.    It remains valid.
 

Option B

B.    It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
 

Option C

C.    It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
 

Option D

D.    It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
 

Correct Answer A
Explanation

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