-
-
What is the difference between sybase 11.X and 12.XWhat is the advantage of UDB over sybase
mikeob
- Jun 17th, 2009
Although there are numerous differences, probably the most relevant was the introduction of data-only (pages, row level) locking for tables in 12.x. That was the biggest one that shook up the Sybase c...
-
What is a bind cache?
samala_naresh
- Aug 13th, 2008
When you install Adaptive Server, it has single default data cache, with a 2K memory pool, one cache partition and a single spinlock. To improve performance you can add data caches and bind databases...
-
What is procedure cache and data cache?
kurar
- Mar 9th, 2008
Procedure cache is the memory area where compiled query tree run e.g, procedure, batch query. Data Cache is the memory area where data that is required for the current querys running is bought from Disk on to memory for building result sets.
-
Table Locks
How to lock a table in sybase? give me its text command.
samala_naresh
- Aug 7th, 2008
lock table table_name in {share | exclusive} mode [wait [no_of_seconds] | nowait]
-
Sybase Workspace
How is Workspace used in Sybase?
mikeob
- Jun 17th, 2009
I think it needs clarification. The only 'workspace' that comes to my mind here is a *.ws file from Sybase Power Designer. In that case a workspace serves as a container for physical, logical ERDs and reports, etc.
-
Purge Data
How will you purge data from audit database?
mikeob
- Jun 17th, 2009
To back up sysaudits_0n, set up a threshold which, when triggered, copies its contents into a permanent table and uses sp_configure to set the new active audit table to sysaudits_0(n+1). This will get...
-
Stable Device
What do you mean by Stable Device in Sybase replication?
mikeob
- Jun 17th, 2009
I think the textbook term is 'stable queue' - the place on disk where transacitons/data is stored until it reaches its destination(s). Plays the role of a ledger file in JMS/Tibco.
-
Replication Thread
How will you handle when an replication thread goes down?
Rep_dba
- Apr 1st, 2010
Check Replication server error log to see why the thread is down. Fix the error and resume the thread. If it is DSI thread that is down, run following command in Rep server.resume connection to data_server.database
-
Replication Exception Log
What is exception log in replication?
Rep_dba
- Apr 1st, 2010
Skipped transactions and orphaned transactions in replication server are logged into Exceptions log. Exception log is set of three RSSD tables rs_exceptshdr, rs_exceptscmd, rs_systext. You can run rs_helpexception to see the exceptions.
-
Secondary Truncation Point
What is Secondary Truncation Point?
luisgranados
- May 20th, 2011
Is a mark in the primary db log up to which the replication agent has processed transactions.
-
Query Performance Tuning
What parameters would you look for while trying to optimise your query? How is the cost of a query measured
subi_sybase
- Dec 20th, 2010
Do a set showplan oncheck each query and see if any table scan is used....if yes, check if any index is present on tables...if index is not present try adding it....if index is present, determine what...
-
Add Not Null Column in a Table
How we can add a NotNull Column in a table by using alter command (without using default command)?
Tejas More
- Jul 7th, 2011
You can add a NOT NULL column to a table. This means that a constant expression, and not a null value, is placed in the column when the column is added. This also ensures that, for all existing rows, ...
UncaAlby
- Oct 20th, 2008
First add the column as NULL. Then populate the column with non-null data. Then modify the column to NOT NULL. You may need to set dboption "select into" to True.
-
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.
Sybase Interview Questions
Read Best Answer
Ans