Sybase interview Questions SET - I:

1. What is stored procedure?what is the maximum parameter can pass through it? It is a db objects that exists independly of the table ,Which contain a set of query.maximum paraperters pass through it is 255


2. What is Trigger?how many trigger can a table have and what are? It is internal part of a statement that fired when insert,update,delete operation taken place.Three trigger,Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table.


3. What is magic table and why it is so called? The table that exists within a trigger named as Inserted and deleted are Magic table


4. What is view?how many table can join for creating view? It is logical way of looking at physical data located in a table,16


5. How will you add a column and drop a column? Alter table table name [add][drop] column name


6. How will you find the version of Sybase? @@version


7. Compare WHERE clause and HAVING clause? Where clause cannot have Aggeregate function ,and it select the row before the group by function .having select the row after the group by


8. What is IDENTITY column? It is used for sequential,unique numbering of rows being inserted into the table.one identity column is allowed for a table


9. What is CURSOR? It is a pointer, use for row by row operation


10. How many index can have for a table? 250


11. What is Clustered and Nonclustered index? When you craete a clustered index on a table, all the rows in the table are stored in the order of the clustered index key. So, there can be only one clustered index per table. Non-clustered indexes have their own storage separate from the table data storage. Non-clustered indexes are stored as B-tree structures (so do clustered indexes), with the leaf level nodes having the index key and it's row locater.


12. While creating index I forgot to tell what type what will happen? nonclustered index


13. What is Transaction? It is set of operation to be completed at one time as a single operation.


14. What is BCP?and Types? It is used for import and export the values from table to os file and vice-ver.Fast bcp and Slow bcp


15. What is Format file? It is the file, which has certain format to store data in bcp.