CGI Group Database Architect Interview Questions and Answers

I'm a passionate software engineer with a strong background in full-stack development and a love for solving complex problems.

• Graduated with a degree in Computer Science from XYZ University.

• Worked at ABC Corp, where I developed a web application that improved user engagement by 30%.

• Proficient in languages like JavaScript, Python, and Java, with experience in frameworks such as React and Django.

• Enjoy collaborating in ag...read more

Program to print unique elements in an array in Java

• Create a HashSet to store unique elements

• Iterate through the array and add each element to the HashSet

• Print the HashSet to get the unique elements

Data structures are ways of organizing and storing data in a computer so that it can be accessed and used efficiently.

• Arrays - a collection of elements of the same type

• Linked Lists - a sequence of nodes where each node contains a reference to the next node

• Stacks - a collection of elements with two main operations: push (add) and pop (remove)

• Queues - a collection of elements with two main operations: enqueue (add) and d...read more

OOPs stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects.

• OOPs focuses on creating objects that contain both data and functions.

• It emphasizes on encapsulation, inheritance, and polymorphism.

• Examples of OOPs languages are Java, C++, Python, etc.

OOPs is used for creating modular, reusable and maintainable code.

• Encapsulation: Hiding implementation details and exposing only necessary information.

• Inheritance: Reusing code and creating a hierarchy of classes.

• Polymorphism: Using a single interface to represent multiple entities.

• Abstraction: Reducing complexity by hiding unnecessary details.

• Examples: Java, C++, Python, Ruby, etc.

Inheritance is a mechanism in object-oriented programming where a new class is created by inheriting properties of an existing class.

• Inheritance allows code reuse and promotes code organization.

• The existing class is called the parent or superclass, and the new class is called the child or subclass.

• The child class inherits all the properties and methods of the parent class and can also add its own unique properties and ...read more

Polymorphism is the ability of an object to take on many forms.

• It allows objects of different classes to be treated as if they were objects of the same class.

• It is achieved through method overriding and method overloading.

• Example: A parent class Animal can have child classes like Dog, Cat, and Bird, each with their own unique implementation of the method 'makeSound'.

• Polymorphism makes code more flexible and reusable.

Abstraction is the process of hiding complex implementation details and exposing only the necessary information.

• Abstraction helps in reducing complexity and increasing efficiency.

• It allows us to focus on the essential features of an object or system.

• For example, a car can be abstracted as a vehicle with certain properties like speed, fuel efficiency, and seating capacity.

• Abstraction can be achieved through interfaces, ...read more

Encapsulation is the process of hiding implementation details and providing a public interface for accessing the functionality.

• Encapsulation helps in achieving data abstraction and information hiding

• It prevents unauthorized access to the internal details of an object

• It allows for easy modification of implementation without affecting the external code

• Example: A class with private variables and public methods

• Example: A b...read more

Asked to implement quicksort and explain time complexity, OSI model, process synchronization, paging, and threads.

• Implement quicksort algorithm

• Explain time complexity of quicksort

• Describe OSI model and its layers

• Discuss process synchronization techniques

• Explain paging and its role in memory management

• Discuss threads and their use in concurrent programming