Cargoflash Infotech Interview Questions and Answers

Q1. Index, Joins, Query Optimization
Add your answer
Q2. SSIS Package, Stored Procedures, Dynamic Query
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

Q1. 
Count Ways to Reach the N-th Stair Problem Statement
You are provided with a number of stairs, and initially, you are located at the 0th stair. You need to reach the Nth stair, and you can climb one or tw...read more
Ans. 
This is a problem of counting the number of distinct ways to climb a staircase with 1 or 2 steps at a time.
• Use dynamic programming to solve this problem

• Create an array to store the number of ways to reach each stair

• Initialize the base cases for 0th and 1st stair

• Iterate from 2nd stair to Nth stair and calculate the number of ways using the previous two stairs

• Return the number of ways to reach the Nth stair modulo 10^9+7
Answered by AI
Add your answer

Round duration - 45 Minutes
Round difficulty - Medium

Q1. 
Equilibrium Index Problem Statement
Given an array Arr consisting of N integers, your task is to find the equilibrium index of the array.
An index is considered as an equilibrium index if the sum of elem...read more
Ans. 
The equilibrium index of an array is the index where the sum of elements to the left is equal to the sum of elements to the right.
• Iterate through the array and calculate the total sum of all elements

• Initialize a variable to keep track of the left sum, initially set to 0

• Iterate through the array again and at each index, check if the left sum is equal to the total sum minus the left sum and the current element

• If the cond...read more
Answered by AI
Add your answer

Round duration - 15 Minutes
Round difficulty - Medium