View full version: Sql
1 2 3 4 5 6 7 8 »
  1. Is a NULL value same as zero or a blank space?If not then what is the difference?
  2. What is the difference between VARCHARAND CHAR datatypes?
  3. What is a Cursor?
  4. What are LooksAlive” and IsAlive” checks?
  5. What are various DDL commands in SQL?Give brief description of their purposes.?
  6. What are the specific uses of SQL functions?
  7. We shouldn't give ALTER TABLE” permission.?
  8. How to rebuild the system databases?
  9. How do you search for a value in a database table when you don't have the exact value to search for?
  10. What is SLA, incident, Change Request, Service Request, Problem Request?
  11. How do you copy rows from one table to another?
  12. Which function returns the remainder in a division operation?
  13. What are the different types of lock modes in SQL Server?
  14. What is the use of the NULLIF function?
  15. How to know the number of VLF created on a given database log file?
  16. You got an alert that says a user database log file is growing and it reached 85%. How do you handle the situation?
  17. What is WRK file in log shipping?
  18. What is Instant File Initialization and how it works?
  19. What Quorum mode you recommend for a given cluster?
  20. What are the case manipulation functions of SQL?
  21. What are some common reasons why database restores fail?
  22. What are the advantages and disadvantages of a contained database feature?
  23. In your system AUTO UPDATE STATISTICS is on and can you tell me on which basis UPDATE STATISTICS” triggered?
  24. Are sql databases encrypted?
  25. What is the difference between SQL and PL/SQL?
  26. What are the different ways to prevent SQL Injection?
  27. What is the recommended setting for MAXDOP?
  28. What is Auto Increment?
  29. What is the difference between Cluster and Non-Cluster Index?
  30. What is Union, minus and Interact commands?
  31. Is there any difference between disabling CLUSTERED and NON-CLUSTERED Index?
  32. How much network bandwidth is required for a successful Always On AG setup?
  33. What is Datawarehouse?
  34. Which SQL statement is used to add, modify or drop columns in a database table?
  35. What happens if you omit the WHERE clause in a delete statement?
  36. What is Private Network in windows cluster?
  37. How to get the port number where the SQL Server instance is listening?
  38. What is subquery?
  39. Can you quickly describe the events occurs when a failover happens??
  40. How many IP Addresses we require for setting up ActiveActive SQL Server cluster with Analysis services?
  41. What is a query?
  42. You are assigned to handle a very large database (5 TB). What is your approach in updating statistics?
  43. Can you remove rows from a table based on values from another table?Explain?
  44. While creating an index if I mention PAD INDEX” what does it mean?
  45. What is the difference between pessimistic and optimistic locking?
  46. Window's task manager is not showing the correct memory usage by SQL Server. How to identify the exact memory usage from SQL Server?
  47. What is user defined functions?
  48. What is the difference between cross joins and natural joins?
  49. How do you insert null values in a column while inserting data?
  50. What is a relationship and what are they?