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 4425

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 20912

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 17068

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

Accenture,

4 9381

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 9990

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 action db2 takes when a program aborts in the middle of a transaction?

1156

What is release/acquire in bind?

1106

What is db2?

1182

What is db2 and what is the use of db2 optimizer?

1067

Is db2 a mainframe database?

1000

Define data page.

1069

How do you select a row using indexes in db2?

1135

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1196

What is db2 look?

1024

What is commit in db2?

1055

Which isolation level provides highest data integrity?

1118

How do I connect my db2 database to ibm?

1051

Define predicate?

1131

What is the clustering index in the db2 database?

1001

What are the 2 sqlcodes that are returned?

1189

For More Un-Answered { DB2 } Questions Click Here