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                      
tip   SiteMap shows list of All Categories in this site.
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
what is the architechure of sybase ASE?
 Question Submitted By :: Murali
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the architechure of sybase ASE?
Answer
# 1
The Sybase Server 
A Sybase server consists of: 
       a) Two processes, data server and backup server.
       b) Devices which house the databases; one database 
(master) contains system and configuration data.
       c) A configuration file which contains the server 
attributes. 
Memory Model 
The Sybase memory model consists of: 
	a) The program area, which is where the dataserver 
executable is stored.
	b) The data cache, stores recently fetched pages 
from the database device. 
	c) The stored procedure cache, which contains 
optimized sql calls. 
A database device stores the objects that make up 
databases. 
	The term device does not necessarily refer to a 
distinct physical device: it can refer to any piece of a 
disk (such as a disk partition) or a file in the file 
system that is used to store databases and their objects.

Each database device or file must be prepared and made 
known to Adaptive Server before it can be used for database 
storage. This process is called initialization.
A segment is a label that points to one or more database 
devices. When you first create a database, Adaptive Server 
creates three segments in the database,

System: Stores the database?s system tables.
Logsegment: Stores the database?s transaction log.
Default: Stores all other database objects?unless you 
create additional segments and store tables or indexes on 
the new segments by using create table...on segment_name or 
create index...on segment_name
 
Is This Answer Correct ?    7 Yes 0 No
Prabhu
 

 
 
 
Other Sybase Interview Questions
 
  Question Asked @ Answers
 
what is the architechure of sybase ASE? ocbc1
can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com  2
Sybase 12.5 Database Statistics (Maximum)  1
How do you troubleshoot if your tempdb gets filled HCL7
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
how to do application monitoring through AutoSys? Cognizent1
What is a temp table? how to denote temp table? Oracle3
what means of sybase ?? and how i can use sybase data base on my computer Iam the first use it >> any help please !  1
Sybase system databases  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