Johnson Electric 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

Q1. Why you want select this job
Ans. 
I am eager to contribute my skills and learn in a dynamic environment, aligning my career goals with the company's mission.
• I am passionate about the industry and excited to work with a team that shares my values.

• This role offers the opportunity to develop my skills in a practical setting, which is essential for my career growth.

• I admire the company's commitment to innovation and quality, and I want to be part of that j...read more
Answered by AI
View 1 more answer
Q2. Tell the job experience
Ans. 
I have gained valuable experience through internships and projects, enhancing my skills in teamwork and problem-solving.
• Interned at XYZ Company, where I assisted in project management and learned about client communication.

• Participated in a team project that improved our workflow efficiency by 20%.

• Volunteered at a local charity, organizing events that raised funds and awareness for community issues.
Answered by AI
View 1 more answer
Q3. You like this job
Add your answer
Q4. You job checking method step and benifits Tell About
Ans. 
Job checking methods ensure accuracy and efficiency in tasks, enhancing overall productivity and quality of work.
• 1. Define clear objectives: Establish what needs to be checked and the expected outcomes. For example, in software testing, define test cases.

• 2. Use checklists: Create a checklist to ensure all steps are followed. For instance, a quality control checklist in manufacturing.

• 3. Regular audits: Conduct periodic ...read more
Answered by AI
View 1 more answer
Q5. You find any kaizen tell
Ans. 
Kaizen is a continuous improvement philosophy that enhances efficiency and quality in processes.
• Kaizen encourages small, incremental changes rather than large-scale transformations.

• Example: A manufacturing team implements a daily 5-minute meeting to discuss process improvements.

• It involves all employees, from management to frontline workers, fostering a culture of collaboration.

• Example: A hospital staff suggests reorga...read more
Answered by AI
Add your answer

Sql query problems and machine learning algorithm drill down. resume review

Q1. What is the implementation of a circular queue using structures in C and classes in C++?
Ans. 
Implementing a circular queue using structures in C and classes in C++ for efficient data management.
• A circular queue uses a fixed-size array and wraps around when the end is reached.

• In C, define a structure with front, rear, and size attributes.

• In C++, use a class to encapsulate queue operations and maintain data integrity.

• Both implementations should include functions for enqueue, dequeue, and checking if the queue is...read more
Answered by AI
Add your answer
Q2. Sort a vector of strings alphabetically
Ans. 
Sort a vector of strings alphabetically using standard sorting algorithms.
• Use built-in sorting functions like std::sort in C++ or Collections.sort in Java.

• Example in Python: sorted(['banana', 'apple', 'cherry']) returns ['apple', 'banana', 'cherry'].

• Consider case sensitivity; 'Apple' and 'apple' may be treated differently.

• For custom sorting, provide a key function to define sorting criteria.
Answered by AI
Add your answer