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

ANSWERS