ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  Sybase
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Sybase system databases
 Question Submitted By :: Prabhu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Sybase system databases
Answer
# 1
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 ?    0 Yes 0 No
Prabhu
 

 
 
 
Other Sybase Interview Questions
 
  Question Asked @ Answers
 
How do you troubleshoot if your tempdb gets filled HCL4
what is the architechure of sybase ASE? ocbc1
In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id? ISRO1
can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com  1
What is a temp table? how to denote temp table? Oracle2
Sybase system databases  1
Sybase 12.5 Database Statistics (Maximum)  1
 
For more Sybase Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com