Explain the structure of Adaptive server enterpr

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

(Continued from previous question...)

Explain the structure of Adaptive server enterprise?

Structure of ASE installation hosts several databases and it comprises of one data server. Also system files occupy only one meta data. User databases are stored in the form of tables. Security and information privacy can be protected by setting permissions.

(Continued on next question...)

Other Job Interview Questions

• How do I bcp null dates in Sybase?
• How do I set TS Role in order to run certain DBCCs...?
• Alternative to row at a time processing in Sybase ?
• Explain the benefits you can get from Mainframe connect?
• Which should I use, RepAgent or LTM in Sybase?
• Explain about ETL data integration software?
• Does Table Partitioning Require User-Defined Segments in Sybase?
• How do I remove duplicate rows from a table in Sybase?
• How to manually drop a table in Sybase
• Recovery from Large Identity value gaps in Sybase
• More...