INTERVIEW QUESTIONS DATABASE SYBASE DETAILS

Question: What is Sybase system databases?

Answer: When you install Adaptive Server, it contains these system <br>databases:<br><br>The master database controls the user databases and the <br>operation of Adaptive Server as a whole. It stores <br>information about all user databases and their associated <br>database devices.<br><br>The model database is used by Adaptive Server as a template <br>for creating new user databases.<br> A new database cannot be smaller than the model <br>database.<br><br>? The sybsystemprocs database contains the system stored <br>procedures.<br><br>The sybsystemdb database contains information about <br>distributed transactions.<br><br>? The temporary database, tempdb, stores temporary objects, <br>including temporary tables created with the name <br>prefix ?tempdb..?.<br><br>? The sybsecurity database, contains the audit system for <br>Adaptive Server. It consists of:<br><br>The system tables, sysaudits_01, sysaudits_02, ... <br>sysaudits_08, which contain the audit trail<br>The sysauditoptions table, which contains rows describing <br>the global audit options.<br>All other default system tables that are derived from model.

When you install Adaptive Server, it contains these system <br>databases:<br><br>The master database controls the user databases and the <br>operation of Adaptive Server as a whole. It stores <br>information about all user databases and their associated <br>database devices.<br><br>The model database is used by Adaptive Server as a template <br>for creating new user databases.<br> A new database cannot be smaller than the model <br>database.<br><br>? The sybsystemprocs database contains the system stored <br>procedures.<br><br>The sybsystemdb database contains information about <br>distributed transactions.<br><br>? The temporary database, tempdb, stores temporary objects, <br>including temporary tables created with the name <br>prefix ?tempdb..?.<br><br>? The sybsecurity database, contains the audit system for <br>Adaptive Server. It consists of:<br><br>The system tables, sysaudits_01, sysaudits_02, ... <br>sysaudits_08, which contain the audit trail<br>The sysauditoptions table, which contains rows describing <br>the global audit options.<br>All other default system tables that are derived from model. 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.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question