Clayfin Technologies UI Developer Interview Questions and Answers

Q1. Difference between function and stored procedure.
Ans. 
Functions return a value while stored procedures do not. Functions can be used in SELECT statements, stored procedures cannot.
• Functions return a value, stored procedures do not

• Functions can be used in SELECT statements, stored procedures cannot

• Functions must return a value, stored procedures may or may not
Answered by AI
Add your answer
Q2. Write a query to find the manager of the employee.
Ans. 
Use a self join to find the manager of the employee.
• Join the employee table with itself on the manager_id and employee_id columns

• Select the manager's details based on the employee's manager_id
Answered by AI
Add your answer
Q3. To write a stored procedure.
Add your answer
Q4. What is trigger?
Ans. 
A trigger is a special type of stored procedure that automatically executes when certain events occur in a database.
• Triggers can be used to enforce business rules, perform data validation, or maintain referential integrity.

• Examples of trigger events include INSERT, UPDATE, and DELETE operations on a table.

• Triggers can be defined to execute before or after the triggering event.
Answered by AI
Add your answer
Q5. What do you know about JSON?
Add your answer

Q1. Projects worked on
Add your answer
Q2. Coding leetcode easy/medium questions
Add your answer

Q1. Tell me about yourself
Add your answer

25 Aptitude MCQ and 25 post based MCQ

Q1. They are asking Technical Questions
Add your answer

Q1. They are asking HR questions
Add your answer

DSA test...focussed on Array

Q1. React based questions
Add your answer
Q2. Javascript based question
Add your answer

Round duration - 60 Minutes
Round difficulty - Easy

The platform was HackerEarth time duration was 1 hour.
2 Coding questions were asked, 30 minutes for each were allotted.

Q1. 
Longest Substring Without Repeating Characters Problem Statement
Given a string S of length L, determine the length of the longest substring that contains no repeating characters.
Example:
Input:
"abac...read more
Ans. Brute Force
In the brute force approach, we will use two nested loops. The outer loop is used to select the starting index of the substring and the inner loop is used to fix the ending index of the substring. After selecting the substring, we will use another loop (or a method) to check whether the substring contains all unique characters or not using a HashSet.
Space Complexity: O(n)Explanation:
O(L), where L is the len...read more
Answered Anonymously
Add your answer
Q2. 
Triplets with Given Sum Problem
Given an array or list ARR consisting of N integers, your task is to identify all distinct triplets within the array that sum up to a specified number K.
Explanation:
A t...read more
Ans. Brute Force
• The most trivial approach would be to find all triplets of the array and count all such triplets whose ‘SUM’ = 'K'.
• We can find the answer using three nested loops for three different indexes and check if the values at those indexes sum up to 'K'.
• Create a set  to keep the track of triplets we have visited. Run first loop from i = 0 to i = ‘N’ - 3, second loop from j = i + 1 to j = ‘N’ - 2 and third loop ...read more
Answered Anonymously
Add your answer

Round duration - 120 Minutes
Round difficulty - Hard

This was a 2 hours round, with the following problem statement. At the end of the allotted time you had give a demo and explain your implementation.

Round duration - 45 Minutes
Round difficulty - Medium

The platform was Zoom, time duration was 45 mins. Started with Tell me something about yourself. I told them, that I like solving algorithms and real life problems.

Round duration - 20 Minutes
Round difficulty - Easy

Interviewer was very friendly. Asked few questions about myself and then asked questions about what I know about the company.

Q1. What are closures in javascript
Ans. 
Closures in JavaScript are functions that have access to variables from their outer scope even after the outer function has finished executing.
• Closures allow for maintaining state in an asynchronous environment

• They are created whenever a function is defined within another function

• Example: function outerFunction() { let outerVar = 'I am outer'; return function innerFunction() { console.log(outerVar); }; }
Answered by AI
Add your answer

Q1. Is NaN === NaN
Add your answer

Q1. How do you handle stressful situations?
Ans. 
I handle stressful situations by staying calm, prioritizing tasks, and seeking support when needed.
• I prioritize tasks to focus on what needs to be done first

• I take breaks to clear my mind and refocus

• I communicate with team members or supervisors for guidance and support

• I practice mindfulness techniques such as deep breathing or meditation
Answered by AI
Add your answer