CGI Group Interview Questions, Process, and Tips

Basically communication and sql 12 question and progaming mcq 12q and 2 coding question

Q1. Tell me about your self
Add your answer
Q2. Project explanition
Add your answer
Q3. What is inheritance
Ans. 
Inheritance is a concept in object-oriented programming where a class inherits attributes and methods from another class.
• Allows a class to inherit properties and behaviors from another class

• Promotes code reusability and reduces redundancy

• Derived class can add its own unique attributes and methods

• Example: Class 'Car' can inherit from class 'Vehicle' and gain attributes like 'color' and methods like 'drive'
Answered by AI
Add your answer
Q4. Code in inheritance
Ans. 
Inheritance in object-oriented programming allows a class to inherit properties and behaviors from another class.
• Inheritance allows for code reusability and promotes a hierarchical structure in classes.

• Subclasses can access and modify the properties and methods of their parent class.

• Example: class Animal { ... } class Dog extends Animal { ... }

• Example: class Shape { ... } class Circle extends Shape { ... }
Answered by AI
Add your answer
Q5. Code reverse a string
Ans. 
Reverse a string using array manipulation
• Create an array of characters from the input string

• Iterate through the array in reverse order and append each character to a new string

• Return the reversed string
Answered by AI
Add your answer
Q6. Sql query for seleting a particular column from a table and give the employer count
Ans. 
Use SQL query to select a particular column from a table and get the count of entries.
• Use SELECT statement to specify the column you want to retrieve.

• Use COUNT() function to get the count of entries in that column.

• Combine both in a single query to achieve the desired result.
Answered by AI
Add your answer
Q7. Apptitute question a sales man sells a item for 20% discount from its original price for some time and he want to sell the remaing item for original price what he needs to do??
Add your answer
Q8. A clock tick 8 times on 8'o clock the time taken between 1st tick and last tick is 35 sec what is the time taken for starting tick and end tick at 11'o colck
Ans. 
The time taken for the clock to tick from 8'o clock to 11'o clock is 105 seconds.
• Each tick represents 1/8th of an hour (45 minutes) on the clock.

• From 8'o clock to 11'o clock, there are 3 hours, so the total time taken is 3 * 45 = 135 minutes = 135 * 60 = 8100 seconds.

• The time taken for the clock to tick from 8'o clock to 11'o clock is 8100 - 35 = 8065 seconds.
Answered by AI
Add your answer

Average to easy difficulty level.

Q1. Java code of string manipulation
Ans. 
String manipulation in Java involves various methods like substring, concat, replace, etc.
• Use substring() to extract a part of the string

• Use concat() to concatenate two strings

• Use replace() to replace a specific character or substring in a string
Answered by AI
Add your answer
Q2. What is the Java code for various types of sorting algorithms?
Ans. 
Various sorting algorithms in Java code
• Bubble Sort: int[] arr = {5, 2, 8, 1, 3}; Arrays.sort(arr);

• Selection Sort: int[] arr = {5, 2, 8, 1, 3}; Arrays.sort(arr);

• Insertion Sort: int[] arr = {5, 2, 8, 1, 3}; Arrays.sort(arr);

• Merge Sort: int[] arr = {5, 2, 8, 1, 3}; Arrays.sort(arr);

• Quick Sort: int[] arr = {5, 2, 8, 1, 3}; Arrays.sort(arr);
Answered by AI
Add your answer
Q3. Sql query and topics related to joins.
Add your answer

Q1. About yourself and family
Add your answer
Q2. What do you know about the company?
Ans. 
The company is a leading software development firm specializing in creating innovative solutions for various industries.
• Specializes in creating innovative software solutions

• Works with clients from various industries

• Known for high-quality and reliable products

• Has a strong team of software engineers and developers
Answered by AI
Add your answer
Q3. Can you provide examples of real-life scenarios where you handled conflicts with either a colleague or a manager?
Ans. 
Handled conflicts by addressing issues directly, seeking compromise, and maintaining professionalism.
• Addressed a disagreement with a colleague by scheduling a one-on-one meeting to discuss concerns and find common ground.

• Resolved a conflict with a manager by actively listening to their perspective, providing feedback, and working together to find a solution.

• Maintained professionalism during conflicts by staying calm, r...read more
Answered by AI
Add your answer
Q4. What actions would you take if your manager does not approve your product idea, and how would you attempt to persuade them?
Ans. 
I would gather more data to support my idea, present a compelling case to my manager, and be open to feedback and compromise.
• Gather data to support the idea, such as market research, user feedback, or cost-benefit analysis.

• Prepare a well-structured presentation highlighting the potential benefits of the product idea.

• Listen to the manager's concerns and feedback, and be open to making adjustments or compromises.

• Seek sup...read more
Answered by AI
Add your answer

Q1. What changes should be made to both the backend and frontend when a new field is added in order to ensure that data flows from the backend to the user interface (UI) in the Model-View-Controller (MVC) arch...read more
Ans. 
Adding a new field in MVC requires updates in the backend and frontend for seamless data flow.
• 1. Update the Model: Add the new field to the data model class (e.g., 'public string NewField { get; set; }' in C#).

• 2. Update the Database: Modify the database schema to include the new field (e.g., using a migration in Entity Framework).

• 3. Update the Controller: Ensure the controller retrieves and sends the new field data to ...read more
Answered by AI
Add your answer
Q2. Could you describe the types of SQL query questions you were asked during the interview, including scenarios involving join operations with two tables and the expected outputs, as well as your experience w...read more
Add your answer
Q3. There are two technical rounds 1st round is around 45 mins and second round is face to face that is too technical around one and half an hour. Third round also happened at a day with manager
Add your answer

Q1. Parameter and argument difference in JavaScript ? 2. Closures and hoisting in Javascript ? 3. Var, let and Const difference ?
Ans. 
Understanding JavaScript concepts like parameters, closures, and variable declarations is crucial for effective coding.
• Parameters are variables listed as part of a function's definition, while arguments are the actual values passed to the function.

• Example: function add(a, b) { return a + b; } - 'a' and 'b' are parameters; add(2, 3) - '2' and '3' are arguments.

• Closures are functions that remember their lexical scope eve...read more
Answered by AI
Add your answer
Q2. Should create a simple form with name, email, mobile and if we click the submit button the added details has to show on the below table
Add your answer