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 2669

View the Exhibit to examine the PIVSQL block.
 
 
Which statement is true about the output of the PL/SQL block?

Option A

A.    It executes and the Output is emprec.deptname: .
 

Option B

B.    It executes and the Output is emprec.deptname: Sales.
 

Option C

C.    It produces an error because NULL is assigned to the emprec.empid field in the record.
 

Option D

D.    It produces anerror because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.
 

Correct Answer A
Explanation


Question ID 2670

Examine the following snippet of code from the DECLARE section of PL/SQL
DECLARE
Cust_name VERCHAR2 (20) NOT NULL : = ‘Tom Jones’: Same_name cust_name%TYPE:
Which statement is correct about the above snippets of code?
 

Option A

A.    TheSAME_NAMEvariable inherits only the data type from the CUST_NAME variable.
 

Option B

B.    TheSAME_NAMEvariable inherits only the data type and default value from the CUST_NAME variable.
 
 

Option C

C.    TheSAME_NAMEvariable inherits the data type, constraint, and default value from the CUST_NAME variable.
 

Option D

D.    TheSAME_NAMEvariable inherits only the data type and constraint from the CUST_NAME variable resulting in an error
 

 

 

 

 

 

 

 

 

Option F

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Correct Answer D
Explanation

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