Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

CTS DB2 Interview Questions
Questions Answers Views Company eMail

Explain what a plan is?

3 6276

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 8065

What are the various locks available?

5 9038

What technique is used to retrieve data from more than one table in a single SQL statement?

9 10675

How can you quickly find out the number of rows updated after an update statement?

1 7866

What is sqlcode -811?

7 65949

Can we able to find all the Table names under a Particular Plan?

1 4931

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 8400

wht are the restrictions for union ?

2 4827

where can we use index and subscript ? with example ?

3 8658

what is main use of table space and index object? please its urgent

5 12173

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 4172

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 15852

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 11552

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 17568

Post New CTS DB2 Interview Questions

CTS DB2 Interview Questions

Un-Answered Questions

Explain JSP directives.


There is currently a list of predefined auto cash rules, however I am wanting to know if you can customise and create a cash rule to specifically target an aging bucket i.e. 30 days


What are the advantages of submitting sites to search directories?


http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?


How does constructor injection work?


Explain how you can get exactly once messaging from kafka during data production?


What is difference between rank () row_number () and dense_rank () in sql?


Why is theta join required?


What is value stack?


What do you mean by creating vuser script?


What is list comprehension? Give an example.


How to handle a web browser resize operation?


How can you increase the allowable number of simultaneously open files?


What's the difference between 32 and 64 bit?


What is the benefit of session partitioning?