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 6650

What is pagespace?

1 4437

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

1 5200

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

3 13194

What are the advantages of using a PACKAGE?

2 20922

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

3 18956

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

2 11656

What does the REORG Utility do?

2 14025

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 17071

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

Accenture,

4 9394

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

Accenture,

2 20021

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 10484

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 15609

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

Accenture,

3 10006

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

Accenture, Wipro,

2 12847

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do I add a column to a table in db2?

1106

What is page size in db2?

983

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11686

What is cobol db2?

1004

How is deadlock resolved?

1152

What is the use of predicate?

1044

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3158

How to check last update on table in db2?

1063

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2048

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

Explain about rct.

1093

What is the use of dclgen in db2?

1085

What is the maximum size of a char data type in db2?

1012

List out the buffer pools in db2

1077

Which isolation level provides highest data integrity?

1127

For More Un-Answered { DB2 } Questions Click Here