which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
2 12847I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
10 58465In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 8135How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
6 109344. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
3 9343if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
8 11972Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
8 33056i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 14165Post New Wipro DB2 Interview Questions
What qualification do you need to become an accounting professional?
In a vehicle, which is going straight ahead at N rpm, if the left wheel rotates forward at n rpm, then the resultant speed of the right wheel will be a) N+n b) N-n c) N/n d) Nn
How to combine two function together?
Write the c program to insert a node in circular singly list at the beginning.
Any challenge, you think banks face these days?
What are the Important test scenarios which can be used for testing a web site?
How do you respond to dementia behavior?
What is the alternate solution for testing of polarity by using polarity tester while its milli ammeter does not works?
What is session facade in ejb?
Do python functions need return?
What are the main parts of xsl document?
How to view the tablespaces in the current database?
What is the difference between arrow function and normal function?
Electronic technical analysis
What is character set?