10+ Modak Analytics Interview Questions and Answers

Sorting an array of infinite length with only three elements (-1, 0, 1)

• Use counting sort algorithm to count the frequency of each element

• Create a new array with sorted elements based on their frequency

• Time complexity is O(n) and space complexity is O(1)

• Example: [-1, 1, 0, 1, -1, 0, 1, -1, 0, 1, ...]

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

Program to get minimum number of coins.

• Create an array of coin denominations

• Sort the array in descending order

• Loop through the array and subtract the highest denomination possible

• Repeat until the remaining amount is 0

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

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 is actually being overridden.

• Overriding allows for polymor...read more

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 {}

The program checks if a given sentence is a palindrome or not.

• Prompt the user to input a sentence

• Remove all spaces and punctuation from the sentence

• Reverse the sentence and compare it with the original sentence to check for palindrome

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.

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

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

Data structures are ways of organizing and storing data in a computer so that it can be accessed and used efficiently.

• Data structures can be linear or non-linear

• Examples of linear data structures include arrays, linked lists, and stacks

• Examples of non-linear data structures include trees and graphs

• Choosing the right data structure can greatly impact the efficiency of algorithms