Explain about the features of Sybase IQ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Explain about the features of Sybase IQ?

Sybase IQ stores data base in the form of columns of data rather in rows. This storage model improves the accessibility and search criteria for the data. Performance of the search criteria improves greatly because it searches only columns rather than the rows and columns of the database. This is also environment friendly.

(Continued on next question...)

Other Job Interview Questions

• How to replicate col = col + 1 in Sybase ?
• State some of the criticism about Sybase IQ?
• How to implement if-then-else in a select clause in Sybase
• Explain What is Update Statistics in Sybase ?
• What is the relationship between JDBC and Sybase?
• How can I return number of rows that are returned from a grouped query without using a temporary table?
• Buildmaster Configuration Definitions in Sybase
• Explain about Enterprise scalability and ROI of Data integration suite?
• Why do my page locks not get escalated to a table lock after 200 locks?
• Explain about the Sybase group?
• More...