Perspecta is now part of Peraton. For up-to-date information, please see the Peraton profile..
Perspecta SQL Developer interview questions
Updated Feb 2, 2020
based on 1 rating
Difficulty
Difficult
Experience
Very positive
How others got an interview
Oops! No information available yet
Interview search
1 interviews
Perspecta interviews FAQs
SQL Developer applicants have rated the interview process at Perspecta with 4 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 100% positive. To compare, the company-average is 67.7% positive. This is according to Glassdoor user ratings.
Here are the most commonly searched roles for interview reports -
The whole process took about one month. There are three round interviews. The first and second ones were all asking technical questions. The third round was behavioral and technical questions.
Interview questions [3]
Question 1
1st round:
My query runs slow. What to do?
Window function you used before.
Given two tables:
products -- productid, productname
orders -- orderid, productid, quantity, orderdate
1) Write a SP to find the [product name] based on the [product id] input.
2) Write a SP to find the [order id] based on [part of the product name] as input.
3) Orders placed in the month of Feb this year?
2nd round:
Given a School DB with Professor, Student, Class, Score tables.
1) How many classes does each professor teach?
2) Display AverageScoreForClass and AverageScoreForProfessor.
3) Write a SP to get a student’s score
4) Display StudentName, ClassName, MAX(Score) which got max score for each class.
How to optimize a SSIS package?
How to use Checkpoint?
3rd round:
What’s the most challenging task you’ve done?
What’s the most complicated data cleansing you’ve done?
How big the data input have you deal with before?