5 rows are inserted to a DB2 Table. Next 3 of those are
updated, then a rollback is issued. What would happen when
the rollback is issued?
Answers were Sorted based on User's Feedback
Answer / rashmi
The 5 inserted records will not be there in the table.
Becouse rollback is happening before the commit(Untill
unless you commit it, the changes will not reflect in the
table).
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / guest
The 5 rows inserted will be not be present in the table.
Is This Answer Correct ? | 5 Yes | 0 No |
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
can all users have the privilage to use the sql statement select * (dml)?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the difference between spufi and qmf?
What is the syntax required for the creation of a cursor?
What is DCLGEN ?
How can deadlocks be resolved?
What is meant by explain?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
Differentiate between cs and rr isolation levels? Where do you specify them?