Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 9343 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
pls tell me abt the normalization five types....
What are types of indexes?
Is ibm db2 open source?
what is static sql? what is dynamic sql? Give me details
What is db2 and what is the use of db2 optimizer?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What should be specified along with a cursor in order to continue updating process after commit?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What is an instance in db2?
What is the syntax for creating a table in the db2 database?
COBOL 
