Questions on 'database programming' tag

  1. What is the Log Shipping?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1663
    0
    1

  2. What is the difference between reference type and value type?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 2586
    0
    1

  3. What is the DBCC command and why it is used?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1601
    0
    1

  4. What is Denormalization?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1750
    0
    1

  5. What is the standby server?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1102
    0
    1

  6. What is CHECK Constraint in SQL Server?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1132
    0
    1

  7. How many types of database relationship are there in SQL Server?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1139
    0
    1

  8. What is sub-query in SQL Server? Explain its Properties?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1140
    0
    1

  9. What is the use of FLOOR function in SQL Server?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1109
    0
    1

  10. What are the Hotfixes and Patches in SQL Server?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1081
    0
    1

  11. What are the different types of replication in SQL Server?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1143
    0
    1

  12. What is the difference between Application object and session object?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1025
    0
    1

  13. What is the SQL Server Agent?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1053
    0
    1

  14. What are the authentication modes in SQL server? How can it be changed?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1064
    0
    1

  15. How can you hide the SQL Server Instances?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1017
    0
    1

  16. What are the advantages of using stored procedures in SQL Server?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1070
    0
    1

  17. What is the difference between HAVING Clause and WHERE Clause in SQL Server?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1150
    0
    1

  18. What’s the difference between a primary key and a unique key?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1166
    0
    1

  19. What is OLTP?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1037
    0
    1

  20. What is the recovery model? List the types of recovery model available in Sql Server?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1084
    0
    1

  21. List the different index configuration possible for a table?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 884
    0
    0

  22. What is the difference between Clustered and Non-Clustered index?

    Shikhar Arora Asked by Shikhar Arora 6 years ago 1036
    0
    1

  23. What is DBMS? Explain the Advantages of DBMS?

    Asked by Anonymous User 7 years ago 1904
    0
    1

  24. What is User Defined Functions? What kind of User-Defined Functions can be created?

    Asked by Anonymous User 8 years ago 1086
    1
    1

  25. What are primary keys and foreign keys?

    Asked by Anonymous User 8 years ago 1159
    1
    1

  26. What are different Types of Join?

    Asked by Anonymous User 8 years ago 1120
    0
    1

  27. What is sub-query? Explain properties of sub-query?

    Asked by Anonymous User 8 years ago 1074
    1
    1

  28. What is Difference between Function and Stored Procedure?

    Asked by Anonymous User 8 years ago 1184
    1
    1

  29. What is a Linked Server?

    Asked by Anonymous User 8 years ago 1113
    1
    1

  30. What is Nested Trigger?

    Asked by Anonymous User 8 years ago 1168
    1
    1

  31. What is Trigger?

    Asked by Anonymous User 8 years ago 1115
    1
    1

  32. What is Stored Procedure?

    Pedro Araez Asked by Pedro Araez 8 years ago 1117
    1
    1

  33. What is De-normalization?

    Asked by Anonymous User 8 years ago 1173
    1
    1

  34. What is Normalization?

    Asked by Anonymous User 8 years ago 1474
    1
    1

  35. What is RDBMS?

    Asked by Anonymous User 8 years ago 2950
    1
    1