DB2 Interview Questions
Questions Answers Views Company eMail

wht are the restrictions for union ?

CTS,

2 5967

where can we use index and subscript ? with example ?

CTS,

3 10062

i want to delete 20th million record how ?

IBM,

4 9955

wt is view ? wht r the restrictions for view ?

Verizon,

3 6929

how can u nderstand the sql stmts executed successfully or not ?

TCS,

1 5311

how to u check the query is executing or not ?where will u check for sqlcode ?

Infosys,

6 11201

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

EDS,

2 6096

how can we retrieve the 100 records of the file ?

IBM,

2 7509

is there any restrictions for unions ?

Patni,

4 7895

can i code union in cobol-db2 pgm ?

Patni,

4 12000

what is + sign and -ve sign for sql code ?

TCS,

1 5736

how can u understand the end of the table ?

TCS,

1 6074

if i made sme changes in sub pgm wht r the things to be done for this ?

TCS,

1 5611

wht displays the number of times a query modified ?

TCS,

2 6375

where will u check for sqlcode ?

TCS,

2 6762


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is database alias db2?

705


Explain correlated sub-queries.

676


What is dbrm in db2 database?

677


What is role in db2?

708


List down the data types in the db2 database.

731






Highlight all the advantages that are attached to a package.

746


How and when does the db2 enforces the unique key?

735


What is buffer pool in the db2 database?

736


What is multi row fetch in db2?

685


what is the sqlcode -501

11775


Can one database have multiple instances?

667


Is db2 free?

778


Can we update view in db2?

658


How do you stop a db2 database in linux?

659


Why do we bind in db2?

753