Follow Our FB Page << CircleMedia.in >> 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.

300

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

748

What are the advantages of submitting sites to search directories?

244

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?

287

How does constructor injection work?

66




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

155

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

267

Why is theta join required?

285

What is value stack?

307

What do you mean by creating vuser script?

344

What is list comprehension? Give an example.

290

How to handle a web browser resize operation?

283

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

321

What's the difference between 32 and 64 bit?

260

What is the benefit of session partitioning?

299