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





Question ID 2609

Your database supports a workload consisting of three categories of SQL statements:
- Statements that should execute in less than one minute
- Statement that may execute for up to 15 minutes
- Statements that may be executed for more than 15 minutes
You set PARALLEL_DEGREE_POLICY to Auto.
You plan to prioritize queued statements by using the Database Resource manager. Which two are true about parallelism prioritization by a consumer group?
 

Option A

A.    PARALLEL_TARGET_PERCENTAGE is used to prioritize a consumer group’s use of the overall PARALLEL_SERVER_TARGET.
 

Option B

B.    Queuing is done for a consumer group exceeding its percentage, even if the number of busy PX servers in the instance has not reached PARALLEL_SERVERS_TARGET.
 

Option C

C.    PARALLEL_TARGET_PERCENTAGE us used to prioritize a consumer group’s use of the overall SPAN CLASS = ‘OracleCode’> PARALLEL_MAX_SERVERS.
 

Option D

D.    Having separate queues for consumer groups requires the use of management attributes (MGMT_P1, MGMT_P2 etc. . . )
 

Option E

E.    Separate queue timeout using PARALLEL_QUEUE_TIMEOUT require the use of management attributes (MGMT_P1, MGMT_P2 etc . . . groups)
 

Correct Answer A,D
Explanation


Question ID 2610

Examine the Exhibit.
 

Given two sets of parallel execution processes, SS1 and SS2, which is true?
 

Option A

A.    Each process SS1 reads some of the rows from the CUSTOMERS table and sends all the rows it reads to each process in SS2.
 

Option B

B.    Each process in SS1 reads all the rows from the CUSTOMERS table and distributes the rows evenly among the processes in SS2.

 

Option C

C.    Each process in SS1 reads some of the rows from the SALES table and sends all the rows it reads to each process in SS2.
 

Option D

D.    Each process in SS1 reads all the rows from the SALES table and distributes the rows evenly among the processes in SS2.
 

Option E

E.    Each process in SS1 reads some of the rows from the SALES table and distributes the rows evenly among the processes in SS2.
 

Option F

F.    Each process in the SS1 reads some of the rows from the CUSTOMERS table and distributes the rows evenly among the processes in SS2.

Correct Answer D
Explanation

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