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 2671

Examine the following package specification.
SQL>CREATE OR REPLACE PACKAGE emp_pkf IS
PROCEDURE search_emp (empdet NUMBER);
PROCEDURE search_emp (empdet DATE);
PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2
PROCEDURE search_emp (empdet NUMBER); RETURN DATE
END emp_pkg
/
The package is compiled successfully
Why would it generate an error at run tune?
 

Option A

A.    Because function cannot be overload
 

Option B

B.    Because function cannot differ only in return type.
 

Option C

C.    Becauseall the functions and procedures In the package cannot have the same number of parameters with the same parameter name
 

Option D

D.    Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET NUMBER) cannot have identical parameter names and data types
 

Correct Answer B
Explanation


Question ID 2673

Which two statements are true about PL/SQL exception propagation? (Choose two.)
 

Option A

A.    The exception reproduces Itself In successive enclosing blocks until a handler is found.
 

Option B

B.    Exception- can propagate across the remote subprograms that are called through database links.
 

Option C

C.    If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.
 

Option D

D.    If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception.
 

Correct Answer A,C
Explanation

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