{"id":14,"date":"2011-05-17T14:07:02","date_gmt":"2011-05-17T08:37:02","guid":{"rendered":"http:\/\/pramodsingla.wordpress.com\/?p=14"},"modified":"2011-05-17T14:07:02","modified_gmt":"2011-05-17T08:37:02","slug":"sql-server-2008-interview-questions","status":"publish","type":"post","link":"https:\/\/pramodsingla.com\/?p=14","title":{"rendered":"SQL Server-Interview Questions"},"content":{"rendered":"

RDBMS:<\/strong><\/span><\/h3>\n
    \n
  1. What is normalization and what are its pros and cons?<\/li>\n
  2. What is demoralization and what are its pros and cons?<\/li>\n
  3. What are ACID properties and how SQL server is maintaining these?<\/li>\n
  4. What are DML and DDL commands?<\/li>\n
  5. What is difference between a view and a table?<\/li>\n
  6. What are synonyms?<\/li>\n<\/ol>\n

    Developer:<\/u><\/strong><\/span><\/h3>\n
      \n
    1. What is the difference between index rebuilding vs index reorganizing and in which scenarios each can be\u00a0used?<\/li>\n
    2. What is the default transaction isolation level used in SQL server?<\/li>\n
    3. What is the difference between user and login?<\/li>\n
    4. What \u00a0all permissions are required\u00a0to execute scalar UDF and table valued UDF ?<\/li>\n
    5. Where does the full text catalog created in the SQL server 2008?<\/li>\n
    6. How to rename a table column?<\/li>\n
    7. What is the difference between coalesce and isnull functions?<\/li>\n
    8. What is the difference sp_executesql and exec?<\/li>\n
    9. What are magic tables?<\/li>\n
    10. How can you delete duplicate records from a table?<\/li>\n
    11. How to find the third highest salary for an employee?Ans<\/a><\/strong><\/li>\n
    12. Which all\u00a0recovery models are available in SQL Server?<\/li>\n
    13. List all system DBs with their usage.<\/li>\n
    14. What are the different isolations in SQL server and what’s the difference between them?<\/li>\n
    15. What is the difference between intersect v\/s except?<\/li>\n
    16. Temp Table vs Temp variables.<\/li>\n
    17. What is CTE?<\/li>\n
    18. What will happen if rollback is executed\u00a0in innermost transaction?<\/li>\n
    19. What will happen if commit is executed\u00a0in innermost transaction?<\/li>\n
    20. What is OUTPUT clause in TSQL?<\/li>\n
    21. What is the max size of varchar(max)?<\/li>\n
    22. What is fill factor and how it is important?<\/li>\n
    23. List few\u00a0of \u00a0DMVs with\u00a0their usage.<\/li>\n
    24. What is difference between delete and truncate?<\/li>\n
    25. What is sparse column and how is it useful?<\/li>\n
    26. By default SQL server listens on which port?<\/li>\n
    27. What is a heap?<\/li>\n
    28. What is the difference between clustered and nonclustered indexes?<\/li>\n
    29. What’s the latest version of SQL server?<\/li>\n
    30. What’s row level compression and the page level compression?<\/li>\n<\/ol>\n

      DBA:<\/strong><\/span><\/h3>\n
        \n
      1. Can you take transnational or differential backup of master database?<\/li>\n
      2. How to start SQL Server single user mode and when do you need it?<\/li>\n
      3. What’s the use of browser service?<\/li>\n
      4. How to make DAC connection?Ans<\/a><\/strong><\/li>\n
      5. What is the difference between index rebuilding and index reorganizing and in which scenario these can be\u00a0used?<\/li>\n
      6. What are the filtered\u00a0indexes and why are they useful in some scenarios?<\/li>\n
      7. What is a covering index?<\/li>\n
      8. What can cause an index scan instead of index seek?<\/li>\n
      9. Which port does DAC use?<\/li>\n
      10. What all type of backups are available in SQL Server?<\/li>\n
      11. What will you do to improve the performance of the tempdb?<\/li>\n
      12. What is snapshot isolation level and what are its pros and cons?<\/li>\n
      13. What will you do if log-files are over growing?<\/li>\n
      14. Find the running queries and the resources it is waiting on.<\/li>\n
      15. What are VLFs and why are they important to watch?<\/li>\n
      16. How to find a backup is valid without restoring it?<\/li>\n
      17. How exactly does SQL server cater a SELECT\u00a0Query?<\/li>\n
      18. How exactly does SQL server cater an UPDATE\u00a0query?<\/li>\n
      19. What is TDE and how you can set it up?<\/li>\n
      20. What type of indexes are available in SQL server?<\/li>\n<\/ol>\n

        \u00a0ETL\/SSIS:<\/strong><\/span><\/h3>\n
          \n
        1. What is difference between Control flow and Data Flow Engine?<\/li>\n
        2. List the ways of deployment available in SSIS 2012?<\/li>\n
        3. How to configure checkpoint in SSIS?<\/li>\n
        4. How to debug a SSIS package?<\/li>\n
        5. What’s new in SQL server 2012?<\/li>\n
        6. What is fast parse?<\/li>\n
        7. List 5 ways to speed up your SSIS package.<\/li>\n
        8. List the ways you can execute a SSIS package.<\/li>\n
        9. If you want to delete duplicate records that what option would you use in SSIS?<\/li>\n
        10. Explain SCD task and its working.<\/li>\n
        11. Explain Lookup task.<\/li>\n
        12. Explain SCD type 1,2 and 3.<\/li>\n
        13. How you would handle errors in SSIS?<\/li>\n
        14. How to check the execution status of \u00a0a SSIS package,deployed in SSISDB, using system tables.Ans<\/a><\/strong><\/li>\n
        15. What is factless table?<\/li>\n
        16. What is\u00a0the\u00a0difference between dimension table and fact table?<\/li>\n
        17. What is the\u00a0difference between star and snowflake\u00a0schema?<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

          RDBMS: What is normalization and what are its pros and cons? What is demoralization and what are its pros and[…]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[17,29],"tags":[102,103,161,162,174],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/14"}],"collection":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14"}],"version-history":[{"count":0,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=\/wp\/v2\/posts\/14\/revisions"}],"wp:attachment":[{"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pramodsingla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}