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 6434

What is pagespace?

1 4326

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

1 5106

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

3 13030

What are the advantages of using a PACKAGE?

2 20739

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

3 18755

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

2 11511

What does the REORG Utility do?

2 13876

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 16919

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

Accenture,

4 9179

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

Accenture,

2 19858

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 10335

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 15353

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

Accenture,

3 9819

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

Accenture, Wipro,

2 12693

Post New DB2 Questions

Un-Answered Questions { DB2 }

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1040

What is the difference between spufi and qmf?

1053

Can we update view in db2?

944

How to fetch the last row from the table in SQL (db2)?

1587

What is the syntax for FETCH in DB2 ?

1136

What is the maximum No of rows per page?

1010

What are union and union all?

920

Explain about dbrm.

987

Can one database have multiple instances?

1005

what is db2 restart?

2101

What r the comman abends in db2, jcl and cobol???????

2196

How can the duplicate values be eliminated from db2 select?

1039

What is a plan and package in db2?

1042

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2006

What is multi row fetch in db2?

985

For More Un-Answered { DB2 } Questions Click Here