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 5339

What is pagespace?

 1 3780

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

 1 4446

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

 3 11763

What are the advantages of using a PACKAGE?

 2 19249

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

 3 17483

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

 2 10496

What does the REORG Utility do?

 2 13032

What is FREEPAGE and PCTFREE in TABLESPACE creation?

 1 16024

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

Accenture,

4 7990

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

Accenture,

2 18979

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 9258

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 13725

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

Accenture,

3 8699

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

Accenture, Wipro,

2 11496

Post New DB2 Questions

Un-Answered Questions { DB2 }

Can we delete records from view?

566

What is the difference between spufi and qmf?

639

What is isolation level in db2?

577

Who uses db2?

576

What are the various data types available in db2?

634




List down the types of triggers in the db2 database?

592

How do you pull up a query which was previously saved in qmf?

674

What does db2 blu stand for?

661

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

628

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

706

How to get the ddl of a table in db2?

679

What are the bind parameters ibm db2?

624

What is with ur in db2?

760

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

593

How will you return the number of records in table?

518

For More Un-Answered { DB2 } Questions Click Here