DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is an access path?

3 6486

What is pagespace?

1 4360

On the create tablespace, what does the CLOSE parameter do?

1 5130

What is an alias and how does it differ from a synonym?

3 13081

What are the advantages of using a PACKAGE?

2 20782

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

3 18808

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 11555

What does the REORG Utility do?

2 13911

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 16959

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

Accenture,

4 9233

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

Accenture,

2 19890

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

Accenture,

2 10372

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

Accenture,

5 15398

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

Accenture,

3 9869

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

Accenture, Wipro,

2 12723

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain how can you do the explain of a dynamic sql statement?

1082

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2042

Define db2 and its databases?

1027

List some fields from sqlca?

1016

What is a plan and package in db2?

1061

What is database manager in db2?

980

What is the physical storage length of timestamp data type?

1037

Why select is not preferred in embedded sql programs?

1255

What is the difference between cursor stability and repeatable read isolation levels?

1137

How can you count the number of rows from a table tab?

1057

How can we read records for specific member in CL? AND rpg?

663

What is db2 plan table?

1008

What is db2 look?

985

Differentiate between cs and rr isolation levels? Where do you specify them?

1037

What is the purpose of rollback and commit?

1121

For More Un-Answered { DB2 } Questions Click Here