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 2688

View Exhibit 1 and examine the structure of the EMP table.
 
View Exhlbit2 and examine the code of the packages that you have created.
 
 
You issue the following command:
SQL> DROP PACKAGE manage_emp; What is the outcome?

Option A

A.    It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.
 

Option B

B.    It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.
 

Option C

C.    It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.
 

Option D

D.    It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.
 

Correct Answer B
Explanation


Question ID 2689

Examine the following PL/SQL code:
 
Which statement is true about the fetch statements in the PL/SQL code?

Option A

A.    Each fetch retrieves the first row and assigns values to the target variables.
 

Option B

B.    Each fetch retrieves the next consecutive row and assigns values to the target variables.
 

Option C

C.    They produce an error because you must close and reopen the cursor before each fetch - statement.
 

Option D

D.    Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error.
 

Correct Answer B
Explanation

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