READ Free Dumps For Oracle- 1z0-144
Question ID 2669 | View the Exhibit to examine the PIVSQL 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 |
Question ID 2670 | Examine the following snippet of code from the DECLARE section of PL/SQL |
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 |