Informix interview questions and Answers
Most Frequently Asked Informix interview questions
Q11. Name the SQL Joins that are Available In Informix.
Answer
There are four joins in the Informix:-
- INNER JOIN
- LEFT / RIGHT OUTER JOIN
- FULL OUTER JOIN
- CROSS JOIN
Q12. What Are The Informix Isolation Levels?
Answer
- 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