Cps Oil And Gas Equipments Interview Questions and Answers

Q1. Write SQL query to return the latest login date for each primary key?
Ans. 
SQL query to return latest login date for each primary key
• Use GROUP BY clause to group by primary key

• Use MAX() function to get the latest login date

• Join the tables if necessary
Answered by AI
Add your answer
Q2. How to find the number of times a number repeats in an array (with less time complexity)?
Ans. 
Use a hashmap to store the frequency of each number in the array.
• Create a hashmap to store the frequency of each number in the array.

• Iterate through the array and update the frequency in the hashmap.

• Retrieve the frequency of the desired number from the hashmap.
Answered by AI
Add your answer
Q3. Validate an array based on a set of rules, with less time complexity.
Ans. 
Use regular expressions to validate array elements efficiently.
• Use regular expressions to define the rules for validation.

• Iterate through the array and apply the regular expression to each element.

• Return true if all elements pass the validation rules, false otherwise.
Answered by AI
Add your answer

The aptitude test included questions from mathematics from chapters such as P/L , %age, etc. and reasoning type questions. There were some grammar related, general knowledge related questions. The third was from computer basics as for my job excel and computer knowledge was required.

Q1. Typing test via software.
Add your answer
Q2. About my college project.
Add your answer
Q3. How would I manage my study and job?
Add your answer

Q1. Prepare a presentation on how you reached the office from you home and what happened till interacting with the HOD.
Ans. 
I took a bus to the office, stopped for coffee on the way, and had a brief chat with a colleague before meeting the HOD.
• Took a bus from home to the office

• Stopped for coffee at a nearby cafe

• Had a brief chat with a colleague in the office

• Interacted with the HOD in a scheduled meeting
Answered by AI
Add your answer
Q2. About yourself.
Add your answer

My previous experiences, roles, and responsibilities, as well as technical discussions.

Q1. Salary why not time being paid ?
Add your answer
Q2. Without any evidence how blaming staff ??
Ans. 
Blaming staff without evidence is unprofessional and can damage morale and trust within the team.
• Avoid jumping to conclusions without concrete evidence

• Encourage open communication and transparency

• Focus on problem-solving rather than assigning blame

• Provide constructive feedback and support to help staff improve

• Lead by example and take responsibility for mistakes
Answered by AI
Add your answer
Q3. Company always carried out theft staff ?
Add your answer
Q4. No one professional staff in office and overall company ??
Add your answer
Q5. Why directors board unseen to thefts??
Ans. 
Directors may not always be aware of thefts due to lack of oversight, trust in employees, or focus on other priorities.
• Directors may not be directly involved in day-to-day operations where thefts occur

• There may be a lack of proper oversight or monitoring mechanisms in place

• Directors may trust their employees and not suspect them of theft

• Directors may be focused on other strategic priorities and not pay attention to pot
Answered by AI
Add your answer

Q1. Dumb HR will ruin the company or maybe they behave how the company wants them to behave.
Add your answer

It consists of genral quantitative aptitude and launguage and about core subjects

It was general topics of today's world

Q1. Completely related to your job description and your core subjects
Add your answer

Purchase Assignment - Comparing PO's

Q1. What is the Basic Rule of Purchase
Add your answer
Q2. How mant quotations will you take before evaluating
Add your answer

Q1. Expectations From the company?
Add your answer
Q2. Expected Compensiation?
Add your answer

Supply chain management

Q1. What are the basic functions of the machines and it's important parts
Ans. 
Machines have various functions and important parts that work together to perform specific tasks efficiently.
• Basic functions include processing, moving, cutting, shaping, and assembling materials

• Important parts may include motors, gears, sensors, controllers, and actuators

• Examples: CNC machines process materials with precision, conveyor belts move items along a production line
Answered by AI
Add your answer

Q1. What are basic functions done on excel
Ans. 
Basic functions in Excel include data entry, formatting, calculations, and data analysis.
• Data entry: Entering text, numbers, and formulas into cells.

• Formatting: Changing font styles, colors, and cell alignment.

• Calculations: Using formulas for addition, subtraction, multiplication, and division.

• Data analysis: Sorting, filtering, and creating charts to analyze data.

• Functions: Using built-in functions like SUM, AVERAGE, a
Answered by AI
Add your answer
Q2. Implementation of those functions during the interview
Add your answer
Q3. How to make proper excel aheets
Ans. 
Proper Excel sheets can be made by organizing data, using formulas, formatting cells, and creating charts.
• Organize data into rows and columns for easy readability

• Use formulas to perform calculations and automate tasks

• Format cells for better presentation and to highlight important information

• Create charts to visualize data and trends
Answered by AI
Add your answer

Q1. About previous company
Add your answer
Q2. About years of experience
Add your answer
Q3. H.R asked about the previous salary and my contribution to the company
Add your answer

Q1. What I know about the companies products
Add your answer
Q2. What kind of technical issues occured in the field occured in the field during sales
Ans. 
Technical issues in the field during sales include network connectivity problems, software glitches, hardware malfunctions, and data security breaches.
• Network connectivity issues leading to inability to process transactions

• Software glitches causing delays in generating invoices or processing orders

• Hardware malfunctions such as POS system failures or printer issues

• Data security breaches resulting in loss of customer inf
Answered by AI
Add your answer