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 6639

What is pagespace?

1 4426

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

1 5195

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

3 13180

What are the advantages of using a PACKAGE?

2 20913

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

3 18944

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

2 11652

What does the REORG Utility do?

2 14013

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 17069

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

Accenture,

4 9382

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

Accenture,

2 20007

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 10477

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 15597

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

Accenture,

3 9991

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

Accenture, Wipro,

2 12835

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is rct?

1235

What is bind and rebind in db2?

1139

What is the information associated with sysibm.syslinks table?

1125

What are the various data types available in db2?

1094

What is the result of open cursor statement?

1083

What db2 400?

1191

What is cursor stability in db2?

1357

What is package in cobol db2?

1119

What does db2 blu stand for?

1165

What is dbrm? What it contains? When it will be created?

1051

What is with ur in db2?

1320

What is the use of runstats in db2?

1111

Mention the location where the output received from explain statement is stored.

1127

What is the use of predicate?

1043

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1272

For More Un-Answered { DB2 } Questions Click Here