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 6624

What is pagespace?

1 4423

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

1 5190

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

3 13166

What are the advantages of using a PACKAGE?

2 20893

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

3 18926

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

2 11642

What does the REORG Utility do?

2 14005

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 17058

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

Accenture,

4 9370

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

Accenture,

2 19992

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 10468

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 15582

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

Accenture,

3 9981

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

Accenture, Wipro,

2 12827

Post New DB2 Questions

Un-Answered Questions { DB2 }

What does db2 mean?

1013

How do I change the column size in db2?

1151

If I have a view which is a join of two or more tables, can this view be updateable?

1139

What is the latest version of ibm db2?

1264

What are iseries servers?

1071

What is cloudant database?

1094

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1733

What is sqlca?

1065

Is db2 a mainframe database?

996

Explain various types of locks in db2?

1140

What are the 2 sqlcodes that are returned?

1185

Explain about open switch business continuity software?

1125

Discuss about db2 bind?

1092

Mention data types used in db2 ?

1153

How to find the number of rows in db2 tables?

1065

For More Un-Answered { DB2 } Questions Click Here