Celebal Technologies Interview Questions, Process, and Tips

EASY AND SIMPLE NOT TO WORRY

Q1. WHAT IS INDEX IN SQL
Ans. 
Index in SQL is a data structure that improves the speed of data retrieval operations on a database table.
• Indexes are created on columns in a database table to quickly retrieve data based on the values in those columns.

• They can be unique or non-unique, clustered or non-clustered.

• Indexes can significantly improve the performance of SELECT queries but may slow down INSERT, UPDATE, and DELETE operations.

• Examples: CREATE I...read more
Answered by AI
Add your answer

Very hard test with dynamic programming questions almost 6 questions to do in 90 minutes along with MCQs

Q1. It was a long interview based on oops DSA machine learning
Add your answer

Q1. There was another technical interview I don't know why but there was another interview the as the same level questions
Add your answer

Q1. Then they finally selected and then ask about the location and other miscellaneous information
Add your answer

Q1. What are the different types of loans?
Ans. 
Different types of loans include personal loans, home loans, auto loans, student loans, and business loans.
• Personal loans

• Home loans

• Auto loans

• Student loans

• Business loans
Answered by AI
Add your answer
Q2. Difference between Secured and Unsecured loans?
Ans. 
Secured loans are backed by collateral, while unsecured loans are not.
• Secured loans require collateral to secure the loan, such as a house or car

• Unsecured loans do not require collateral, but typically have higher interest rates

• Secured loans are less risky for lenders, as they have a way to recover their money if the borrower defaults

• Examples of secured loans include mortgages and auto loans, while credit cards and per
Answered by AI
Add your answer
Q3. Difference in Credit underwriting procedures for Retail and Agri Loans?
Ans. 
Credit underwriting procedures differ in Retail and Agri Loans due to varying risk factors and collateral requirements.
• Retail loans typically involve individual borrowers with stable income and credit history, while Agri loans involve farmers with fluctuating income and collateral in the form of agricultural assets.

• Retail loans may require credit score checks and income verification, while Agri loans may focus more on ...read more
Answered by AI
Add your answer
Q4. Do you have knowledge of Cloud service, SQL etc?
Ans. 
Yes, I have knowledge of Cloud services such as AWS, Azure, and Google Cloud, as well as SQL databases.
• Familiar with Cloud services like AWS, Azure, and Google Cloud

• Proficient in SQL databases

• Experience in setting up and managing databases in the Cloud
Answered by AI
Add your answer

Q1. Calculate repeating element in list
Ans. 
Find the repeating element in a list
• Iterate through the list and keep track of elements seen so far

• Use a hash set to efficiently check for duplicates

• Return the first element that is already in the set
Answered by AI
Add your answer
Q2. Calculate maximum salary in SQL
Ans. 
Use the MAX() function in SQL to calculate the maximum salary.
• Use the MAX() function along with the column name of the salary field.

• Example: SELECT MAX(salary) FROM employees;

• Ensure the correct table and column names are used in the query.
Answered by AI
Add your answer