Coriolis Technologies Interview Questions and Answers

Q1. What SQL query can be used to retrieve names with a length of 5 characters?
Ans. 
Use the SQL LENGTH function to filter names with exactly 5 characters from a database table.
• Use the SQL SELECT statement to retrieve data from a table.

• Utilize the LENGTH function to check the length of the name column.

• Example query: SELECT name FROM users WHERE LENGTH(name) = 5;
Answered by AI
Add your answer
Q2. Basic searching, sorting algorithms like insertion sort, bubble sort
Add your answer
Q3. Write python code to check palindromes
Ans. 
This code checks if a given string is a palindrome, meaning it reads the same forwards and backwards.
• A palindrome is a word, phrase, or sequence that reads the same backward as forward. Example: 'radar'.

• To check for palindromes, we can compare the string to its reverse.

• We can ignore spaces, punctuation, and capitalization for a more robust check.

• Example code: `def is_palindrome(s): return s == s[::-1]`.
Answered by AI
Add your answer
Q4. Can you explain a project you worked on?
Ans. 
I developed a mobile app to help users track their daily water intake and stay hydrated.
• Conducted user research to identify hydration habits and needs.

• Designed a user-friendly interface with intuitive navigation.

• Implemented features like reminders and progress tracking.

• Utilized feedback from beta testers to improve functionality.

• Collaborated with a team of developers to ensure smooth deployment.
Answered by AI
Add your answer
Q5. What is the difference between a deep copy and a shallow copy?
Ans. 
Deep copy creates a new object with copies of nested objects, while shallow copy copies references to nested objects.
• Shallow copy: Copies the object but not the nested objects. Example: Using `copy()` in Python.

• Deep copy: Creates a new object and recursively copies all nested objects. Example: Using `deepcopy()` in Python.

• Modifying a nested object in a shallow copy affects the original object.

• Modifying a nested object ...read more
Answered by AI
Add your answer
Q6. What are the different types of languages used in SQL?
Ans. 
SQL includes various language types for data manipulation, definition, control, and transaction management.
• Data Query Language (DQL): Used for querying data. Example: SELECT * FROM table_name;

• Data Definition Language (DDL): Used for defining database structures. Example: CREATE TABLE table_name (...);

• Data Manipulation Language (DML): Used for manipulating data. Example: INSERT INTO table_name VALUES (...);

• Data Control ...read more
Answered by AI
Add your answer
Q7. What is the difference between pass by reference and pass by value?
Ans. 
Pass by reference means passing the address of a variable, while pass by value means passing a copy of the variable's value.
• Pass by value creates a copy of the variable's value. Example: int a = 5; function(a); // a remains 5.

• Pass by reference passes the variable's address. Example: int a = 5; function(&a); // a can be modified inside the function.

• In pass by value, changes made to the parameter do not affect the or...read more
Answered by AI
Add your answer

Q1. Linux Admin, server level, bash script
Add your answer
Q2. Docker build, kubernetes
Add your answer

Online test with 35 questions Mcq and 8 tasks. These consists of linux, java, python,
Tasks are like
1) create a cronjobs and take back up on every 7 day of month and other 5-6 tasks on cronjobs concept
2) create a process id and killing a PID. Like 3-4 tasks on this concept
3) create a directories a-z one inside the other and each directory cosists of files a. Txt.. Till z. Txt
4) create a directories 1 -20 each should contain a. Txt to z. Txt
Even no. Directory should be 620 odd should be 741 permission like that
5) create a Git repo and pull the repo and
Add file and commit with message
6)
7)

Q1. Completely from your resume and Testing automation...
Add your answer
Q2. Testing automation and on-premise issues
Add your answer

Q1. What is LVM?? In servers
Ans. 
LVM stands for Logical Volume Manager and is a tool used for managing disk storage in Linux servers.
• LVM allows for dynamic resizing of logical volumes without downtime.

• It provides features like snapshots, striping, mirroring, and thin provisioning.

• LVM is commonly used in server environments to manage storage efficiently.

• Example: Creating a new logical volume, resizing an existing logical volume.
Answered by AI
Add your answer
Q2. If storage is full what to do on on- premises servers
Ans. 
When storage is full on on-premises servers, consider deleting unnecessary files, archiving old data, expanding storage capacity, or optimizing storage usage.
• Identify and delete unnecessary files or logs to free up space

• Archive old data that is not frequently accessed

• Expand storage capacity by adding more disks or upgrading existing ones

• Optimize storage usage by compressing files or moving them to a different location
Answered by AI
View 1 more answer
Q3. How to do partition in centos linux machine
Ans. 
To partition a CentOS Linux machine, you can use tools like fdisk or parted to create, delete, and manage partitions on the disk.
• Use fdisk command to create, delete, and manage partitions on the disk

• Use parted command for more advanced partitioning options

• Make sure to backup important data before partitioning
Answered by AI
View 1 more answer
Q4. How to check installed softwares in ubuntu machine
Ans. 
To check installed softwares in Ubuntu machine, you can use the dpkg command.
• Use dpkg -l to list all installed packages

• Use dpkg -l | grep to search for specific packages

• Use dpkg -l | less to view the list page by page
Answered by AI
View 1 more answer
Q5. How to keep static ip for onpremise server?
Ans. 
To keep a static IP for an on-premise server, configure the network settings on the server and the DHCP server.
• Assign a static IP address to the server within the network range

• Configure the DHCP server to reserve the static IP address for the server's MAC address

• Ensure that the server's network settings are set to use the static IP address

• Update DNS records if necessary to reflect the new static IP address
Answered by AI
Add your answer

Written round had 30+mcq which were based on core java, hibernate, sql and springboot. The level of mcq was medium hard, and 2coding questions were of medium level.

Q1. Basic core java and springboot interview with some output questions.
Add your answer

Q1. Technical interview with coding Be sure to read about multi threading and exeption handling in detail it will help you
Add your answer

Q1. Basic questions along with some technical questions and they check your understanding of previous projects you have worked on...
Add your answer