Celestial Technologies Interview Questions and Answers

Market Research Questions

Q1. What is market research
Add your answer

Q1. Why do you want to join our company?
Add your answer

Q1. Psi mins full form
Ans. 
PSI stands for Pounds per Square Inch, a unit of pressure measurement commonly used in engineering and physics.
• PSI is used to measure pressure in various systems, such as in pneumatic tools, hydraulic systems, and air compressors.

• 1 PSI is equal to 0.068046 atmospheres or 6,894.76 Pascals.

• For example, a car tire may require inflation to 32 PSI for optimal performance.
Answered by AI
Add your answer
Q2. Firing strocks position
Ans. 
Firing strokes position refers to the position of the firing strokes in an engine.
• Firing strokes position is crucial for the proper functioning of the engine.

• The firing order of the engine determines the position of the firing strokes.

• Incorrect firing strokes position can lead to engine misfires or damage.

• Common firing orders include 1-3-4-2 for a 4-cylinder engine and 1-8-4-3-6-5-7-2 for a V8 engine.
Answered by AI
Add your answer
Q3. How to work hyd.pump
Ans. 
To work a hydraulic pump, you need to understand its components and operation.
• Understand the basic components of a hydraulic pump such as the inlet, outlet, and pistons.

• Ensure the pump is properly connected to a power source and the hydraulic system.

• Monitor the pump's pressure and flow rate to ensure optimal performance.

• Regularly check and maintain the pump to prevent any malfunctions or breakdowns.

• Examples: Gear pump,
Answered by AI
Add your answer
Q4. Injectors leack off test
Add your answer
Q5. How to use torque gun
Ans. 
A torque gun is a tool used to apply torque to fasteners such as nuts and bolts.
• Ensure the torque gun is set to the correct torque value for the fastener being tightened.

• Hold the torque gun perpendicular to the fastener and apply pressure while pulling the trigger.

• Listen for the click or beep indicating the desired torque has been reached.

• Do not over-tighten the fastener as it can cause damage.

• Regularly calibrate and m
Answered by AI
Add your answer

Q1. What is coalesce
Ans. 
Coalesce is a function used to return the first non-null value in a list of expressions.
• Coalesce function is commonly used in SQL to handle null values.

• It takes multiple arguments and returns the first non-null value.

• Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
Answered by AI
Add your answer
Q2. What is repartition
Ans. 
Repartition is the process of redistributing data across partitions in a distributed system.
• Repartitioning helps in balancing the workload and improving performance in distributed computing environments.

• It involves moving data between partitions based on certain criteria such as key values or hash functions.

• Repartitioning can be done in Spark using operations like repartition() or coalesce().
Answered by AI
Add your answer

Q1. Non repeatable character
Ans. 
A non repeatable character is a character that appears only once in a given string.
• Iterate through the string and count the frequency of each character

• Identify the characters that have a frequency of 1

• Return the first non repeatable character found
Answered by AI
Add your answer
Q2. Sort list without sort method
Ans. 
Sort list without using sort method
• Create a custom sorting function using loops

• Compare each element with every other element to determine the correct order

• Swap elements based on the comparison results
Answered by AI
Add your answer

Q1. Past Experience and Work profile
Add your answer
Q2. Future plan and work strategy in Axis My India.
Ans. 
My future plan in Axis My India is to implement data-driven strategies for accurate predictions and expand our reach in untapped regions.
• Implement data-driven strategies to improve accuracy of predictions

• Expand reach in untapped regions through targeted marketing campaigns

• Enhance customer engagement through personalized communication

• Invest in research and development for innovative solutions

• Collaborate with local partn
Answered by AI
Add your answer

Q1. Past Experience And Work profile in previous organization
Add your answer
Q2. Basic question from your work experience
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What are your strengths
Add your answer

Q1. Anatomy questions
Add your answer
Q2. Abrrevation prefix sufix
Add your answer

Report writing- you have to present a market research overview on any of industry you can visit on their website for same

Q1. Analyse market trends
Ans. 
Market trends can be analyzed by examining consumer behavior, industry reports, and economic indicators.
• Examine consumer behavior through surveys and focus groups

• Review industry reports and forecasts for insights

• Monitor economic indicators such as GDP growth and inflation rates

• Look for emerging technologies or innovations that could impact the market

• Consider geopolitical events or regulatory changes that may influence
Answered by AI
Add your answer
Q2. Guest estimate for any industry
Ans. 
Guest estimate for any industry refers to the practice of predicting the number of guests or customers a business may expect to receive within a certain period of time.
• Consider historical data and trends to make an educated guess

• Take into account external factors such as seasonality, holidays, and economic conditions

• Utilize forecasting models or software to help with the estimation process
Answered by AI
Add your answer

Python linked list dsa question

Q1. How are you what are you doing here
Add your answer
Q2. I want to hire but why?
Add your answer

Q1. Design a questionnaire, Process related question on project management, questions around conflicts within a team, DP related questions
Add your answer
Q2. Some questions were outright dumb. The interviewer was trying to prove his point with some silly responses.
Add your answer