Add office photos
Optimum Infosystem logo
Engaged Employer

Optimum Infosystem

Verified
3.4
based on 496 Reviews
Filter interviews by

10+ Optimum Infosystem Interview Questions and Answers

Updated 5 Feb 2024

Q1. What is the flow of redux?

Ans.

Redux flow involves dispatching actions, updating the store, and triggering re-rendering of components.

  • Actions are dispatched from components

  • Reducers update the store based on the action

  • Store notifies subscribed components of state change

  • Components re-render with updated state

View 1 answer
right arrow

Q2. WHat financial security you have if we shut down after 3 months

Ans.

I have savings, investments, and a strong network for potential job opportunities.

  • I have a substantial emergency savings fund that can cover my expenses for several months.

  • I have diversified investments that can provide additional financial support if needed.

  • I have a strong professional network that can help me find new job opportunities quickly.

  • I am open to exploring freelance or consulting opportunities to generate income during the shutdown period.

Add your answer
right arrow

Q3. what are the rules of hooks?

Ans.

Hooks are functions that let you use state and other React features without writing a class.

  • Hooks are introduced in React 16.8

  • Rules of hooks are: Only call hooks at the top level, Only call hooks from React functions, Only call hooks from custom hooks

  • Examples of hooks are useState, useEffect, useContext, useReducer, useMemo, useCallback, useRef

Add your answer
right arrow

Q4. what is list comprehension? what is constructor? what are schemas?

Ans.

List comprehension is a concise way to create lists in Python. Constructor is a special method used to initialize objects. Schemas are blueprints for organizing data.

  • List comprehension is a shorthand way to create lists in Python

  • It is a concise way to write a for loop and append to a list in a single line

  • Example: squares = [x**2 for x in range(10)]

  • Constructor is a special method used to initialize objects

  • It is called when an object is created from a class

  • Example: class Person...read more

Add your answer
right arrow
Discover Optimum Infosystem interview dos and don'ts from real experiences

Q5. How will you use Inner and Outer Joins

Ans.

Inner joins are used to return rows that have matching values in both tables, while outer joins return all rows from one table and only matching rows from the other table.

  • Use inner join to retrieve rows with matching values in both tables

  • Use outer join to retrieve all rows from one table and only matching rows from the other table

  • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

  • Example: SELECT * FROM table1 LEFT OUTER JOIN table2 ON table1.id = table2.i...read more

Add your answer
right arrow

Q6. what are DBMS what is SQL?

Ans.

DBMS stands for Database Management System. SQL is a programming language used to manage and manipulate data in DBMS.

  • DBMS is a software system that allows users to create, manage, and manipulate databases.

  • SQL (Structured Query Language) is a programming language used to communicate with DBMS and perform operations on data.

  • DBMS and SQL are used in various industries such as finance, healthcare, and e-commerce.

  • Examples of popular DBMS include Oracle, MySQL, and Microsoft SQL Se...read more

Add your answer
right arrow
Are these interview questions helpful?

Q7. properties of display flex

Ans.

Display flex is a CSS property that allows flexible layout of elements within a container.

  • It enables responsive design by automatically adjusting the size and position of elements

  • It allows for easy alignment and distribution of elements along the main and cross axis

  • It can be used to create complex layouts with minimal code

  • It supports both horizontal and vertical layouts

  • Example: display: flex; justify-content: center; align-items: center;

Add your answer
right arrow

Q8. Give Springboot example for nested loops

Ans.

Using nested loops in Springboot to iterate over a list of objects

  • Create a list of objects to iterate over

  • Use nested for loops to iterate over the list

  • Access the properties of each object within the nested loops

Add your answer
right arrow
Share interview questions and help millions of jobseekers 🌟
man with laptop

Q9. Give examples of latency delisting

Ans.

Latency delisting refers to removing items from a list due to excessive delay.

  • Latency delisting is common in online marketplaces where products with slow shipping times are removed from search results.

  • In finance, stocks with significant delays in reporting financial information may be delisted from exchanges.

  • In healthcare, medications with long wait times for regulatory approval may be delisted from formularies.

Add your answer
right arrow

Q10. Define a SQL MODE METER DATA

Ans.

SQL MODE METER DATA is a setting that determines how strict or lenient MySQL is when handling invalid or missing values in queries.

  • SQL MODE METER DATA is a configuration setting in MySQL that affects how queries are processed.

  • It determines the behavior of MySQL when encountering invalid or missing values in queries.

  • It can be set to different modes like STRICT_ALL_TABLES, TRADITIONAL, etc.

  • For example, in STRICT_ALL_TABLES mode, MySQL will return an error if a value doesn't mee...read more

Add your answer
right arrow

Q11. Give android development apk creation

Ans.

Android development apk creation involves compiling the code into an executable file for installation on Android devices.

  • Write the code in Java or Kotlin

  • Use Android Studio to build and compile the code

  • Generate a signed APK for distribution

  • Test the APK on different devices to ensure compatibility

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Senior Consultant Interview Questions from Similar Companies

Infosys Logo
3.7
 • 71 Interview Questions
LTIMindtree Logo
3.9
 • 21 Interview Questions
Capita Logo
3.6
 • 15 Interview Questions
Cognizant Logo
3.8
 • 14 Interview Questions
Accenture Logo
3.9
 • 11 Interview Questions
View all
Share an Interview
Profile Image
Hello, Guest
Awards 2025
Contribute to help millions!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos
Add office benefits
Add office benefits
Stay ahead in your career with AmbitionBox app