Fulcrum Worldwide

  www.fulcrumww.com
Work in HR? Unlock Free Profile

Fulcrum Worldwide Interview Questions & Reviews

1 candidate interview Back to all interview questions
Relevance Date Difficulty
in

No Offer

Positive Experience

Average Interview

SQL Server Developer Interview

SQL Server Developer
Pune (India)

I interviewed at Fulcrum Worldwide in January 2013.

Interview Details – technical round

Interview Question – what is materialized view and why it is required?what is pivot? when to use the non-clustered index and when to use clustered one.what will you do if your database is growing out of size?how to optimize the query or stored proc? how to read execution plan and what steps to take on it? write query which can add row number column for a table? what is partition? diff between temp table and temp table variable? scope of global variable? there are two tables both have only one column which accepts null, both table have 5 rows as 1,1,1,1,null. how many rows will come for inner join, left, right, union and union all on these two tables.(try this on SSMS)? High level design for employee, tasks and timesheet scenario etc   Answer Question

Worked for Fulcrum Worldwide? Contribute to the Community!

The difficulty rating is the average interview difficulty rating across all interview candidates.

The interview experience is the percentage of all interview candidates that said their interview experience was positive, neutral, or negative.

Your response will be removed from the review – this cannot be undone.