Yodlee Interview Questions and Answers

To get roll numbers of same subjects, filter the data by subject and extract roll numbers.

• Filter the data by subject using a loop or filter function

• Extract roll numbers of filtered data using map or forEach function

• Store the roll numbers in an array of strings

To get the average of marks in Excel, use the AVERAGE function.

• Select the range of cells containing the marks

• Type =AVERAGE(

• Select the range of cells again

• Close the parentheses and press Enter

• The average of the marks will be displayed

Basic SQL queries involve using commands like SELECT, JOIN, and WHERE to retrieve and manipulate data from databases.

• SELECT statement: Used to select data from a database. Example: SELECT * FROM employees;

• WHERE clause: Filters records based on specified conditions. Example: SELECT * FROM employees WHERE age > 30;

• JOIN operation: Combines rows from two or more tables based on a related column. Example: SELECT emp...read more

Yes, I am proficient in Excel and Excel macros.

• I have extensive experience in using Excel for data analysis and manipulation.

• I am skilled in creating and modifying Excel macros to automate repetitive tasks.

• I am familiar with advanced Excel functions such as VLOOKUP, PivotTables, and conditional formatting.

• I have used Excel to create charts and graphs to visualize data.

• I am comfortable working with large datasets i...read more

OOP concepts like abstraction, encapsulation, inheritance, and polymorphism are fundamental to software design and implementation.

• Abstraction: Hides complex implementation details, exposing only necessary features. Example: Abstract classes in Java.

• Encapsulation: Bundles data and methods that operate on the data within a single unit (class). Example: Private variables in a class.

• Inheritance: Allows a new class to ...read more

Error is a serious issue that cannot be handled at runtime, while Exception is a recoverable issue that can be caught and handled.

• Error is a subclass of Throwable and is usually caused by the environment or system, such as running out of memory or stack overflow.

• Exception is also a subclass of Throwable but is caused by the application code, such as invalid input or file not found.

• Errors are unchecked and are not ...read more