1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

What is an access path?

 3 5353

What is pagespace?

 1 3786

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

 1 4460

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

 3 11773

What are the advantages of using a PACKAGE?

 2 19260

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

 3 17509

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

 2 10504

What does the REORG Utility do?

 2 13053

What is FREEPAGE and PCTFREE in TABLESPACE creation?

 1 16035

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

Accenture,

4 7998

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

Accenture,

2 18986

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 9267

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 13742

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

Accenture,

3 8711

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

Accenture, Wipro,

2 11525

Post New DB2 Questions

Un-Answered Questions { DB2 }

How does cobol compile db2 program?

612

How many types of page locks can be held in db2?

595

Explain about dbrm.

613

What is lock escalation in db2?

582

What is meant by dclgen?

623




What is access path in db2?

568

What parameters are used to control the free space in DB2?

649

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

633

How can you count the number of rows from a table tab?

643

What is db2 catalog database?

589

Can you use max on a char column?

644

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3126

Explain about mirror activator disk mirroring?

564

Is db2 a programming language?

610

What is a db2 collection?

611

For More Un-Answered { DB2 } Questions Click Here