which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
2 12854I 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 58497In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 8149How 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 109544. 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 9355if 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 11994Cursors 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 33086i 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 14186Post New Wipro DB2 Interview Questions
What is database server and how it works?
What are the types of sockets in java?
What is pdo :: fetch_assoc?
What are css variables?
How can we create a data-driven framework using testng?
Which font is good for powerpoint presentation?
What is the latest version of Ambari that is available in the market?
What is the difference between angular and angular material?
How can we find database related issues?
Does camel link method invocation of bean at compile time or runtime?
What is the effect on Power factor and capacitor when your company load is more than 70 % of welding transformer
What advantage does a backup using the maxdb backup tool offer compared to a file system backup?
Where does the primary field of an mvg stored?
What is module and list out some of the modules used in drupal?
When is it not recommended to use MapReduce paradigm for large scale data processing?