Optimum Infosystem Technical Consultant Interview Questions and Answers

Q1. Basic knowledge of your skills
Add your answer
Q2. Scenario based questions.
Add your answer

Q1. Scenario based questions
Add your answer
Q2. SQL technical question.
Add your answer

Q1. Salary Discussion, joining date negotiation and Joining Bonus.
Add your answer

Q1. Tell us about yourself
Add your answer
Q2. Lot of questions on SQL and Linux commands
Add your answer

Q1. Tell us about yourself
Add your answer
Q2. It was a manager round combined with some technical questions
Add your answer

Q1. Introduce yourself, including what' s your roles and responsibility and what's your day to day task
Add your answer
Q2. Given a scenario, suppose there is slowness in system, and there is no APM tool then how will you identify the issue and solve it.
Ans. 
Identify potential causes through system analysis, logs, and monitoring tools. Implement troubleshooting steps to resolve the issue.
• Analyze system performance metrics such as CPU usage, memory usage, disk I/O, and network traffic to identify bottlenecks.

• Check system logs for any error messages or warnings that could indicate the source of the slowness.

• Review application logs to see if there are any specific requests or...read more
Answered by AI
Add your answer
Q3. Question on thread dump, in what case it should be taken, how many thread dumps are required and at what interval.
Add your answer
Q4. If there is slowness in system and you have thread dump, what analysis you will do from it
Ans. 
I would analyze the thread dump to identify any bottlenecks or issues causing the system slowness.
• Identify any threads that are in a blocked or waiting state

• Look for any threads consuming excessive CPU or memory

• Check for any deadlocks or resource contention issues

• Analyze the stack traces to pinpoint the root cause of the slowness
Answered by AI
Add your answer
Q5. Do study about all web and app server and also respective logs
Add your answer

Q1. Difference between first() or FirstOrDefault()
Ans. 
first() returns the first element of a sequence, while FirstOrDefault() returns the first element or a default value if the sequence is empty.
• first() throws an exception if the sequence is empty, while FirstOrDefault() returns a default value (e.g. null) in that case.

• Use first() when you expect the sequence to always have at least one element, and FirstOrDefault() when the sequence might be empty.

• Example: var numbers =...read more
Answered by AI
Add your answer
Q2. Left join vs right join
Ans. 
Left join includes all records from the left table and matching records from the right table, while right join includes all records from the right table and matching records from the left table.
• Left join: includes all records from the left table and matching records from the right table

• Right join: includes all records from the right table and matching records from the left table

• Example: Left join - SELECT * FROM table1...read more
Answered by AI
Add your answer
Q3. Optimization of SQL query
Ans. 
Optimizing SQL queries involves using indexes, minimizing joins, and avoiding unnecessary columns.
• Use indexes on columns frequently used in WHERE clauses

• Minimize the use of JOIN operations

• Avoid selecting unnecessary columns in the query

• Consider using stored procedures for frequently executed queries
Answered by AI
Add your answer
Q4. Tool used to check query slowness
Ans. 
One tool used to check query slowness is SQL Server Profiler.
• SQL Server Profiler can be used to trace and analyze query performance.

• It provides detailed information on query execution, including duration, reads, writes, and more.

• Users can identify slow queries and optimize them for better performance.

• Other tools like Query Store in SQL Server Management Studio can also be used for monitoring query performance.
Answered by AI
Add your answer
Q5. Design repository pattern using EF core
Ans. 
Repository pattern using EF core for data access layer
• Create an interface for the repository with generic CRUD methods

• Implement the repository interface with EF core for data access

• Use dependency injection to inject the repository into services

• Separate concerns by having repositories handle data access logic
Answered by AI
Add your answer

Q1. Mix of coding, theory and design questions
Add your answer

Write a program on priority queue

Q1. Questions on network protocol
Add your answer
Q2. Question on non-blocking socket
Add your answer
Q3. Question on linked list
Add your answer

Q1. Interview with cliient directly similar questions like round 2
Add your answer

Q1. Builder design pattern in java
Ans. 
Builder design pattern is a creational design pattern used to construct complex objects step by step.
• Builder pattern separates the construction of a complex object from its representation.

• It allows the same construction process to create different representations of the object.

• Useful when there are multiple ways to construct an object or when the object creation process is complex.

• Example: StringBuilder in Java allows ...read more
Answered by AI
Add your answer
Q2. Docker, MQ series involved
Add your answer
Q3. JOIN Query with country , emp name
Ans. 
JOIN query to retrieve country and employee name
• Use JOIN keyword to combine data from multiple tables

• Specify the columns to select from each table

• Use ON keyword to specify the relationship between the tables
Answered by AI
Add your answer