---
title: "DB2 Tough Questions (4 of 4)"
description: "DB2 interview questions on distinct and multiple rows."
url: https://srinimf.com/2012/02/13/db2-tough-questions-4-of-4/
date: 2012-02-13
modified: 2026-10-05
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2018/07/woman-happiness-sunrise-silhouette-40192-e1535211755444.jpeg?fit=500%2C375&ssl=1
categories: ["DB2"]
tags: ["db2", "Questions"]
type: post
lang: en
---

# DB2 Tough Questions (4 of 4)

DB2 very basic questions that are asked in many interviews given here. The questions are related to what kind of data you can insert into Tables and how

**[DB2 Tough Interview Questions-Part:3](http://srinimf.com/2012/02/01/db2-tough-questions-3-of-4/)**

1. **Can we give DISTINCT on multiple columns in SQL?**
   - Multiple distinct are allowed now in DB2 from V8. Distinct can be given on multiple columns.
2. **Is it possible to [insert multiple rows](https://srinimf.com/2013/04/07/db2-multiple-rows-insert-with-arrays/) into a Table?**
   - Multiple rows can be inserted into a Table with Insert INSERT INTO T FOR **: X1** ROWS VALUES(:hva1, :hva2) ATOMIC
3. **What is main difference between Atomic and No Atomic?**
   - **Atomic-** If a single row fails, all will fail. **No ****Atomic**– All the rows inserted independently
4. **Can we insert encrypted data into DB2 Tables?**
   - Encrypted data can be inserted into a Table INSERT INTO EMP (SSN) VALUES(ENCRYPT(‘289-46-8832′,’Srini’,’ Blogs’));
5. **Will DB2 supports enterprise COBOL? **
   - DB2 V8 supports **Enterprise COBOL V3.2 or later**

**References**

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2012%2F02%2F13%2Fdb2-tough-questions-4-of-4%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2018%2F07%2Fwoman-happiness-sunrise-silhouette-40192-e1535211755444.jpeg%3Ffit%3D500%252C375%26ssl%3D1&description=DB2%20Tough%20Questions%20%284%20of%204%29)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2012/02/13/db2-tough-questions-4-of-4/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2012/02/13/db2-tough-questions-4-of-4/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2012/02/13/db2-tough-questions-4-of-4/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2012/02/13/db2-tough-questions-4-of-4/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20Tough%20Questions%20%284%20of%204%29&body=https%3A%2F%2Fsrinimf.com%2F2012%2F02%2F13%2Fdb2-tough-questions-4-of-4%2F&share=email)
-

### Like this:

Like Loading…