CGI Group Application Support Engineer Interview Questions and Answers

Reverse string
java
linux

Round duration - 40 Minutes
Round difficulty - Medium

In this round , I was grilled on some fundamental concepts of Linux. The interviewer was however quite friendly and helped me whenever I was stuck on a problem.

Q1. What is LVM and why is it required?
Ans. 
LVM stands for Logical Volume Manager, used to manage disk space efficiently by allowing for dynamic resizing of volumes.
• LVM allows for easy resizing of volumes without needing to unmount the filesystem

• It provides features like striping, mirroring, and snapshots for data management

• LVM is required for efficient storage management in enterprise environments
Answered by AI
Add your answer
Q2. What is the '/proc' file system in Linux?
Ans. 
The '/proc' file system in Linux is a virtual file system that provides detailed information about the system's hardware, processes, and kernel.
• It is a virtual file system that exists only in memory and does not correspond to any physical disk storage.

• It provides real-time information about various system resources such as CPU, memory, processes, and devices.

• Users can access and manipulate system information by reading...read more
Answered by AI
Add your answer
Q3. How do you check how much space is left in the current drive?
Ans. 
To check how much space is left in the current drive, you can use the 'df' command in the terminal.
• Use the 'df' command followed by the '-h' flag to display the disk space in a human-readable format.

• Look for the 'Available' column to see how much space is left on the current drive.

• Example: 'df -h' will show you the disk space usage on all mounted filesystems.
Answered by AI
Add your answer
Q4. Write a command to print the lines that contain the word 'july', while ignoring the case.
Ans. 
Use grep command with -i flag to print lines containing 'july' ignoring case.
• Use the following command: grep -i 'july' file.txt

• Replace 'file.txt' with the actual file name if applicable

• The -i flag makes the search case-insensitive
Answered by AI
Add your answer
Q5. What does it mean when a file has 644 permissions in Linux?
Ans. 
File with 644 permissions in Linux means read and write access for owner, and read-only access for group and others.
• Owner can read and write the file

• Group and others can only read the file

• Permissions are represented as three sets of three bits (rwx)
Answered by AI
Add your answer
Q6. How do you find all the processes that have opened a file in Linux?
Ans. 
To find all processes that have opened a file in Linux, you can use the lsof command.
• Use the lsof command followed by the file path to see which processes have opened the file.

• You can also use the -t option with lsof to only display the process IDs.

• To find all processes that have opened any file in a specific directory, use lsof +D /path/to/directory.
Answered by AI
Add your answer
Q7. Can you enlist the basic components of Linux?
Ans. 
Basic components of Linux include kernel, shell, commands, utilities, and file system.
• Kernel - core component that manages hardware resources

• Shell - interface for users to interact with the system

• Commands - instructions given to the system for specific tasks

• Utilities - additional tools for system management

• File system - structure for organizing and storing data
Answered by AI
Add your answer
Q8. What are some important Crontab commands used in Linux?
Ans. 
Crontab commands are used in Linux for scheduling tasks at specific times.
• crontab -e: Edit the crontab file

• crontab -l: List the current crontab entries

• crontab -r: Remove the current crontab file

• crontab -u username: Specify the username whose crontab is to be modified

• */5 * * * * command: Run 'command' every 5 minutes
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

This round had questions mainly from Operating System and DBMS. I was also asked some basic SQL queries to execute on my machine.

Q1. What is a pipe in operating systems, and when is it used?
Ans. 
A pipe in operating systems is a form of inter-process communication that allows the output of one process to be used as the input of another process.
• A pipe is a method for passing data between processes in a unidirectional manner.

• It is typically used when the output of one process needs to be input into another process.

• Pipes are created using the pipe() system call in Unix-like operating systems.

• An example of using a ...read more
Answered by AI
Add your answer
Q2. Can you explain any 5 essential UNIX commands?
Ans. 
Five essential UNIX commands are ls, cd, pwd, mkdir, and rm.
• ls - list directory contents

• cd - change directory

• pwd - print working directory

• mkdir - make directory

• rm - remove files or directories
Answered by AI
Add your answer
Q3. How do you find the second highest salary from a table in SQL?
Ans. 
Use a subquery to find the second highest salary from a table in SQL.
• Use a subquery to select the maximum salary from the table.

• Then use another subquery to select the maximum salary that is less than the maximum salary found in the first subquery.
Answered by AI
Add your answer
Q4. What is meant by normalization and denormalization?
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. Denormalization is the opposite process.
• Normalization involves breaking down data into smaller, more manageable tables to reduce redundancy and dependency.

• Denormalization involves combining tables to improve query performance by reducing the number of joins needed.

• Normalization helps maintain data integrity by...read more
Answered by AI
Add your answer
Q5. How do you take a backup of a table in MySQL?
Ans. 
To take a backup of a table in MySQL, you can use the mysqldump command.
• Use the mysqldump command followed by the database name and table name to backup a specific table.

• Specify the username and password for the MySQL database when using mysqldump.

• You can also backup multiple tables or the entire database using mysqldump.

• Save the backup file in a secure location for future restoration if needed.
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

This is a cultural fitment testing round .HR was very frank and asked standard questions. Then we discussed about my role.

Q1. Why are you looking for a job change?
Ans. 
I'm seeking new challenges and opportunities for growth that align with my career goals and skills in application support.
• Desire for professional growth: I'm looking to expand my skill set and take on more responsibilities.

• Seeking a dynamic work environment: My current role has become stagnant, and I thrive in fast-paced settings.

• Alignment with career goals: I want to work for a company whose values and mission resonat...read more
Answered by AI
Add your answer
Q2. What is something about you that is not included in your resume?
Add your answer