Corecard Software Interview Questions, Process, and Tips

Basic questions code snipet , string questions and sql mcq's

Q1. To get 2nd highest salary from database
Add your answer
Q2. Questions on DSA
Add your answer

Q1. SQL coding question
Add your answer
Q2. DSA algorithms on bubble and merge sort
Ans. 
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order. Merge sort is a divide and conquer algorithm that divides the input array into two halves, recursively sorts the two halves, and then merges the sorted halves.
• Bubble sort has a time complexity of O(n^2) in worst case scenario, while merge sort has a time complexity ...read more
Answered by AI
Add your answer

Q1. What is Like funcation
Ans. 
The Like function is used in SQL to search for a specified pattern in a column.
• Used in SQL to search for a specified pattern in a column

• Can use wildcards like % and _ for pattern matching

• Example: SELECT * FROM table WHERE column LIKE 'abc%'
Answered by AI
Add your answer
Q2. What is group by
Ans. 
Group by is a clause in SQL used to arrange identical data into groups based on one or more columns.
• Group by is used in conjunction with aggregate functions like COUNT, SUM, AVG, etc.

• It is commonly used to summarize data and perform calculations on grouped data.

• For example, SELECT department, COUNT(employee_id) FROM employees GROUP BY department;
Answered by AI
Add your answer

Q1. Did not remember
Add your answer
Q2. Did not display
Add your answer

Q1. Project work on
Add your answer
Q2. Having knowledge of jira
Add your answer

Q1. Location asking
Add your answer
Q2. How much Lpa explained
Add your answer

Q1. What is cloud technology
Ans. 
Cloud technology refers to the use of remote servers hosted on the internet to store, manage, and process data.
• Allows for on-demand access to a shared pool of resources

• Enables scalability and flexibility for businesses

• Examples include Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform
Answered by AI
Add your answer