Question.1 Explain about your SQL Server DBA Experience? Answer: This is a generic question often asked by many interviewers. Explain what are the different SQL Server Versions you have worked on, what kind of administration of those instances has been done by you. Your role and responsibilities carried out in..
Question.1 Tell me the importance of a flow chart? Answer: The flow chart gives a clear graphical representation of an implemented process. This makes the system simple to understand for all persons involved in the project. Question.2 Explain briefly the use case model? Answer: The use case model requires a..
Question.1 What is a Data Warehouse? Answer: A Data Warehouse is a collection of data marts representing historical data from different operational data source (OLTP). The data from these OLTP are structured and optimized for querying and data analysis in a Data Warehouse. Question.2 What is a Data mart? Answer: ..
Question.1 What is Query parameter in SSRS? Answer: Query parameters is mentioned in the query of the datasources that are to be included into the SQL script’s WHERE clause of the SQL that can accept parameters. Query parameters begin with the symbol @.The name should not contain spaces and can..