CGI Group Production Support Software Engineer Interview Questions and Answers

Hydraulic systems and hydraulic machines.

Q1. What is the difference between BS4 and BS6 emissions standards?
Ans. 
BS6 emissions standards are more stringent than BS4, with lower limits on emissions of pollutants like nitrogen oxides and particulate matter.
• BS6 standards have stricter limits on emissions of pollutants like nitrogen oxides (NOx) and particulate matter (PM) compared to BS4.

• BS6 compliant vehicles are required to have advanced emission control technologies like selective catalytic reduction (SCR) and diesel particulate ...read more
Answered by AI
Add your answer
Q2. What is the difference between an electric motor and an electric generator?
Ans. 
An electric motor converts electrical energy into mechanical energy to produce motion, while an electric generator converts mechanical energy into electrical energy.
• Electric motor converts electrical energy into mechanical energy

• Electric generator converts mechanical energy into electrical energy

• Electric motor is used in appliances like fans, washing machines

• Electric generator is used in power plants to generate electr
Answered by AI
Add your answer
Q3. Difference between four stroke and two stroke engine
Ans. 
Four stroke engines have separate intake, compression, power, and exhaust strokes, while two stroke engines combine intake and compression in one stroke and power and exhaust in another.
• Four stroke engines have a dedicated stroke for each of the four processes: intake, compression, power, and exhaust

• Two stroke engines combine intake and compression in one stroke and power and exhaust in another

• Four stroke engines are m...read more
Answered by AI
Add your answer

Q1. Self introduction
Add your answer
Q2. Work experience
Add your answer
Q3. Which department are u working
Add your answer
Q4. Timings and salary
Add your answer

Q1. Name and experience and quality and checking etc
Add your answer
Q2. How can handle ur problem and team work
Add your answer
Q3. Times and salary
Add your answer

About current project and roles and resposibilities etc

Q1. SQL COMPLEX QUERIES and PL SQL, CRON JOBS, SERVICE NOW
Add your answer
Q2. What are difference between SQL and PL SQL
Ans. 
SQL is a standard language for managing relational databases, while PL/SQL is a procedural language extension for SQL.
• SQL is a standard language for querying and manipulating data in relational databases.

• PL/SQL is a procedural language extension for SQL, allowing for more complex programming logic.

• SQL is used for data manipulation and retrieval, while PL/SQL is used for writing stored procedures and functions.

• SQL state...read more
Answered by AI
Add your answer
Q3. Explain types of joins?
Ans. 
Types of joins are used in databases to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full Join...read more
Answered by AI
Add your answer
Q4. Diffence between correlated and non correlated subquary?
Ans. 
Correlated subquery refers to a subquery that is dependent on the outer query, while non-correlated subquery can be executed independently.
• Correlated subquery is executed for each row processed by the outer query, while non-correlated subquery is executed only once.

• Correlated subquery is slower in performance compared to non-correlated subquery.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT MAX(column2) FROM tab
Answered by AI
Add your answer
Q5. Find departement wise total sal?
Ans. 
To find department wise total salary, sum up the salaries of employees in each department.
• Group employees by department

• Calculate total salary for each department

• Display department wise total salary
Answered by AI
Add your answer

Q1. Exception handler
Add your answer
Q2. Threads in java
Ans. 
Threads in Java allow for concurrent execution of multiple tasks within a single program.
• Threads are instances of the java.lang.Thread class.

• They allow for parallel execution of code segments.

• Threads can be created by extending the Thread class or implementing the Runnable interface.

• Example: Thread t1 = new Thread(new MyRunnable()); t1.start();
Answered by AI
Add your answer

Easy logical questions

Q1. Easy general questions asked
Add your answer
Q2. General questions
Add your answer
Q3. Strength and weaknesses, about project
Add your answer

Yes

Q1. Why are joining NTT DATA?
Ans. 
NTT DATA is a leading global IT services provider with a strong focus on innovation and customer satisfaction.
• I am joining NTT DATA because of their reputation as a top IT services provider

• I am excited about the opportunity to work with a company that values innovation and customer satisfaction

• NTT DATA's commitment to diversity and inclusion aligns with my personal values

• I am impressed with NTT DATA's global presence a...read more
Answered by AI
Add your answer
Q2. What are strength and weakness?
Ans. 
Strengths are positive attributes that contribute to success, while weaknesses are areas that need improvement.
• Strengths: leadership skills, attention to detail, problem-solving abilities

• Weaknesses: public speaking, time management, delegation

• Examples: Strength - ability to motivate team members; Weakness - tendency to procrastinate
Answered by AI
View 1 more answer
Q3. What are production management?
Ans. 
Production management involves planning, organizing, directing, and controlling the production process to ensure efficient and effective operations.
• Planning and scheduling production activities

• Managing resources such as labor, materials, and equipment

• Ensuring quality control and meeting production targets

• Implementing and improving production processes

• Managing budgets and costs

• Coordinating with other departments such as...read more
Answered by AI
Add your answer

It will give the hole syallabus of aptitude and reasoning

Q1. About my self and family my goal
Add your answer
Q2. About my village and technology
Add your answer
Q3. About my future plan
Add your answer