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 6634

What is pagespace?

1 4425

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

1 5193

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

3 13168

What are the advantages of using a PACKAGE?

2 20909

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

3 18935

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

2 11649

What does the REORG Utility do?

2 14007

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 20001

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 10474

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 15591

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 12831

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is buffer pool in the db2 database?

1098

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2365

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

699

What is the maximum length of sqlca?

1527

What is host variable in db2 cobol?

1077

What is the role of union all and union

1127

What is runstats and reorg in db2?

1302

What is db2 catalog database?

1041

define clustering index.

1025

What is explain in db2?

1020

What is deadlock in db2?

1067

What is a db2 tablespace?

1061

What does sqlcabc has?

1053

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 cursor with hold option in db2?

1070

For More Un-Answered { DB2 } Questions Click Here