Home > DeveloperSection > Category

Latest interview on category "DB2"

What is QUIESCE?

 DB2 DB2 
By Chintoo Semi posted   5 years ago
Latest reply by Chintoo Semi on   5 years ago

What are the disadvantages of PAGE level lock?

 DB2 DB2 
By Chris Anderson posted   5 years ago
Latest reply by Chris Anderson on   5 years ago

How many columns maximum can be created in a table of a inner table of the subquery?

 DB2 DB2 
By Chris Anderson posted   5 years ago
Latest reply by Chris Anderson on   5 years ago

How would you find out the total number of rows in a DB2 table?

 DB2 DB2 
By Awadhendra Tiwari posted   5 years ago
Latest reply by Awadhendra Tiwari on   5 years ago

What is a self join?

 DB2 DB2 
By Amit Singh posted   5 years ago
Latest reply by Amit Singh on   5 years ago

What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.

 DB2 DB2 
By Amit Singh posted   5 years ago
Latest reply by Amit Singh on   5 years ago

What is the use of VALUE function?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What are the advantages of using a PACKAGE?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

How do you retrieve the data from a nullable column?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

Where is the output of EXPLAIN stored?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What is CHECK PENDING ?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What is RUNSTATS?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

Can you have more than one cursor open at any one time in a program ?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What are the various locks available?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What is filter factor?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

Are views updateable ?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

Can I use LOCK TABLE on a view?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

When you COMMIT, is the cursor closed?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What is lock escalation?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

How many clustering indexes can be defined for a table?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What is IMAGECOPY ?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What is a thread?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

Explain difference between sys.cat and sys.ibm?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What is index cardinality?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

What is sqlcode -922 ?

 DB2 DB2 
By Mahesh Rawat posted   5 years ago
Latest reply by Mahesh Rawat on   5 years ago

Don't want to miss updates? Please click the below button!

Follow MindStick