InMobi Software Developer Interview Questions and Answers

Q1. What is Indexing in Mysql
Ans. 
Indexing in MySQL is a technique to improve the performance of database queries by creating a data structure that allows for faster data retrieval.
• Indexes are created on one or more columns of a table.

• They help in speeding up the search, sorting, and joining of data.

• Indexes can be created using different algorithms like B-tree, hash, or bitmap.

• Using indexes appropriately can significantly enhance query performance.

• Exam...read more
Answered by AI
Add your answer
Q2. Opps concepts in php
Ans. 
Object-oriented programming concepts in PHP
• Encapsulation: bundling data and methods together in a class

• Inheritance: creating new classes based on existing ones

• Polymorphism: using a single interface to represent different types

• Abstraction: hiding unnecessary details and exposing only essential features

• Class: blueprint for creating objects

• Object: instance of a class

• Method: function defined inside a class

• Property: variabl
Answered by AI
Add your answer

Q1. Dot net related stuffs
Add your answer
Q2. Dependency injection
Add your answer

Built an app using dot net and angular

Q1. Python, sql, etl, cloud, web tool
Add your answer

Q1. Functional question and write some sql basic query
Add your answer

Q1. Basic question on project
Add your answer

Q1. Salary negotiation and check behaviour qiestion
Add your answer

Q1. Basic JavaScript and React.js questions
Add your answer
Q2. Questions on functions, hooks and DOM
Add your answer
Q3. Questions on SSR
Add your answer
Q4. Questions on strings and arrays
Add your answer

Api related questions

Q1. What is the Triggers
Ans. 
Triggers are special types of stored procedures that are automatically executed when certain events occur in a database.
• Triggers are used to maintain referential integrity, enforce business rules, and automate actions in a database.

• They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

• Examples of triggers include auditing changes to a table, updating a related table when a record is
Answered by AI
Add your answer
Q2. What is the Stored Procedures
Ans. 
Stored procedures are precompiled SQL queries stored in a database for reuse.
• Stored procedures are used to perform specific tasks or operations in a database.

• They can improve performance by reducing the amount of data sent between the database and application.

• Stored procedures can be called from within other SQL queries or from application code.

• They can also help with security by controlling access to data and enforcin
Answered by AI
Add your answer

Q1. Pivot columns in sql
Ans. 
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
• Use the PIVOT keyword in SQL to pivot columns

• Specify the columns to pivot on and the values to display in the new columns

• Aggregate functions like SUM, AVG, COUNT can be used with PIVOT

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
Answered by AI
Add your answer
Q2. Slow changing dimensions
Add your answer
Q3. Dynamic rankx top 3
Add your answer
Q4. Field parameters
Add your answer
Q5. Stored procedures
Add your answer