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 5316

What is pagespace?

 1 3765

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

 1 4428

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

 3 11730

What are the advantages of using a PACKAGE?

 2 19209

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

 3 17420

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

 2 10468

What does the REORG Utility do?

 2 13001

What is FREEPAGE and PCTFREE in TABLESPACE creation?

 1 15993

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

Accenture,

4 7943

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

Accenture,

2 18945

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 9216

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 13683

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

Accenture,

3 8662

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

Accenture, Wipro,

2 11456

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is innodb buffer pool?

554

What are iseries servers?

558

What is query_cache_limit?

541

Which components manage deadlocks in db2?

600

What is view db2?

615




What are foreign keys in db2?

607

Is schema the same as database?

621

What types of tables are there in the db2 database?

543

How connect db2 database to datastage?

752

What is cursor stability in db2?

796

Which isolation level provides maximum concurrency?

653

Is db2 free?

674

How will you return the number of records in table?

508

Can we insert update delete in view?

567

What's The Percentage Free Space ?

757

For More Un-Answered { DB2 } Questions Click Here