Informix interview questions and Answers

Last updated on Mar 21, 2022
  • Share
Informix interview questions

Most Frequently Asked Informix interview questions

Here in this article, we will be listing frequently asked Informix interview questions and Answers with the belief that they will be helpful for you to gain higher marks. Also, to let you know that this article has been written under the guidance of industry professionals and covered all the current competencies.

Q1. Who developed Informix?

The Informix database was designed by Roger Sippl in the late 1970s and was initially developed in his company Informix Corporation and later in April 2001; IBM acquired it.

Q2. What is a chunk in Informix?

A chunk is a physical portion of the disk on which the Informix stores its data. A fragment can be a raw partition or a file system file.

Q3. Explain the Informix Instance.

An Informix instance is a database server which manages the one or more than one Informix databases.

Q4. What is a Database Object in IBM Informix?

The Database object is a table or a view or any other type of objects supported by Informix. The Database objects are created using a statement SQL CREATE for these types of objects, and the database objects have owners.


Q5. What is the role of Binary Large Object in Informix?

A large binary object which is also known as a Blob is a collection of the binary data which is stored as a single entity in a database management system. Blobs are the audio or the images or the other multimedia objects.

Q6. What is the use of Key-Value Locking In Informix?

Informix database uses a concept which is called key-value locking. Key Value locking is used to lock the deleted row. When the server deletes a row, then the critical values in the indexes of the table are not removed immediately. Instead, each key value is marked as deleted, and a lock is placed on the critical value.

Q7. What is the use of Extent in Informix?
If a table is designed without declaring the extent sizes, then the Informix uses by default 16 pages for the first and eight pages for each subsequent extent. Extent sizing should be done when the table is created.
Q8. Explain about Informix 4GL.

Informix 4GL is a fourth-generation database which was developed in the mid-'80s. Informix 4GL provides the flexibility to work without the use of third generation programming languages like COBOL. Informix 4GL is mostly used in developing business applications.

Q9. List down the features of Informix 4GL.
  • Informix 4GL database can handle the NULL values as the inputs and outputs within an Informix 4GL function.
  • Informix 4GL database does not require the input or output parameters when publishing or subscribing to a web service.
  • Informix 4GL database clients can also process structured data such as ARRAYs and RECORDs from the other 4GL applications.
  • Informix 4GL database now includes the direct support for file I/O
Q10. What is a light scan in Informix?

A light scan is the sequential data scan of the data tables when the number of pages in the table is more than the number of buffers in the buffer pool.

Reviewed and verified by Best Interview Question
Best Interview Question

With our 10+ experience in PHP, MySQL, React, Python & more our technical consulting firm has received the privilege of working with top projects, 100 and still counting. Our team of 25+ is skilled in...