Digtinctive Trainee Analyst Interview Questions and Answers

Just Basic Questions

Q1. SQL and SDLC Questions asked. Not too difficult.
Add your answer

Q1. Just Basic Discussion.
Add your answer

Round duration - 180 Minutes
Round difficulty - Medium

Coding question 2 easy,1 hard

Q1. Ninja And Stops
Ninja wants to travel from his house to a given destination, which is ‘X’ miles from his house. Along the way, he needs to fill gas in his vehicle. He knows there are ‘Y’ stations in his wa...read more
Ans. Recursion
The simple idea that we use in this approach will be to check all the available paths. For this we create a recursive function let’s say MINIMUM_STOP_HELPER() that will return the desired path. The function will take fuel left, distance travelled, next gas station, and the array of all the stations as its parameters.
 
The base conditions for this recursive function will be:
 
• If you have enough fuel
• If y...read more
Answered by CodingNinjas
View 2 more amswers
Q2. Black Friday
It’s black friday and the supermarket near Ninja’s house is offering a special discount to every Nth customer that generates a bill. You are initially given 2 arrays, “PRODUCTS” and “PRICES” w...read more
Ans. Counting Number of Previous Customers
We can simply start by creating a hashmap that stores each product ID and corresponding price. For each customer, calculating the bill amount is simple, just multiply the quantity by the price of each product they purchased.
 
We also keep a count of previous customers and increase it as soon as generateBill is called. If this count is divisible by ‘N’, we simply apply the discou...read more
Answered by CodingNinjas
Add your answer
Q3. Ninja And His Secret Information
Ninja has recently joined the FBI. Ninja got some secret information ‘SECRET_INFORMATION’ which he wants to share with his team. But he can not send this information di...read more
Ans. Brute Force
For encoding the given ‘SECRET_INFORMATION’ we can use any algorithm. Here first, we append the number of words of ‘SECRET_INFORMATION’ and ‘!’ into our resultant decoding string ‘ENCODED_INFORMATION’. Then we append the length of each word and ‘!’. At last, we find the ‘ASCII’ value of each character and then add 3 into the ASCII value. Then we convert this ASCII value into a character and replace this with...read more
Answered by CodingNinjas
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

Asked me how to reverse string,tell me about yourself,visualise data structures in real life,dbms questions easy one

Q1. Reverse the String
You are given a string 'STR'. The string contains [a-z] [A-Z] [0-9] [special characters]. You have to find the reverse of the string.
For example:
 If the given string is: STR...read more
Ans. Optimal Solution
• Traverse the string and swap the first character with the last character, the second character with the second last character and so on.
• Basically, you need to swap the i-th character with the (N-i-1)-th character where N is the length of the string and 0-based indexing is considered.
Space Complexity: O(1)Explanation:
O(1).
 
In the worst case, only constant extra space is required.
Time Complexity: O(...read more
Answered by CodingNinjas
Add your answer

Quantitative , Reasoning and verbal

Any one language that you can choose and there will be given 2 codes with limited time and each consists 3-4 test cases each.

Q1. Based on my projects & skills that i have mentioned in my resume also we have to thorough with the latest technologies.
Add your answer
Q2. Some coding questions that we have to type code in their console and some hr questions.
Add your answer

Easy test apti questions

Dsa was asked in it to solve, 2 q

Q1. Sql asked by them
Add your answer
Q2. Normalization, define example 1nf,2nf
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• 1NF (First Normal Form) - Each column in a table must contain atomic values, and each row must be unique.

• 2NF (Second Normal Form) - Table is in 1NF and all non-key attributes are fully functional dependent on the primary key.
Answered by AI
Add your answer

It was deloitte NLA test , has 2 coding questions easy to moderate and aptitude questions

Q1. Write a program to reverse a string
Ans. 
Program to reverse a string
• Create a function that takes a string as input

• Use a loop to iterate through the characters of the string in reverse order

• Append each character to a new string to build the reversed string
Answered by AI
View 1 more amswer
Q2. Write a program to swap the substrings of two strings
Ans. 
Program to swap substrings of two strings
• Create a function that takes in two strings and two indices representing the start and end of the substrings to swap

• Use string slicing to extract the substrings and swap them

• Combine the modified substrings with the rest of the strings to get the final swapped strings
Answered by AI
Add your answer
Q3. About binary search
Add your answer
Q4. Introduce yourself
Add your answer

First round was aptitude and coding round

Q1. Questions were asked from resume
Add your answer
Q2. And concepts from OOP, DBMS, Computer Networking etc
Add your answer