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 6776

What is pagespace?

1 4498

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

1 5261

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

3 13296

What are the advantages of using a PACKAGE?

2 21030

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

3 19079

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

2 11758

What does the REORG Utility do?

2 14106

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 17179

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

Accenture,

4 9494

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

Accenture,

2 20120

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 10558

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 15734

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

Accenture,

3 10124

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

Accenture, Wipro,

2 12926

Post New DB2 Questions

Un-Answered Questions { DB2 }

what is diffrence b/w file-aid tool and file-aid utility???

4958

Explain about mirror activator disk mirroring?

1059

What is the syntax for creating a table in the db2 database?

1144

How to find the number of rows in a db2 table?

1154

Outputs of explain are with matchcols = 0. What does this signify?

1106

Explain packages.

1163

What is the use of commit in db2?

1138

What is the reason behind not using select * in embedded sql programs?

1161

Can there be more than one cursor open for any program?

1223

What is clone table?

1110

What is the difference between nvl and coalesce?

1104

What does db2 stand for?

1088

What is the difference between spufi and qmf?

1200

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9350

How to execute stored procedures?

1173

For More Un-Answered { DB2 } Questions Click Here