Avineon India Junior GIS Engineer Interview Questions and Answers

Basic data structures, puzzles questions and statistics problems

Q1. What was your previous company project
Add your answer
Q2. What are different types of indexing
Ans. 
Different types of indexing include primary indexing, secondary indexing, clustered indexing, and non-clustered indexing.
• Primary indexing: Index based on the primary key of a table, typically implemented using a B-tree structure.

• Secondary indexing: Index based on a non-primary key column, allowing for faster retrieval of data based on that column.

• Clustered indexing: Physically reorders the table based on the indexed co...read more
Answered by AI
Add your answer
Q3. How does random forest work
Ans. 
Random forest is an ensemble learning method that builds multiple decision trees and merges their predictions.
• Random forest creates a set of decision trees from randomly selected subsets of the training data.

• Each tree in the random forest independently predicts the outcome, and the final prediction is made by averaging the predictions of all the trees.

• Random forest is effective in handling high-dimensional data and can...read more
Answered by AI
Add your answer
Q4. Explain over fitting
Ans. 
Overfitting occurs when a model learns the noise in the training data rather than the underlying pattern.
• Overfitting happens when a model is too complex and captures noise in the training data.

• It leads to poor generalization to new, unseen data.

• Regularization techniques like L1/L2 regularization can help prevent overfitting.

• Cross-validation can be used to detect and prevent overfitting.

• Example: A decision tree with too...read more
Answered by AI
Add your answer
Q5. Explain macros inExcel
Ans. 
Macros in Excel are automated sequences of commands that can be created to perform repetitive tasks.
• Macros can be recorded or written using Visual Basic for Applications (VBA)

• They can automate tasks such as formatting, data manipulation, and calculations

• Macros can be assigned to buttons or keyboard shortcuts for easy access

• They can save time and reduce errors in repetitive tasks
Answered by AI
Add your answer

Easy question. Easy to clear the round

Q1. One to one technical questions based on SQL and python.
Add your answer

Aptitude test had questions like upstream, downstream, etc

SQL questions and 2 live python coding questions

1. 2 coding questions - easy to medium type.
2. Basic machine learning/data science MCQ's

Q1. 1. Resume based questions. 3. Machine learning/deep learning/data science related common questions. 4.Data proprocessing, data cleaning common interview questions.
Add your answer
Q2. Questions related to projects done.
Add your answer

2nd round consists of 10 MCQ and 2 python coding Question

Q1. Introduce yourself
Add your answer

We were provided with 3 basic data stucture questions all three were leetcode medium easy question. Total time alloted was 1hr for three questions.

2nd round was again coding round but this time question level was hard plus 10 MCQs were also given based on basic computer science knowledge.
There were 2 data structure question that was leetcode medium hard questions.

Q1. How can you prove to the client that a students with higher classes are taller than that of lower classes?
Ans. 
We can use statistical analysis to prove that students in higher classes are taller than those in lower classes.
• Collect height data of students from different classes

• Use statistical measures like mean, median, and mode to compare the heights of students in different classes

• Perform hypothesis testing to determine if the difference in height between classes is statistically significant

• Visualize the data using graphs and ...read more
Answered by AI
View 3 more answers
Q2. Compare two arrays in python and print if both of them are same or not?
Ans. 
Compare two arrays in python and print if both of them are same or not.
• Use the '==' operator to compare the arrays.

• If the arrays have the same elements in the same order, they are considered the same.

• If the arrays have different elements or different order, they are considered different.

• Print 'Same' if the arrays are the same, otherwise print 'Different'.
Answered by AI
View 2 more answers
Q3. What is permutation and combination and how is it used in data science?
Ans. 
Permutation and combination are mathematical concepts used to count the number of possible outcomes in a given scenario.
• Permutation is the arrangement of objects in a specific order while combination is the selection of objects without considering the order.

• Permutation formula: nPr = n!/(n-r)! where n is the total number of objects and r is the number of objects selected.

• Combination formula: nCr = n!/r!(n-r)! where n i...read more
Answered by AI
Add your answer