what are the sql joins available in informix?

77

What is a database object in ibm informix?

97

What is the use of key-value locking in informix?

75

What is a light scan in informix?

78

what is an informix instance?

76

Name the sql joins that are available in informix.

85

An index is reaching a limitation on the number of pages it has, can you explain why this limitation exists and what work you would do to get around it?

90

what are the database server operating modes available for informix? Explain each.

86

what are the options/commands used which dbspace a database resides?

82

why a foreground write in informix decrease performance?state the reason for the same?

98

how would you convert a secondary server into a primary server ?

179

What is the use of extent in informix?

70

what is chunk in informix?

96

what rules exist regarding format, content, flame wars, etc

88

explain the purpose of optimizer directives and how/why you would use them

69