SQL Server Interview Question and Answers

46. What are different type of Collation Sensitivity?
 
    The different phases of transaction are :
  • Case sensitivity
  • Accent sensitivity
  • Kana Sensitivity
  • Width sensitivity
47. What is the difference between a check constraint and a rule?
  Check constraints and rules limit the range of values that a user can enter into a column. Whereas check constraints apply only to the table for which you enter them, you can apply rules to multiple tables.
48. What function extracts specified characters from a string?
  The SUBSTRING function extracts specified characters from a string.
49. What is the difference between TRUNCATE and DROP?
  TRUNCATE removes all data from the table while retaining the table structure, whereas DROP removes the table from the database.
50. What are the different types of cursor?
 
    There are three types of cursors :
  • Implicit cursors
  • Explicit cursors
  • Paramaeteried cursors
123456789101112131415

Page 10 of 15