Informix interview questions and Answers

There are four joins in the Informix:-

• INNER JOIN
• LEFT / RIGHT OUTER JOIN
• FULL OUTER JOIN
• CROSS JOIN

• DIRTY READ: Dirty Read Reads the data without checking whether the data is committed or not. During the read, no locks are held.
• COMMITTED READ: Committed Read reads only the determined data. During the read, no locks are held.
• REPEATABLE READ: Reads only the committed data. In this read, a shared lock is held on the rows. Other sessions can get the shared locks on those rows, but no one can get an exclusive lock.
• CURSOR STABILITY