which SQL comment successfully removes uncommitted changes
from a DB2 database
A) rollback
B) delete
C) drop
D) decommit

Answers were Sorted based on User's Feedback



which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) de..

Answer / janaki

rollback

Is This Answer Correct ?    19 Yes 0 No

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) de..

Answer / jeetu

A. of course

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,


can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  


Explain the benefits you can get from mainframe connect?

0 Answers  


List down the data types in the db2 database.

0 Answers  


What is the picture clause of the null indicator variable?

6 Answers  






My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  


How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,


In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  


What is the purpose of using commit?

0 Answers  


How to compare data between two tables in db2?

0 Answers  


What are the disadvantages of PAGE level lock?

3 Answers  


Categories