Sybase Interview Questions and Answers

Are you a Database Administrator? Need to update DBA technical knowledge or need to prepare for a job interview? Check out this collection of Sybase Interview Questions and Answers...

Explain about the Sybase group?
Explain What is Update Statistics in Sybase ?
Explain about Sybase 365?
State some of the products of Sybase?
Explain about the features of Sybase IQ?
State some of the criticism about Sybase IQ?
Explain the structure of Adaptive server enterprise?
What is the difference in storage type of numeric and decimal data types in sybase ?
Explain about the Data integration suite features?
Explain about Power Designer Data modeling software?
Explain about the mainframe connect tools from Sybase?
Explain the benefits you can get from Mainframe connect?
What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase ?
Explanation about replication server software?
Explain about Open switch business continuity software?
Explain about Mirror Activator Disk mirroring?
What is procedure cache and data cache in Sybase?
Give the benefits of Data integration suite?
Explain about Enterprise scalability and ROI of Data integration suite?
What are the vital features of Sybase?
Explain about ETL data integration software?
Explain about Mobile enterprise application enablement?
What is SQL Server and ASE?
How to start/stop ASE when CPU reboots ?
What is the command for quitting from Sybase?
How do I move tempdb off of the Master Device?
How do I correct timeslice -201
What is RAID and Sybase?
What is the relationship between JDBC and Sybase?
How to swap a db device with another
Server naming and renaming
How to clear tempdb when the tempdb gets filled in Sybase?
How do I interpret the tli strings in the interface file?
How can I tell the datetime my Server started?
Raw partitions or regular files?
How can you change to get the decimal separator as comma instead of the decimal point (.)?
How Can I Run the ASE Upgrade Manually?
We have lost the sa password, what can we do?
What is Open Server in Sybase?
How do I set a password to be null?
Does Sybase support Row Level Locking?
How To Change varchar(m) to varchar(n) in Sybase?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
What Is Table Partitioning in Sybase ?
Can I Partition Any Table in Sybase ?
How Do I Choose Which Tables To Partition in Sybase?
Does Table Partitioning Require User-Defined Segments in Sybase?
How to view the log files in sybase
Can I Run Any Transact-SQL Command on a Partitioned Table in Sybase ?
How Does Partition Assignment Relate to Transactions in Sybase?
Can Two Tasks Be Assigned to the Same Partition in Sybase?
Must I Use Multiple Devices to Take Advantage of Partitions in Sybase?
How Do I Create A Partitioned Table That Spans Multiple Devices in Sybase?
How Do I Take Advantage of Table Partitioning with bcp in Sybase ?
How to manually drop a table in Sybase
Why not max out all my columns Sybase?
What's a good example of a transaction? Sybase
What's a natural key?in Sybase
How to Save space when inserting rows monotonically ?
How to compute database fragmentation in Sybase ?
Tasks a DBA should do in Sybase ...
How to implement database security ?
How to Shrink a Database
How do I audit the SQL sent to the server?
How to clear a log suspend
What is the best value for cschedspins?
What is Trace Flag Definitions in Sybase
What is Trace Flags -- 5101 and 5102 in Sybase ?
What is cmaxpktsz good for in Sybase?
Buildmaster Configuration Definitions in Sybase
What is CIS and how can I use it?
If the master device is full, how do I make the master database bigger?
How do I run multiple versions of Sybase on the same server?
How do I capture a process's SQL in Sybase?
How do I turn off marked suspect on my database in Sybase?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
Why do my page locks not get escalated to a table lock after 200 locks?
Sybase ASE Performance and Tuning
Temp Tables and OLTP in Sybase
Differences between clustered and non-clustered in Sybase ?
Optimistic versus Pessimistic locking in Sybase?
How do I force an index to be used in Sybase ?
Why place tempdb and log on low numbered devices?
Should I run 32 or 64 bit ASE with Solaris?
What is Intimate Shared Memory or ISM?
How do I set TS Role in order to run certain DBCCs...?
Fixing a Munged Log in Sybase ?
Hiding your password to isql in Sybase
How to remove row affected and dashes
How do I pipe the output of one isql to another?
Are there any alternatives to isql in Sybase ?
How do I make isql secure in Sybase?
How do I pipe the output of isql to a file in Sybase?
How do I bcp null dates in Sybase?
Can I use a named pipe to bcp/dump data out or in in Sybase?
How do I exclude a column in Sybase ?
Alternative to row at a time processing in Sybase ?
When should I execute an sp_recompile in Sybase?
What are the different types of (All Page) locks in Sybase?
What's the purpose of using holdlock in Sybase?
How do I find the oldest open transaction in Sybase?
How do I check if log truncation is blocked in Sybase?
The timestamp datatype in Sybase ?
When are stored procedures compiled in Sybase ?
What causes re-resolution of a stored procedure in Sybase?
What will cause the size of a stored procedure to grow in Sybase?
How do I manipulate varbinary columns in Sybase ?
How do I remove duplicate rows from a table in Sybase?
How to emulate the Oracle decode function/crosstab in Sybase
How to implement if-then-else in a select clause in Sybase
How to pad with leading zeros an int or smallint in Sybase ?
Divide by zero and nulls in Sybase
Convert months to financial months in Sybase
Hierarchy traversal - BOMs in Sybase
Calling OS commands from a trigger or a stored procedure in Sybase
Advantages/Features of Using Identities in Sybase
Disadvantages/Drawbacks of Using Identities in Sybase
Is the Identity the equivalent of Oracles auto-sequencing in Sybase?
How do I configure Identities in Sybase?
How do I Configure the burn factor in Sybase?
How do I tell which tables have identities in Sybase ?
What is my identity burn factor vulnerability right now in Sybase?
Optimizing your Identity setup for performance and maintenance in Sybase
Recovery from Large Identity value gaps in Sybase
How do I generate Sequential Keys w/o the Identity feature in Sybase?
Optimizing your home grown Sequential key generating process for any version of Sybase
How can I execute dynamic SQL with ASE in Sybase?
Is it possible to concatenate all the values from a column and return a single row?
Selecting rows N to M without Oracles rownum in Sybase?
How can I return number of rows that are returned from a grouped query without using a temporary table?
How to feed the result set of one stored procedure into another in Sybase ?
Is it possible to do dynamic SQL before ASE 12 in Sybase?
What is Open Client in Sybase?
What is the difference between DB-lib and CT-lib in Sybase?
What is this TDS protocol in Sybase?
I have upgraded to MS SQL Server 7.0 and can no longer connect from Sybase's isql.
The Basics of Connecting to Sybase
Connecting to ASE Using OLTP in Sybase
Which version of Open Client works with which ASE in Sybase?
How do I tell the version of Open Client I am running in Sybase?
What is ASA in Sybase?
On what platforms is ASA supported?
What applications is ASA good for?
Does ASA Support Replication in Sybase?
What is ASA UltraLite in Sybase?
What is Replication Server in Sybase?
Replication Server Components in Sybase?
What is the Difference Between Replication Server and SQL Remote in Sybase?
How can I improve throughput in Sybase?
Where should I install replication server in Sybase
Using large raw partitions with Replication Server on Unix in Sybase
How to replicate col = col + 1 in Sybase ?
What is the difference between an LTM and a RepAgent in Sybase?
Which should I use, RepAgent or LTM in Sybase?
Why am I running out of locks on the replicate side in Sybase ?
Someone was playing with replication and now the transaction log on OLTP is filling