DB2 Tough Questions (4 of 4)

Read part-3, if you miss it. 

Q1) Multiple distinct are allowed now in DB2 from V8. Distinct can be given on multiple columns.

Q2) Multpile rows can be inserted into a Table with Insert

INSERT INTO T FOR : X1 ROWS

VALUES(:hva1, :hva2) ATOMIC

Q3) Atomic- If a single row fails, all will fail. No Atomic– All the rows inserted independently

Q4) encrypted data can be inserted into a Table

INSERT INTO EMP (SSN)

VALUES(ENCRYPT(‘289-46-8832′,’Srini’,’ Blogs’));

 Q5) DB2 V8 supports Enterprise COBOL V3.2 or later

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.