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 6635

What is pagespace?

1 4425

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

1 5194

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

3 13173

What are the advantages of using a PACKAGE?

2 20911

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

3 18938

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

2 11650

What does the REORG Utility do?

2 14013

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 17065

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

Accenture,

4 9377

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

Accenture,

2 20002

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 10476

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 15593

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

Accenture,

3 9988

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

Accenture, Wipro,

2 12832

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is data manager?

1049

What is precompiler in db2?

1018

Are view updateable?

1043

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2727

What is db2? Explain.

1043

What is a db2 table?

1015

Mention the downsides of page level lock.

1161

Name the various locking levels available?

1091

What does reorg do in db2?

1029

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?

2097

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1185

What is ibm db2 used for?

1079

When reorg is used?

1126

What is access path in db2?

986

What is host variable in db2 cobol?

1077

For More Un-Answered { DB2 } Questions Click Here