What are the disadvantages of PAGE level lock? Chris Anderson 8 years ago DB2 2710 View(s) Latest reply by Chris Anderson 8 years ago
How many columns maximum can be created in a table of a inner table of the subquery? Chris Anderson 8 years ago DB2 1893 View(s) Latest reply by Chris Anderson 8 years ago
How would you find out the total number of rows in a DB2 table? Awadhendra Tiwari 9 years ago DB2 2169 View(s) Latest reply by Awadhendra Tiwari 9 years ago
What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table. Amit Singh 9 years ago DB2 2445 View(s) Latest reply by Amit Singh 9 years ago
What is the use of VALUE function? Mahesh Rawat 9 years ago DB2 1855 View(s) Latest reply by Mahesh Rawat 9 years ago
What are the advantages of using a PACKAGE? Mahesh Rawat 9 years ago DB2 1928 View(s) Latest reply by Mahesh Rawat 9 years ago
How do you retrieve the data from a nullable column? Mahesh Rawat 9 years ago DB2 1929 View(s) Latest reply by Mahesh Rawat 9 years ago
Where is the output of EXPLAIN stored? Mahesh Rawat 9 years ago DB2 1931 View(s) Latest reply by Mahesh Rawat 9 years ago
What is CHECK PENDING ? Mahesh Rawat 9 years ago DB2 2010 View(s) Latest reply by Mahesh Rawat 9 years ago
Can you have more than one cursor open at any one time in a program ? Mahesh Rawat 9 years ago DB2 2043 View(s) Latest reply by Mahesh Rawat 9 years ago
What are the various locks available? Mahesh Rawat 9 years ago DB2 1916 View(s) Latest reply by Mahesh Rawat 9 years ago
What is filter factor? Mahesh Rawat 9 years ago DB2 1894 View(s) Latest reply by Mahesh Rawat 9 years ago
Are views updateable ? Mahesh Rawat 9 years ago DB2 1934 View(s) Latest reply by Mahesh Rawat 9 years ago
Can I use LOCK TABLE on a view? Mahesh Rawat 9 years ago DB2 1763 View(s) Latest reply by Mahesh Rawat 9 years ago
When you COMMIT, is the cursor closed? Mahesh Rawat 9 years ago DB2 2244 View(s) Latest reply by Mahesh Rawat 9 years ago
What is lock escalation? Mahesh Rawat 9 years ago DB2 1830 View(s) Latest reply by Mahesh Rawat 9 years ago
How many clustering indexes can be defined for a table? Mahesh Rawat 9 years ago DB2 1846 View(s) Latest reply by Mahesh Rawat 9 years ago
What is IMAGECOPY ? Mahesh Rawat 9 years ago DB2 1974 View(s) Latest reply by Mahesh Rawat 9 years ago
Explain difference between sys.cat and sys.ibm? Mahesh Rawat 9 years ago DB2 2262 View(s) Latest reply by Mahesh Rawat 9 years ago
What is index cardinality? Mahesh Rawat 9 years ago DB2 1886 View(s) Latest reply by Mahesh Rawat 9 years ago
What is sqlcode -922 ? Mahesh Rawat 9 years ago DB2 1936 View(s) Latest reply by Mahesh Rawat 9 years ago
