CGI Group Production Support Software Engineer Interview Questions and Answers

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

Q1. What is your interested subject
Add your answer
Q2. Explain binary conversions
Ans. 
Binary conversions involve converting numbers from base 10 to base 2 and vice versa.
• Binary is a numbering system that uses only 0s and 1s.

• To convert from base 10 to base 2, divide the number by 2 and write down the remainder.

• To convert from base 2 to base 10, multiply each digit by its place value and add the results.

• Binary is commonly used in computer programming and digital electronics.
Answered by AI
Add your answer
Q3. What is STLD full form
Ans. 
STLD stands for Sequentially Timed Logic Diagram.
• STLD is a graphical representation of digital circuits.

• It shows the timing relationship between inputs and outputs.

• It is used in the design and analysis of digital circuits.

• STLD is commonly used in the field of electronics and computer engineering.
Answered by AI
Add your answer
Q4. Enother intrested subject
Add your answer
Q5. Optical communication
Ans. 
Optical communication involves transmitting information using light waves.
• Optical communication is faster and more secure than traditional copper wire communication.

• Fiber optic cables are used to transmit light signals over long distances.

• Examples of optical communication include internet and cable TV.

• Optical communication is also used in medical equipment such as endoscopes and laser surgery tools.
Answered by AI
Add your answer
Q6. About your self introduction
Add your answer
Q7. U know any languages
Ans. 
Yes, I am fluent in English and Spanish.
• Fluent in English and Spanish

• Able to communicate effectively with a diverse team

• Experience working in bilingual environments

• Proficient in technical vocabulary in both languages
Answered by AI
Add your answer

Q1. What is ECE Full form
Ans. 
ECE stands for Electronics and Communication Engineering.
• ECE is a branch of engineering that deals with the study of electronic devices and communication systems.

• It involves the design, development, and testing of electronic equipment and communication systems.

• Examples of ECE devices include smartphones, computers, televisions, radios, and satellites.

• ECE engineers work in various industries such as telecommunications, ...read more
Answered by AI
Add your answer
Q2. What is k maps explain
Ans. 
Karnaugh maps (K-maps) are a graphical method of simplifying Boolean algebra expressions.
• K-maps are used to simplify Boolean expressions with multiple variables.

• They are a visual aid that helps identify groups of adjacent 1's or 0's.

• The groups can then be combined to create a simplified expression.

• K-maps are commonly used in digital logic design and circuit analysis.

• Example: A 2-variable K-map can simplify the expressi...read more
Answered by AI
Add your answer
Q3. Why using optical communication
Ans. 
Optical communication offers high bandwidth, low interference, and secure data transmission.
• Optical communication uses light waves to transmit data, allowing for higher bandwidth and faster data transfer rates.

• It is less susceptible to interference from electromagnetic radiation and can transmit data over longer distances without degradation.

• Optical communication is also more secure than traditional copper wire communi...read more
Answered by AI
Add your answer
Q4. Purpose of optical communication
Ans. 
Optical communication is the use of light to transmit information through optical fibers.
• Optical communication is faster and more efficient than traditional copper wire communication.

• It is used in telecommunications, internet, and cable television networks.

• Optical communication is also used in medical equipment such as endoscopes and laser surgery tools.

• It allows for long-distance communication without signal degradati...read more
Answered by AI
Add your answer
Q5. Types of optical outputs
Ans. 
Optical outputs include digital optical, analog optical, and fiber optic.
• Digital optical outputs use a digital signal to transmit audio data.

• Analog optical outputs use an analog signal to transmit audio data.

• Fiber optic outputs use a fiber optic cable to transmit audio data.

• Examples of devices with optical outputs include DVD players, soundbars, and gaming consoles.
Answered by AI
Add your answer
Q6. U r perfect or in perfect in thi job
Add your answer
Q7. Yes I am hundred perfect
Add your answer
Q8. About your experience
Add your answer
Q9. Explain you r background
Add your answer
Q10. You are expecting sarary
Add your answer
Q11. Work from home or in office
Add your answer
Q12. Are you like thi job
Add your answer

Which life is best school or college

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

Q1. Accounts Receivables. Flow
Add your answer
Q2. Hikbbhuu huijehbe iorjenfe
Add your answer