Examine the structure of the TEXT_TAB table. Name Null? Type --------- ------- ---------- TEXT_ID NUMBER DOC1 CLOB DOC2 CLOB You issue the following INSERT commands:

INSERT INTO text_tab VALUES (1, 'This is line 1',null); INSERT INTO text_tab VALUES (2, 'This is line 1','This is line 2'); Then you execute the following block of the PL/SQL code:

DECLARE vc1 VARCHAR2(1000):= 'This is the preface'; lb1 CLOB; lb2 CLOB; BEGIN SELECT doc1 INTO lb1 FROM text_tab WHERE text_id=1; SELECT doc1 || doc2 INTO lb1 FROM text_tab WHERE text_id=2; lb2 := vc1|| lb1; UPDATE text_tab SET doc2 = lb2 WHERE text_id = 1; END; / What is the outcome?

Question

Examine the structure of the TEXT_TAB table. Name Null? Type --------- ------- ---------- TEXT_ID NUMBER DOC1 CLOB DOC2 CLOB You issue the following INSERT commands:

INSERT INTO text_tab VALUES (1, 'This is line 1',null); INSERT INTO text_tab VALUES (2, 'This is line 1','This is line 2'); Then you execute the following block of the PL/SQL code:

DECLARE vc1 VARCHAR2(1000):= 'This is the preface'; lb1 CLOB; lb2 CLOB; BEGIN SELECT doc1 INTO lb1 FROM text_tab WHERE text_id=1; SELECT doc1 || doc2 INTO lb1 FROM text_tab WHERE text_id=2; lb2 := vc1|| lb1; UPDATE text_tab SET doc2 = lb2 WHERE text_id = 1; END; / What is the outcome?

Accepted Answer

A. It executes successfully.

Answer

B. It gives an error because VARCHAR2 should be explicitly converted to CLOB.

Answer

C. It gives an error because CLOB variables should be initialized to EMPTY_CLOB().

Answer

D. It gives an error because the concatenation operator cannot be used with the CLOB data type.

Examine the structure of the TEXT_TAB table. Name Null? Type --------- ------- ---------- TEXT_ID NUMBER DOC1 CLOB DOC2 CLOB You issue the following INSERT commands: INSERT INTO text_tab VALUES (1…

Question

Options

How the community answered

Community Discussion