Fulcrum Worldwide
4.0 of 5 7 reviews
www.fulcrumww.com Jersey City, NJ 150 to 499 Employees

Fulcrum Worldwide Interview Questions & Reviews

Updated Jan 20, 2014
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

Was this interview helpful?  
Yes | No
Flag Interview  |  Add Employer Response
RSS Feed Embed

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.

Glassdoor is your free inside look at Fulcrum Worldwide interview questions and advice. All interview reviews posted anonymously by Fulcrum Worldwide employees and interview candidates.