Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

When do you use the IMAGECOPY?

4 5490

What do you mean by NOT NULL? When will you use it?

3 3932

When would you prefer to use VARCHAR?

3 5226

Explain an outer join?

1 3840

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

IBM,

1 4360

What is REORG? When is it used?

4 7074

How are write I/Os from the buffer pool executed?

1 2669

What is the syntax of SELECT statement when embedded in a COBOL program?

2 7841

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 20186

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 2719

What are foreign keys?

1 3374

What is JOIN and different types of JOIN.

IBM,

2 10528

What does DSNDB07 database do?

2 10182

What is a DB2 access path?

1 5611

What is a recovery log?

1 3243


Post New DB2 Questions






Un-Answered Questions { DB2 }

How to retrieve rows from a db2 table in embedded sql?

232


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1382


Explain packages.

206


Is the primary key a clustered index?

165


How to execute stored procedure in db2 command editor?

154






How can you classify the locks in db2?

186


What is commit in db2?

169


How do we specify index to include or not during bind process.

1291


List down the types of triggers in the db2 database?

188


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1299


What is a bind in db2?

158


How does a cursor work?

152


How is deadlock resolved?

192


What is a buffer in memory?

165


How do I import a csv file into db2?

160