4. 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.
Answers were Sorted based on User's Feedback
a. none of the rows are locked.
Thanks;
Amita Sharma.
Is This Answer Correct ? | 8 Yes | 1 No |
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
How to get Top 10 Salaries from a Table
What information is held in SYSIBM.SYSCOPY?
What is the difference between nvl and coalesce?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How do I delete a column in db2?
What is a collection?
how to fetch multiple records without using cursor
How do I delete a table in db2?
How do you Load a table ?? and what is Load replace ?
What is release/acquire in bind?
Give the COBOL definition of a VARCHAR field.