-
Master Database Size
What are the default size of master database in sybase ?
ravi.marennavar
- May 21st, 2010
It depends on your logical page size of serverif logical page size is 2K-master db will be of 13mbif 4k - 26mbif 8k - 52mb
Satsun
- Apr 24th, 2009
The default size of a master database in sybase is 6MB for a 2K page size Adaptive server.
-
Avoid Data Changes
How to avoid Data changes while retrieving data?
-
What are the mandatory options required for BCP command utility?
srihari
- Jun 25th, 2007
usage: dataserver valid options are: -a caps_file - path to CAPs directive file -b [size_spec] - master device size specifier -c config_file - config file for server -D [size_spec] - default dat...
keerthv
- Jun 14th, 2007
Hi,Thanks, Where can i see this format file?What are 2 typesof bcp? When can i use them?Regards,keerthv
-
Views 'with check' Option
What is the use of 'with check' option in views?
Tejas More
- Jul 7th, 2011
The with check option flag prevents insertion or updating of rows that will not meet the view criteria. e.g.: create view cal_publishers_chk as ...
dhampack
- Nov 24th, 2008
When you create a view using the with check option clause, each insert and update through the view, is validated against the views selection criteria. If the rows inserted or updated are out of cri...
-
What is a deferred update in sybase?
nagaraju_p
- Sep 9th, 2009
Deferred update is donewhen the updated row does not fit in the same pagewhen the updated row needs to change information on the index pagewhen there is a subquery in the table joinwhen the update happens to the primary key which is being referenced by other foriegn keys.
JamesMike
- May 5th, 2007
Deferred updates are carried out by adaptive server. Generally in deferred updates the affected rows are analyzed and further updations needed on these rows are carried out by the adaptive server. In ...
-
How the blocker processes exist internally in sybase
deepaish
- Aug 16th, 2009
You can execute the stored procedure sp_who , this will give you process id which is blocking what. This is more usefull since sometimes user doesn't have restricted permission for master database.
mikeob
- Jun 17th, 2009
One can look at master.sysprocesses blocked column to look at what is blocking what.
-
-
What are the vital features of Sybase?
ssukralia
- Dec 3rd, 2007
Absolutely there are numerous features but most important are as follows1. Manages User Connection2. Enforces Business Rules3. Provide Recovery and BackUps4. Understand T-SQL5. Optimize Query Execution6. Maintain Databases with NO Redundancy7. Supports Data and Referential Integritymany more....
-
What is the role of Replication Server in Sybase?
Bessie
- May 5th, 2007
With regard to data management role of Replication Server in Sybase it takes the function of moving data from one source to another as and when needed. Not only bulk movement of data from one source t...
Robert
- May 5th, 2007
As the name implies Replication Server in Sybase is used for data replication. In addition to data replication other roles taken by Replication Server in Sybase are data management and heterogeneous r...
-
How to get the list of tables in Sybase?
Read Best Answer
Editorial / Best Answer
rlbafna- Member Since Mar-2008 | Mar 12th, 2008
sp_help - lists all objects (including tables and views)
List if Views : select name from sysobjects where type = "V"
rlbafna
- Mar 12th, 2008
Sp_help - lists all objects (including tables and views)
List if Views : select name from sysobjects where type = "V"keerthv
- Apr 21st, 2007
Select name from sysobjects where type="U"This gives the list of user defined tables in the current database.
-
What are the similarity between Oracle and sybase?
Mukesh
- Feb 19th, 2007
ORACLE and SYbase both are RDBMS.
-
What is defncopy and it's usage.
Copies definitions for specified views, rules, defaults, triggers, procedures, or reports from a database to an operating system file or from an operating system file to a database.
patelg1
- Oct 30th, 2008
Defncopy is a sybase tool that defines the objective statements such views, triggers, defaults,rules and so on
suji
- Jan 8th, 2007
The defncopy utility cannot copy table definitions or reports created with Report Workbench. Invoke the defncopy program directly from the operating system. defncopy provides a non-interac...
-
-
Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table?
rachitkhanna1981
- Sep 1st, 2009
When 1 clustered index is being formed on a table then the values when entered into the table have to be in the same form or there would be an error message whereas nothing of this sort is being used in non clustered index therefore more then 1 could be created.
harish_varghese
- Jun 11th, 2007
With a clustered index, Adaptive Server sorts rows on an ongoing basis so that their physical order is the same as their logical (indexed) order. Since we can maintain data in any one order only, there can be only one clustered index per table as against 249 non-clustered indexes.
-
What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase
supari
- Mar 19th, 2008
Shami,Can u elaborate more, in terms of 2 tables A and B if we do a right outer join, how can we use coalesce
shamimaziz
- Jul 21st, 2007
Coalesce is also available in SybaseThis functions evaluates the listed expressions and returns the first non-null value. If all the expressions are null, coalesce returns nullUSAGE: coalesce(expressi...
-
How to check the long running transaction ?
mikeob
- Jun 17th, 2009
In addition to syslogshold one can look at master.sysprocess and the physical_io. If this is large (several hundred thousand) you are probably looking at a query doing a table scan. syslogshold tends to only store teh *longest*.
srihari
- Jul 8th, 2007
Select * from syslogshold
-
How to view the log files in sybase
srihari
- Oct 23rd, 2007
Cd $SYBASE/$SYBASE_ASE/install
-
Update Statistics
Explain What is Update Statistics?
Rashmi121
- May 9th, 2008
ASE uses two system tables for maintaining stats on tables for obtimized query and data retrival.systabstats is used on table level and is maintained dynamically while sysstatistics maintains informat...
wramakrishna
- Mar 26th, 2008
The update statistics command helps the server make the best decisions about which indexes to use when it processes a query, by providing information about the distribution of the key values in the in...
-
Locking in Sybase
What is Locking in Sybase? What are its types?
dhampack
- Nov 24th, 2008
Sybase does support locking at row level in version 12.5 onwards.Sybase use locking in below modes- Shared- Exclusive- UpdateFor APL(all page locking), sybase locks data as well index pageFor DOL(data only locks) either row level or data page level, sybase use not transactional locking(latches)
rahul.mra
- Jul 2nd, 2008
Lock: controling access to page In sybase, locking is done at page level (whereas in Oracle, it is at row level).So, suppose if we have a lock (shared lock, write lock) on a page, than we can not access any rows in that page.
-
Db Space
How do you check db space and what are the measures available to increase the db space?
subind123
- Mar 4th, 2011
Measure available to increase the DB space:1) Drop objects which are no longer used.2) Run alter database command to increase database size.
nagaraju_p
- Sep 9th, 2009
Sp_helpdb gives information about memory used and available.sp_spaceused - gives space used..
Sybase Interview Questions
Read Best Answer
Ans