What is isolation level in db2?
- 1 Answers
- 1091 Views
- I also Faced
- E-Mail Answers
Answer / Sunil Dutt
Isolation level in DB2 refers to the degree of interference between transactions. There are four isolation levels: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.
| Is This Answer Correct ? | 0 Yes | 0 No |
When Can you be sure that a query will return only one row?
What is bind in db2?
What is runstats utility in db2?
What are db2 tables?
Comment whether the cursor is closed during commit or not.
Explain transactions, commits and rollbacks in DB2.
What is JOIN and different types of JOIN.
What is the SQL query to select, delete and get count of duplicate rows in DB2?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
What are the three types of page locks that can be held?
What does sqlcabc has?
If I have a view which is a join of two or more tables, can this view be updateable?
COBOL 
