Sybase Interview Questions - Free latest PlacementPapers, Interview Questions ....

sai6606 · 09-12-08, 05:00 PM

1. Update Statistics

2. What is the difference in storage type of numeric and decimal data types in sybase?

3. What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase

4. How to get the list of tables in Sybase?

5. What is procedure cache and data cache?

6. What are the vital features of Sybase?

7. What is the command for quitting from Sybase?

8. What is the relationship between JDBC and Sybase?

9. How to clear tempdb when the tempdb gets filled?

10. What is a bind cache?
11. How can you change to get the decimal separator as comma instead of the decimal point (.)?

12. What is Open Server in Sybase?

13. Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

14. How to view the log files in sybase

15. How to find the 2 minimum salaries in a table?

16. What is index covering? What are its merits?

17. What is autosys? Why do we need to use autosys?

18. How to find out the maximum sales of an item for each sales man.The table consists sales_man, item, sales columns, each sales man will have the different sales values for different items.here I have to find out for every sales man, which item he sold maximum

19. There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query?

20. A column name is given to you. You have to find out which table has that column. Database has 230 tables. For example: empid (column name) For this how do you find out which table has the column (empid) ?
21. How to select a last row in sybase

22. What is the difference between sybase 11.X and 12.XWhat is the advantage of UDB over sybase

23. What is Sybase’s Adaptive Server Enterprise?

24. What is Sybase SQL Server?

25. What are table partitions? how is it different with ASE 15.0 version?

26. When you change a database option when will it take effect?

27. How is a Sybase table created?

28. What are the steps for Switching to a different Sybase database?

29. What are the similarity between Oracle and sybase?

30. What are the mandatory options required for BCP command utility?
31. how to check the long running transaction ?

32. What is the default table size in Sybase?

33. how to clear the logsegment when the Secondary truncation point is on ?

34. Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table?

35. what is a deferred update in sybase?

36. What is the use of sp_helprotect in Sybase?

37. What is the role of Replication Server in Sybase?

38. What is the method for deleting a table in Sybase?

39. what is forcing an index concept in sybase

40. How is a Sybase transaction committed?

41. What are the data types supported by Sybase?
42. how the blocker processes exist internally in sybase

43. How to list the objects in Sybase?

44. What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and In real time when we go to truncate the log?

45. What are the types of Sybase index?

46. What are the operating systems in which Sybase could take its presence?

47. How is Workspace used in Sybase?

48. What is defncopy and it's usage.

49. What is the major differents between oracle & sybase

50 How many defaults can be placed on one column of a able.If this col had an existing default, what will happen if one more is added?

51. Difference between natural join and equi join?

52. Which one is faster count(*) or count(1) ?

09-12-08, 05:00 PM	#1 (permalink)
sai6606 Senior Member Join Date: Nov 2008 Posts: 311	Sybase Interview Questions 1. Update Statistics 2. What is the difference in storage type of numeric and decimal data types in sybase? 3. What is a Coalesce? What is the equivalent of Oracle/Db2 Coalesce Function in Sybase 4. How to get the list of tables in Sybase? 5. What is procedure cache and data cache? 6. What are the vital features of Sybase? 7. What is the command for quitting from Sybase? 8. What is the relationship between JDBC and Sybase? 9. How to clear tempdb when the tempdb gets filled? 10. What is a bind cache? 11. How can you change to get the decimal separator as comma instead of the decimal point (.)? 12. What is Open Server in Sybase? 13. Given a table which contains some rows with duplicate keys, how would you remove the duplicates? 14. How to view the log files in sybase 15. How to find the 2 minimum salaries in a table? 16. What is index covering? What are its merits? 17. What is autosys? Why do we need to use autosys? 18. How to find out the maximum sales of an item for each sales man.The table consists sales_man, item, sales columns, each sales man will have the different sales values for different items.here I have to find out for every sales man, which item he sold maximum 19. There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query? 20. A column name is given to you. You have to find out which table has that column. Database has 230 tables. For example: empid (column name) For this how do you find out which table has the column (empid) ? 21. How to select a last row in sybase 22. What is the difference between sybase 11.X and 12.XWhat is the advantage of UDB over sybase 23. What is Sybase’s Adaptive Server Enterprise? 24. What is Sybase SQL Server? 25. What are table partitions? how is it different with ASE 15.0 version? 26. When you change a database option when will it take effect? 27. How is a Sybase table created? 28. What are the steps for Switching to a different Sybase database? 29. What are the similarity between Oracle and sybase? 30. What are the mandatory options required for BCP command utility? 31. how to check the long running transaction ? 32. What is the default table size in Sybase? 33. how to clear the logsegment when the Secondary truncation point is on ? 34. Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table? 35. what is a deferred update in sybase? 36. What is the use of sp_helprotect in Sybase? 37. What is the role of Replication Server in Sybase? 38. What is the method for deleting a table in Sybase? 39. what is forcing an index concept in sybase 40. How is a Sybase transaction committed? 41. What are the data types supported by Sybase? 42. how the blocker processes exist internally in sybase 43. How to list the objects in Sybase? 44. What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and In real time when we go to truncate the log? 45. What are the types of Sybase index? 46. What are the operating systems in which Sybase could take its presence? 47. How is Workspace used in Sybase? 48. What is defncopy and it's usage. 49. What is the major differents between oracle & sybase 50 How many defaults can be placed on one column of a able.If this col had an existing default, what will happen if one more is added? 51. Difference between natural join and equi join? 52. Which one is faster count() or count(1) ? __________________ Sai Prepaid Mobile Recharge Online* - Airtel, Vodafone, Idea, BSNL Cellone, Reliance Mobile, Tata Indicom.