View full version: Sql
« 1 2 3 4 5 6 7 8 »
  1. Are sql injections illegal?
  2. From your experience can you describe the top reasons that cause SQL Server installation failures?
  3. Your customer sent you a request to suggest a service account for production SQL Server installation. How do you suggest the correct service account for SQL Server?
  4. When I say compile and execute a SQL Batch does it means compiler compiles each line of code?
  5. From your experience what are the most common reasons that causes log shipping failures?
  6. What are the differences and advantages between In-Place Upgrade and Side-By-Side Upgrade?
  7. What is the alternative way for NOT IN/NOT EXISTS/EXCEPT?
  8. Have you ever encountered the error message” Subscriptions getting expired”?
  9. If password policy is enforced; can you tell me the new password rules and policies to make sure the password is strong?
  10. What is the difference between DELETE and TRUNCATE commands?
  11. What are the impersonation options available?
  12. We have got an alert Availability group is offline.” Can you explain about this warning and your action plan?
  13. Can we be able to automate the Database Mirroring monitor process?If yes can you explain in simple steps?
  14. Is it possible to configure Database Mirroring/Log Shipping when servers are having different drive structure?
  15. Let's say our database BOOTPAGE is corrupted. How do you recover the DB?
  16. What are all types of user defined functions?
  17. What is a primary key?
  18. What is the alternative to Like” operator?
  19. You are writing a query and as per the requirement you need to use IN” clause. But your manager suggested using INNER JOIN instead of IN clause. What is your choice?Why?
  20. Have you ever come across with the problem .MSP or.MSI files are missing” while installing or patching a SQL Server?What are these files?
  21. What is Cross-Join?
  22. What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
  23. What are the types of join and explain each?
  24. What is the architecture for In-Memory OLTP?Does it's a separate component or how SQL Server handles a request when they need both disk based and memory optimized objects?
  25. How much time it takes to perform a full backup and restore of 500 GB database by using a third party tool LITESPEED and native method using SQL Server Backup / Restore option?
  26. What is the difference between ActivePassive and ActiveActive cluster?
  27. Can you sort a column using a column alias?
  28. Window's task manager is not showing the correct memory usage by SQL Server. How to identify the exact memory usage from SQL Server?
  29. From your experience can you describe the top reasons that cause SQL Server installation failures?
  30. You are assigned as a database architect for one of the premium project. Client asked you the question What are the areas where we should configure proper security principles and need to follow best practices? How do you answer the question?
  31. Your customer sent you a request to suggest a service account for production SQL Server installation. How do you suggest the correct service account for SQL Server?
  32. What is Online Transaction Processing (OLTP)?
  33. What is the quickest way to list out all database objects and their permissions to user details?
  34. How do you troubleshoot transaction log full issue?
  35. Replication has broken as the subscriber was down. When it comes online we were trying to reinitialize the subscription. It was failed with the error message Cannot Reinitialize the Subscriber.” Any idea how to fix this?
  36. On which basis you would determine the Max Server Memory Setting for SQL Server?
  37. What are the new features added for Backup and Restore on SQL Server 2016?
  38. What are various DCL commands in SQL?Give brief description of their purposes.?
  39. Have you ever implemented Instant file Initialization in any environment?If yes did you observe any performance gain?
  40. Does a WITH NOLOCK issues any lock?
  41. Any idea about filtered index?Why indexed views when we can achieve the same with filtered index?
  42. One of our databases is in simple recovery mode but still the log file is growing and it's not getting reduced after CHECKPOINT and SHRINK. Why it's log file is not getting reduced when the database is in simple recovery mode?
  43. When I say compile and execute a SQL Batch does it means compiler compiles each line of code?
  44. My requirement is to disable lock escalation only for a specific table. Is it possible?
  45. What are the most common issues a SQL DBA should deal with as a part of DBA daily job?
  46. I have configured log shipping for my database in standby mode as our business required the secondary should be available for reporting users. Now can you tell me what the major challenge that we need to face?
  47. Can you explain few reasons and convince why SQL Server scalar functions are bad?
  48. Which expressions or functions allow you to implement conditional processing in a SQL statement?
  49. Can I shrink log shipped database log file?
  50. What is Node and Disk Majority model?