Loading…

Informix interview questions

Informix interview questions

An Overview of Informix

Informix is the product of IBM, and it comes within the IBM’s information management division which is primarily centered upon the numerous RDBMS ((relational database management system)). According to IBM, Informix is a safely embedded database which is optimized the data for Online Transaction Processing (OLTP) and the Internet of Things (IoT).

The Informix interview questions and Informix database interview questions will be answered below in the article.

Development History

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.

Latest Version

The current version of IBM Informix is 12.10xC12 which got released on 20th July 2018.

Advantages:
  • Informix has a good OLTP performance than any other database
  • The installation of Informix is straightforward, and it just takes 100 MB of memory.
  • Informix has HADR (High Availability Data Replication) Server
  • Informix can upgrade a cluster of servers without any downtime.
Last update: 10 Oct 2019, 12 Questions and Answers

Most Frequently Asked Informix interview questions And Answers With Examples:

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.

1 0

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.

1 0

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

1 0

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.

[database[@server_name]:][owner.]object

1 0

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.

1 0

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.

0 0
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.
1 0

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.

1 0
  • 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
1 0

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.

1 0

There are four joins in the Informix:-

  • INNER JOIN
  • LEFT / RIGHT OUTER JOIN
  • FULL OUTER JOIN
  • CROSS JOIN
1 0
  • 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
1 0

Add Review

Ask Question