ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

60 / 68

Question 60:

Examine the following PL/SQL statements: 
image
Which statements are true about the above PL/SQL block? (Choose two.) 

Answer options:

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