Exam 1z0-148 topic 1 question 60 discussion

confirm. B is correct answer: CREATE TABLE test_tbl(id NUMBER, object BLOB); INSERT INTO test_tbl(id,object) values(1,'01'); INSERT INTO test_tbl(id,object) values(2,'11'); COMMIT; SELECT * FROM test_tbl; CREATE or replace TRIGGER trig_at AFTER UPDATE ON test_tbl BEGIN DBMS_OUTPUT.PUT_LINE('It was updated'); END; / SET SERVEROUTPUT ON; DECLARE dest_lob BLOB; src_lob BLOB; BEGIN SELECT object INTO dest_lob FROM test_tbl WHERE id=2 FOR UPDATE; SELECT object INTO src_lob FROM test_tbl WHERE id=1; dbms_lob.append(dest_lob,src_lob); END; / Table TEST_TBL created. 1 row inserted. 1 row inserted. Commit complete. ID OBJECT ---------- -------------------------------------------------------------------------------- 1 01 2 11 Trigger TRIG_AT compiled PL/SQL procedure successfully completed.