Which statements are true about the above PL/SQL block?

Examine the following PL/SQL statements:


V_EMPREC.DEPTNAME would display a null value because the default value is not inherited
Which statements are true about the above PL/SQL block? (Choose two.)
A. V_EMPREC.DEPTNAME would display a null value because the default value is not inherited
B. Assigning null to V_MEPREC.EMPID would generate an error because thhe null constraint is inherited
C. Assigning the value 1000.002 to V_EMPREC.SALARY would generate an error because of the decimal
D. Assigning the value 50 to V_EMPREC.DEPTID would work because the check constraint is not inherited

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.