Explain what a plan is?3 6873
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?1 8716
What are the various locks available?5 9752
What technique is used to retrieve data from more than one table in a single SQL statement?9 11838
How can you quickly find out the number of rows updated after an update statement?1 8239
What is sqlcode -811?7 69042
Can we able to find all the Table names under a Particular Plan?1 5313
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 9080
wht are the restrictions for union ?2 5245
where can we use index and subscript ? with example ?3 9200
what is main use of table space and index object? please its urgent5 13210
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example1 4495
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.5 16837
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?4 12635
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?3 18627
Post New CTS DB2 Interview Questions
What is a representational state transfer(rest) in angularjs?
Differentiate between stateful and stateless components?
What are the java backend technologies?
What is def __ init __ in python?
What are the areas where ambari helps the system administrators to do?
What is test development?
What are the steps required to solve the problems of aircraft flying high and at very large speed?
Explain the loosely coupled architecture of web services.
What is a list of values?
What is a ledger? Name the common type of ledgers that can be considered by users in blockchain?
How do you use style?
As jobs become more team-oriented, assessment centers will be used more often for non-management jobs. Do you agree or disagree?
What is object-oriented paradigm?
What is the difference between heat map and treemap?