Saved Bookmarks
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Error Handling in SSIS? |
| Answer» | |
| 2. |
Why is the need for data conversion transformations? |
| Answer» | |
| 3. |
Explain the use of containers in SSIS and also their types. |
| Answer» | |
| 4. |
What is conditional split? |
| Answer» | |
| 5. |
Can we add our custom code in SSIS? |
| Answer» | |
| 6. |
Explain why variables called the most powerful component of SSIS. |
| Answer» | |
| 7. |
What is precedence constraint? |
| Answer» | |
| 8. |
Difference and similarity between merge and merge join transformation |
| Answer» | |
| 9. |
If you want to send some data from Access database to SQL server database. What are different component of SSIS will you use? |
| Answer» | |
| 10. |
Difference between control flow and data flow |
| Answer» | |
| 11. |
List few advantages of Stored procedure. |
| Answer» | |
| 12. |
What are the basic functions for master, msdb, model, tempdb databases? |
| Answer» | |
| 13. |
What is a WITH(NOLOCK)? |
| Answer» | |
| 14. |
What are COMMIT and ROLLBACK in SQL? |
| Answer» | |
| 15. |
What are ACID properties of Transaction? |
| Answer» | |
| 16. |
What is difference between stored procedure and user defined function? |
| Answer» | |
| 17. |
What are Magic tables in SQL Server? |
| Answer» | |
| 18. |
Give a example to search fr a string in all stored procedure in SQL Server. |
| Answer» | |
| 19. |
What is REPLACE and STUFF function in SQL Server? |
| Answer» | |
| 20. |
What are different types of replication in SQL Server? |
| Answer» | |
| 21. |
What is Fill factor? |
| Answer» | |
| 22. |
What is Normalization of database? What are its benefits? |
| Answer» | |
| 23. |
What is Similarity and Difference between Truncate and Delete in SQL? |
| Answer» | |
| 24. |
What is log shipping? |
| Answer» | |
| 25. |
What are cursors and when they are useful? |
| Answer» | |
| 26. |
What is RANK function? |
| Answer» | |
| 27. |
What are Sparse columns? |
| Answer» | |
| 28. |
What is OPENXML in SQL Server? |
| Answer» | |
| 29. |
What is Scheduled job and how to create it? |
| Answer» | |
| 30. |
What is Trigger? |
| Answer» | |
| 31. |
What is ROW_NUMBER function? |
| Answer» | |
| 32. |
What is difference between Index Seek vs. Index Scan? |
| Answer» | |
| 33. |
What is use of EXCEPT clause? How does it differ from NOT IN clause? |
| Answer» | |
| 34. |
What is difference between clustered and non clustered index? |
| Answer» | |
| 35. |
What is CTE (Common Table Expression)? |
| Answer» | |
| 36. |
What is difference between View and Materialized view? |
| Answer» | |
| 37. |
What is DBCC? Give few examples. |
| Answer» | |
| 38. |
What is SQL Injection? |
| Answer» | |
| 39. |
How does your SSRS maintain security? |
| Answer» | |
| 40. |
Difference between report and query parameter. Why do we need different type of parameter? |
| Answer» | |
| 41. |
Can we use custom code in SSRS? If so, explain how we can do. |
| Answer» | |
| 42. |
What’s the use of custom fields in report? |
| Answer» | |
| 43. |
Difference between drill down and drill through report. |
| Answer» | |
| 44. |
Explain use of Expression builder. |
| Answer» | |
| 45. |
How do you integrate the SSRS reports in your application? |
| Answer» | |
| 46. |
What are various aggregate functions that are available? |
| Answer» | |
| 47. |
What are various ways to enhance the SSRS report? Explain. |
| Answer» | |
| 48. |
Explain various data region available in SSRS with their use. |
| Answer» | |
| 49. |
Explain different types of Locks in SQL Server. |
| Answer» | |
| 50. |
Differentiate between a Local and a Global temporary table? |
| Answer» | |