In DB2, Large Objects (LOB) Columns are used to store large objects (Documents, pictures, voice, and mixed media) in database. Which of the following clauses can't be used on LOB columns?a) GROUP BYb) HAVINGc) ORDER BYd) NONE OF THE ABOVE

kris mohan

• Sep 13th, 2011

None of the above

lomo_ve

 Profile Answers by lomo_ve Questions by lomo_ve

• Dec 14th, 2010

D

Answer Question  Select Best Answer

When using DB2 Connect, which of the following commands specifies the protocol information on how to connect to the host or to the server? A. CATALOG DCS B. CATALOG NODE C. CATALOG DATABASE D. CATALOG ODBC DATA SOURCE

betsysam

 Profile Answers by betsysam Questions by betsysam

• Aug 5th, 2008

Catalog Node

Answer Question  Select Best Answer

Given the following transaction in an embedded SQL application: CREATE TABLE dwaine.mytab (col1 INT, col2 INT) INSERT INTO dwaine.mytab VALUES (1,2) INSERT INTO dwaine.mytab VALUES (4,3) ROLLBACK What is the result of issuing the following statement? SELECT * FROM dwaine.mytab

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Mar 26th, 2010

The table creation and DMLs are rolled back.

sumanthvm

 Profile Answers by sumanthvm Questions by sumanthvm

• May 20th, 2009

Table itself is rolled back if it is included statement in the transaction

Answer Question  Select Best Answer