Accenture,Hyderabad - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. 

       I gathered Accenture, Hyderabad Company’s interview questions. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

  

    (1)   Tell me about yourself?

    (2)    How will you know that one procedure or query is slow? How will you investigate to find out the performance problem and how do you tune the queries?

    (3)   What is the use of DMV's? Please list out few important DMVs?

    (4)   What is the CTE? What is the syntax of that? When to use the CTEs?

    (5)   I have written a CTE as follows

         With CTEName

         AS

          (

                  select distinct PlanId,PlanName from ORM_BCPCoreDetails

           )

          select * from CTEName

(i)     Will the above query run? If yes, what is the output of the query?

        

         DECLARE @PlanDetails Table

         (

          PlanId  varchar(50),

          PlanName Varchar(255)

         )

        

         With CTEName

         AS

          (

                  select distinct PlanId,PlanName from ORM_BCPCoreDetails

           )

          insert into @PlanDetails

          select * from CTEName

       select * from @PlanDetails

(ii)            Will the above quey run? If yes, what is the output of the query?

                    

         DECLARE @PlanDetails Table

         (

          PlanId  varchar(50),

          PlanName Varchar(255)

         );

        

         With CTEName

         AS

          (

                  select distinct PlanId,PlanName from ORM_BCPCoreDetails

           )

          insert into @PlanDetails

          select * from CTEName

          select * from @PlanDetails

(iii)           Can I declare a temporary table and insert the data from cte to temporary table?

    (6)   Can I create a clustered index on the unique key?

    (7)   Will the foreign key allows the NULL values?

    (8)   What is the use of MERGE statement in Sqlserver?

    (9)   What is the difference between ISNULL and NULLIF statements?

    (10) What is the use of PIVOT and UNPIVOT statements?

   (11) What is the use of triggers? What are the types of triggers we have? When did you use triggers in your project?

    (12) What are the magic tables and what is the use of them?

    (13) What is the use of Isolation levels? What is the default isolation level in sqlserver?

    (14) How will you implement error handling in Sqlserver?

    (15)  How will you handle “Batch Processing” in Sqlserver?

    (16) What is the fragmentation?

    (17) What will happen when we rebuild the indexes? Do we need any downtime?

    (18) What is Mirroring? Does it require any downtime?