Sybase system databases

Answers were Sorted based on User's Feedback



Sybase system databases..

Answer / prabhu

When you install Adaptive Server, it contains these system
databases:

The master database controls the user databases and the
operation of Adaptive Server as a whole. It stores
information about all user databases and their associated
database devices.

The model database is used by Adaptive Server as a template
for creating new user databases.
A new database cannot be smaller than the model
database.

? The sybsystemprocs database contains the system stored
procedures.

The sybsystemdb database contains information about
distributed transactions.

? The temporary database, tempdb, stores temporary objects,
including temporary tables created with the name
prefix ?tempdb..?.

? The sybsecurity database, contains the audit system for
Adaptive Server. It consists of:

The system tables, sysaudits_01, sysaudits_02, ...
sysaudits_08, which contain the audit trail
The sysauditoptions table, which contains rows describing
the global audit options.
All other default system tables that are derived from model

Is This Answer Correct ?    11 Yes 0 No

Sybase system databases..

Answer / dilip voora

By default master, model, sybsystemdb, sybsystemprocs and tempdb will be installed after installing ASE on your machine.

sybmgmtdb is an optional database which is using for scheduling task, jobs etc.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Sybase Interview Questions

What is a natural key in sybase?

0 Answers  


What are the advantages that you can get from mainframe connect in sybase?

0 Answers  


What do you mean by mainframe connect tool in sybase?

0 Answers  


Explain the structure of adaptive server enterprise?

0 Answers  


Explain about the mainframe connect tools from sybase?

0 Answers  


Why not max out all my columns sybase?

0 Answers  


How do I connect to sybase?

0 Answers  


How do you view log files in sybase?

0 Answers  


What is trace flags — 5101 and 5102 in sybase?

0 Answers  


Which should I use, repagent or ltm in sybase?

0 Answers  


How does partition assignment relate to transactions in sybase?

0 Answers  


Sybase 12.5 Database Statistics (Maximum)

1 Answers  


Categories