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 1821

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

Option A

A.    It can be used to allow the access privilege settings for users but not roles.
 

Option B

B.    It can be used to allow the access privilege settings for users as well as roles.

 

Option C

C.    It can be used to control the time interval for which the access privilege is available to a user.
 

Option D

D.    It can be used to selectively restrict the access for each user in a database to different host computers.
 

Option E

E.    It can be used to selectively restrict a user's access to different applications in a specific host computer.

Correct Answer B,C,D
Explanation


Question ID 1822

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,lTASK1l);
END;
/
BEGIN
dbms_advisor.set_task_ parameter(lTASK1l,lANALYSIS_SCOPElllALLl);
dbms_advisor.set_task_ parameter(lTASK1,,,MODE,llCOMPREHENSIVEl);
END;
/
BEGIN
dbms_advisor.execute_task('TASK1');
dbms_output.put_line(dbms_advisor.get_task_script('TASK11));
END;
/
The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?
 

Option A

A.    A template needs to be associated with the task.
 

Option B

B.    A workload needs to be associated with the task.

 

Option C

C.    The partial or complete workload scope needs to be associated with the task.
 

Option D

D.    The type of structures (indexes, materialized views, or partitions) to be recommended need to
be specified for the task.

Correct Answer B
Explanation

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