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





Question ID 2664

Examine the following snippet of PL/SQL code:
 
View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.
 
Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as ‘ST_CLERK’ and salary greater than 3000.

Option A

A.    OPEN c1 (NULL, 3000);
 

Option B

B.    OPEN c1 (emp_job, 3000);
 

Option C

C.    OPEN c1 (3000, emp_salary);
 

Option D

D.    OPEN c1 (‘ST_CLERK’, 3000)
 

Option E

E.    OPEN c1 (EMP_job, emp_salary);
 

Correct Answer D
Explanation


Question ID 2665

View the exhibit and examine the structure of the EMPLOYEES table
 
The salary of EMPLOYEE_ID 195 is 2800. You execute the following code
 
 
What is the outcome?

Option A

A.    It gives an error because only the innermost block is labeled.
 

Option B

B.    It gives an error because the same variable name cannot be used across all the nested blocks.
 

Option C

C.    It executes successfully and displays the resultant values in the following sequence- 1000, 2800 50000, 2800.
 

Option D

D.    It executes successfully and displays the resultant values in the following sequence: 1000, 2800, 50000, 1000.

Correct Answer C
Explanation

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