View the Exhibit to examine the PIVSQL block.
Which statement is true about the output of the PL/SQL block?
A.
It executes and the Output is emprec.deptname:.
B.
It executes and the Output is emprec.deptname:Sales.
C.
It produces an error because NULL is assigned to the emprec.empid field in the record.
D.
It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.
A Is correct
why A is correct??
A
please run this command..
A is correct ans.
It executes successfully without any error and constraint violation because we are assigning values to variables only and not inserting or applying it on table.
A
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/fundamentals.htm#LNPLS99970
constraints arent inherited if the referenced item is a column.
so A is correct
A is correct
%ROWTYPE does not inherit any constraint from table