Excellon Software Associate Functional Consultant Interview Questions and Answers

Aptitude test

Current affairs

Q1. Puzzle , sql related questions
Add your answer

Q1. What is Optional chaining ?
Ans. 
Optional chaining allows safe access to deeply nested object properties without causing runtime errors if a property is undefined or null.
• Prevents runtime errors when accessing properties of an object that may not exist.

• Syntax: Use the '?' operator before accessing a property, e.g., obj?.property.

• Example: const name = user?.profile?.name; // returns undefined if user or profile is null.

• Can be used with function calls: ...read more
Answered by AI
Add your answer
Q2. What is Debouncing?
Add your answer

Q1. React js, ReactHooks, es67 features, bootstrap
Add your answer

60mintues DSA level coding exam

Round duration - 60 minutes
Round difficulty - Medium

The round had quantitative questions along with some logical reasoning and english section and fundamentals of DBMS ,OS and Data structures and some other such topics

Q1. Can you explain the various disk scheduling algorithms used in operating systems?
Ans. 
Disk scheduling algorithms manage the order in which read/write requests are serviced on a disk.
• Common disk scheduling algorithms include FCFS, SSTF, SCAN, C-SCAN, LOOK, and C-LOOK.

• FCFS (First-Come, First-Served) serves requests in the order they arrive.

• SSTF (Shortest Seek Time First) prioritizes the request closest to the current head position.

• SCAN moves the disk arm from one end to the other, serving requests along t...read more
Answered by AI
View 1 more answer

Round duration - 90 minutes
Round difficulty - Medium

The editor and the environment was great and not disturbing like many have.
They had their own test cases to check the scope of our code.

Q1. 
Maximum Subarray Sum Problem Statement
Given an array of numbers, the task is to find the maximum sum of any contiguous subarray of the array.
Input:
The first line of input contains the size of the arr...read more
Ans. 
Find the maximum sum of any contiguous subarray in an array of numbers in O(N) time.
• Use Kadane's algorithm to find the maximum subarray sum in O(N) time.

• Initialize two variables: maxEndingHere and maxSoFar to keep track of the maximum sum.

• Iterate through the array and update the variables accordingly.

• Return the maxSoFar as the result.
Answered by AI
Add your answer

Round duration - 40 minutes
Round difficulty - Medium

It had only mcq questions but we could not navigate through the questions it had some reasoning and some dbms topics along with data structure ,memory ,cache memory and other topics

Q1. How do you find the age of an employee from the personal details table in SQL?
Ans. 
To find the age of an employee from the personal details table in SQL, you can calculate the difference between the current date and the employee's birthdate.
• Use the DATEDIFF function in SQL to calculate the difference between the current date and the employee's birthdate.

• Divide the result by 365 to get the age in years.

• Consider leap years for more accurate results.
Answered by AI
Add your answer

Round duration - 10 minutes
Round difficulty - Medium

The interviewer was polite and asked few questions from data structures and some from DBMS and some web question and about my project.

Q1. What is the difference between a primary key and a candidate key in a database management system?
Ans. 
Primary key uniquely identifies a record in a table, while candidate key can also uniquely identify a record but is not chosen as primary key.
• Primary key is chosen as the main unique identifier for a table

• Candidate key is a unique key that could also be chosen as primary key

• A table can have multiple candidate keys but only one primary key

• Example: In a table of students, 'student_id' could be a primary key while 'email'...read more
Answered by AI
Add your answer

Round duration - 12 minutes
Round difficulty - Medium

The interviewer asked me about my project and told me to describe myself in one word and justify that and asked my personal skills and asked some technical questions as well

Q1. What is pickling?
Ans. 
Pickling is a process of preserving or extending the shelf life of food by storing it in a solution of salt, vinegar, or brine.
• Pickling involves submerging food in a solution of salt, vinegar, or brine to preserve it.

• Common examples of pickled foods include cucumbers (pickles), onions, and cabbage.

• Pickling can also enhance the flavor of food by infusing it with spices and herbs.

• The acidity of the pickling solution help...read more
Answered by AI
Add your answer

2 questions of DSA medium to hard