Question: Mention the database server operating modes available for Informix?
Answer: Informix IDS provide following modes:-<br>1)Online mode -> This is the normal operating mode of the database server.<br>2)Offline mode -> The database server is not running. Shared memory is not allocated.<br>3)Quiescent mode -> This is the normal operating mode of the database server.<br>Administrators use this mode to perform maintenance functions that do not require the execution of SQL and DDL statements.<br>Only the administrator (user informix) can access the database<br>server.<br>4)Single-User mode -> This mode is an intermediary mode between Quiescent mode and Online mode.<br> 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 in Online mode. You can see the current database server mode by executing the onstat - utility from the command.
Question:
Mention the database server operating modes available for Informix? Answer:
Informix IDS provide following modes:-<br>1)Online mode -> This is the normal operating mode of the database server.<br>2)Offline mode -> The database server is not running. Shared memory is not allocated.<br>3)Quiescent mode -> This is the normal operating mode of the database server.<br>Administrators use this mode to perform maintenance functions that do not require the execution of SQL and DDL statements.<br>Only the administrator (user informix) can access the database<br>server.<br>4)Single-User mode -> This mode is an intermediary mode between Quiescent mode and Online mode.<br> 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 in Online mode. You can see the current database server mode by executing the onstat - utility from the command. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.