A binary large object, also known as a blob, is a collection of binary data stored as a single entity in a database management system. Informix invented an alternative backronym, Binary Large Object. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob.
If a table is designed without specifying extent sizes, Informix uses a default of 16 pages for the first and 8 pages for each subsequent extent. Extent sizing is done when the table is initially created.
Light scans occur under the following conditions: The optimizer chooses a sequential scan of the table. The number of pages in the table is greater than the number of buffers in the buffer pool. The isolation level obtains no lock or a shared lock on the table: Dirty Read (including non logging databases) isolation level Repeatable Read isolation level if the table has a shared or exclusive lock
Committed Read isolation if the table has a shared lock
Informix IDS provide following modes:-
1)Online mode -> This is the normal operating mode of the database server.
2)Offline mode? -> The database server is not running. Shared memory is not allocated.
3)Quiescent mode -> This is the normal operating mode of the database server.
Administrators use this mode to perform maintenance functions that do not require the execution of SQL and DDL statements.
Only the administrator (user informix) can access the database
server.
4)Single-User mode -> This mode is an intermediary mode between Quiescent mode and Online mode?
Administrators use this mode to perform any maintenance task, including tasks requiring the execution of SQL and DDL statements. Administrators can also perform all other functions available inOnline mode. You can see the current database server mode by executing the onstat - utility from the command.
Webmaster 22nd of May 2012
Tell us what you feel about Informix Interview Questions and Answers
All comments will be published after review. No login or registration is required to post a comment on Informix Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
So start sharing your thoughts regarding Informix Interview Questions and Answers
Thank you.
Taran (1 Comment) 29th of January 2012
Super ecxtied to see more of this kind of stuff online.