database
Replies to this thread:
More by database
What people are reading
Subscribers
Please log in to subscribe to database's postings.
:: Subscribe
|
Sybase Learning thread!!!
[VIEWED 976
TIMES]
|
SAVE! for ease of future access.
|
|
|
database
Please log in to subscribe to database's postings.
Posted on 11-11-07 2:16
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Hi folks,I have started this thread to share our knowledge and experiences of Sybase.Please share your experiences here.
I am starting here with simple problem and its solution I found out in net.
What are the data types supported by Sybase?
: The data types supported by Sybase are integer, smallint, tinyint, float, real, double precision, smallmoney, money, decimal, char(n), varchar(n), text, image, datetime, timestamp, timestamp, varbinary(n), binary(n) and bit.
!Enjoy Learning by sharing of knowledge!
|
|
|
|
database
Please log in to subscribe to database's postings.
Posted on 11-11-07 5:34
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
what is the architechure of sybase ASE?
Ans: 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
Source : http://www.allinterview.com/showanswers/29111.html
Please add your say on any queries so we can make this thread interactive..
|
|
Please Log in! to be able to reply! If you don't have a login, please register here.
YOU CAN ALSO
IN ORDER TO POST!
Within last 90 days
Recommended Popular Threads |
Controvertial Threads |
डीभी परेन भने खुसि हुनु होस् ! अमेरिकामाधेरै का श्रीमती अर्कैसँग पोइला गएका छन् ! |
शीर्षक जे पनि हुन सक्छ। |
What are your first memories of when Nepal Television Began? |
Sajha Poll: नेपालका सबैभन्दा आकर्षक महिला को हुन्? |
NRN card pros and cons? |
Basnet or Basnyat ?? |
निगुरो थाहा छ ?? |
Nas and The Bokas: Coming to a Night Club near you |
TPS Re-registration |
अमेरिकामा छोरा हराएको सूचना |
Breathe in. Breathe out. |
Drawback for applying NRN card |
nrn citizenship |
Democrats are so sure Trump will win |
My facebook archive (for sale) |
Top 10 Anti-vaxxers Who Got Owned by COVID |
Doctors dying suddenly or unexpectedly since the rollout of COVID-19 vaccines |
ढ्याउ गर्दा दसैँको खसी गनाउच |
Sajha has turned into MAGATs nest |
Send Parcels from USA to Nepal & Worldwide. |
|
Nas and The Bokas: Coming to a Night Club near you |
|
NOTE: The opinions
here represent the opinions of the individual posters, and not of Sajha.com.
It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address
if you want any posting to be considered for deletion. Your request will be
handled on a one to one basis. Sajha.com is a service please don't abuse it.
- Thanks.
|