Modak Analytics Interview Questions, Process, and Tips

Q1. Basic Java, Python, SQL Technical Questions.
Add your answer

Q1. Questions from SQL, Python, Java.
Add your answer
Q2. Asked to print 2 max salary in emp table.
Add your answer

Q1. Basic Personal questions.
Add your answer

Total 10ques, 3 from python and java, 4 from SQL.

There were 90 questions that need to solved in 60 min. Only eligible to next round if qualified in this round

Q1. Overriding in java
Ans. 
Overriding in Java allows a subclass to provide a specific implementation of a method that is already provided by its superclass.
• Inheritance is a key concept in overriding, where a subclass inherits methods from its superclass.

• To override a method, the method in the subclass must have the same name, return type, and parameters as the method in the superclass.

• The @Override annotation can be used to ensure that a method ...read more
Answered by AI
Add your answer
Q2. Inheritance in java
Ans. 
Inheritance in Java allows a class to inherit properties and behaviors from another class.
• Allows for code reusability and promotes the concept of 'is-a' relationship

• Subclass inherits fields and methods from superclass

• Can override methods in subclass to provide specific implementation

• Super keyword is used to access superclass methods and fields

• Example: class Dog extends Animal {}
Answered by AI
Add your answer

Q1. Introduction of yourself
Ans. 
I am a software developer with 5 years of experience in Java, Python, and SQL.
• Experienced in Java, Python, and SQL programming languages

• Worked on developing web applications using frameworks like Spring and Django

• Familiar with database management systems like MySQL and PostgreSQL
Answered by AI
Add your answer
Q2. SQL based questions
Add your answer

Q1. Suggests few places in Hyderabad
Ans. 
Hyderabad is a vibrant city with a mix of historical landmarks, modern attractions, and delicious food options.
• Charminar - iconic monument in the heart of the city

• Golconda Fort - historic fort with stunning architecture

• Hussain Sagar Lake - picturesque lake with a giant Buddha statue

• Ramoji Film City - world's largest film studio complex

• Birla Mandir - beautiful temple dedicated to Lord Venkateswara
Answered by AI
Add your answer
Q2. Favourite tv show
Ans. 
My favourite TV show is Game of Thrones.
• Epic fantasy series with complex characters and storylines

• Based on the book series 'A Song of Ice and Fire' by George R.R. Martin

• Known for its shocking plot twists and intense battles
Answered by AI
Add your answer

Apptitude test is so easy it consists of English, technical mcqs

Q1. SQL rank function
Add your answer
Q2. Difference between count, count(*)
Ans. 
count(*) counts all rows in a table, while count(column_name) counts non-null values in a specific column.
• count(*) counts all rows in a table

• count(column_name) counts non-null values in a specific column

• count(*) is generally used to get the total number of rows in a table

• count(column_name) is used to count non-null values in a specific column
Answered by AI
Add your answer

Most of the questions from the quant ,they covered mostly train problems , work and time ,pipes,simple interest,profit and loss

Aptitude test based on quantitative,logical,dsa,java,python mcqs

There will be two sessions in first round , first there will be 60+ of aptitude and second session will be of reasoning which consists of 15 questions ,but overall they will give you 90 mins of time to complete all the questions and result will be displayed immediately whether you qualified for next round or not

There will be coding round after qualifying the first round and these will be hard , many of students will disqualify in this round

Duration was around 105 minutes
aptitude, python and java were sections in this round

Q1. What are the languages based in sql
Ans. 
Languages based in SQL include T-SQL, PL/SQL, and SQL/PSM.
• T-SQL (Transact-SQL) is Microsoft's proprietary extension to SQL used in SQL Server.

• PL/SQL (Procedural Language/SQL) is Oracle's procedural language extension to SQL.

• SQL/PSM (SQL/Persistent Stored Modules) is a standard for defining stored procedures and functions in SQL.
Answered by AI
Add your answer
Q2. What do you understand by oops concepts
Ans. 
Object-oriented programming concepts that focus on classes and objects
• Encapsulation: bundling data and methods that operate on the data within a single unit

• Inheritance: ability of a class to inherit properties and behavior from another class

• Polymorphism: ability to present the same interface for different data types

• Abstraction: hiding the complex implementation details and showing only the necessary features
Answered by AI
Add your answer
Q3. Sql queries was asked to find the second highest salary
Add your answer
Q4. Java string question based on manipulation
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What are the projects that you have done
Add your answer
Q3. What are your hobbies and interest and what were your achievement in your school life and college life and was asked about the background check focused on candidate's qualities
Add your answer