Exlvis Solution Interview Questions and Answers

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

Q1. HTML, CSS fundamentals
Add your answer
Q2. Javascript event loop and array methods
Add your answer
Q3. Javascript coding for operation on object array
Ans. 
Performing operations on an array of objects using JavaScript.
• Use array methods like map, filter, reduce for operations on object array.

• Access object properties using dot notation or bracket notation.

• Iterate through the array using loops like for loop or forEach method.

• Example: Calculate total sum of 'price' property in an array of products.
Answered by AI
Add your answer
Q4. React benefits and Redux implementations
Add your answer
Q5. How to create slice and combine reducers
Ans. 
To create slice and combine reducers in React, use the createSlice and combineReducers functions from Redux toolkit.
• Use createSlice function to define a slice of state with reducers and actions.

• Example: const counterSlice = createSlice({ name: 'counter', initialState: 0, reducers: { increment: state => state + 1, decrement: state => state - 1 } })

• Use combineReducers function to combine multiple slices into a sing...read more
Answered by AI
Add your answer

Q1. Questions based on projects, role, responsibilities and initiative at work place
Add your answer
Q2. How to create and optimize a react application
Ans. 
To create and optimize a React application, focus on efficient component structure, state management, code splitting, lazy loading, and performance monitoring.
• Use functional components and hooks for better performance.

• Implement state management with tools like Redux or Context API.

• Split code into smaller chunks and lazy load components for faster initial load times.

• Optimize performance by minimizing re-renders and usin...read more
Answered by AI
Add your answer

Q1. Day to day activity of workplace and salary negotiation
Ans. 
Day to day activities involve coding, debugging, testing, collaborating with team members. Salary negotiation involves research, preparation, and effective communication.
• Coding and developing new features

• Debugging and fixing issues

• Testing code for quality assurance

• Collaborating with team members for project progress

• Researching market rates for salary negotiation

• Preparing a strong case for desired salary

• Effectively comm
Answered by AI
Add your answer

Q1. Basic ReactJs ,NodeJs questions with typescript
Add your answer
Q2. Prepare for javascript problems on , string , array , recursion, this.fn
Add your answer

Q1. Asked on Node.js event loop , libuv , AWS , Ci-Cid , authentication, middleware , design and problem solving questions
Add your answer
Q2. Recursion, array methods problem solving Js questions , es6 , array methods
Add your answer

Q1. Details about you and your family,. Location
Add your answer
Q2. Salary expectations
Add your answer

Q1. What are the different types of interfaces?
Ans. 
Different types of interfaces include user interfaces, hardware interfaces, and software interfaces.
• User interfaces: allow users to interact with the system, such as graphical user interfaces (GUI) and command-line interfaces (CLI)

• Hardware interfaces: connect hardware components to the system, such as USB, HDMI, and Ethernet ports

• Software interfaces: define how software components interact with each other, such as appl...read more
Answered by AI
Add your answer
Q2. What is the output of the program when the expression is evaluated as 0 divided by 7?
Ans. 
The output of the program when 0 is divided by 7 is 0.
• Division of 0 by any number results in 0.

• In programming languages, dividing by 0 usually results in an error or undefined behavior.
Answered by AI
Add your answer
Q3. What are coroutines, scope functions, and visibility modifiers?
Ans. 
Coroutines, scope functions, and visibility modifiers are key concepts in Kotlin programming for Android development.
• Coroutines are a way to perform asynchronous programming in a sequential manner. They allow for non-blocking operations.

• Scope functions are functions that allow you to execute a block of code within the context of an object. Examples include 'let', 'apply', 'run', 'also', and 'with'.

• Visibility modifiers ...read more
Answered by AI
Add your answer

Q1. What is the MVVM (Model-View-ViewModel) architectural pattern?
Ans. 
MVVM is an architectural pattern that separates the user interface from the business logic and data handling in Android development.
• Model represents the data and business logic of the application.

• View is responsible for displaying the UI elements and sending user interactions to the ViewModel.

• ViewModel acts as a mediator between the Model and the View, handling the communication and data flow.

• MVVM helps in achieving se...read more
Answered by AI
Add your answer
Q2. What are the reasons for using that, and what are its pros and cons?
Ans. 
Using dependency injection in Android development can improve code maintainability and testability.
• Pros: easier to manage dependencies, promotes code reusability, facilitates unit testing

• Cons: initial setup can be complex, may introduce overhead in smaller projects

• Example: Using Dagger 2 for dependency injection in an Android project
Answered by AI
Add your answer
Q3. Questions related Dependency injection dagger-hilt / koin
Add your answer

Q1. Myself and experience in english
Add your answer
Q2. Selected for the peocess
Add your answer
Q3. Last drawn salary why you are not another process
Add your answer
Q4. Why you left last job
Add your answer
Q5. Rate ur english 1 to 10 numbers
Add your answer
Q6. Introduce yourself as a employee
Add your answer
Q7. Season topic talk for two minutes
Add your answer
Q8. How is good english
Add your answer
Q9. Your favourite place on this topic
Add your answer

Q1. It was technical questions in relevant area
Add your answer
Q2. The questions relevant to my skill set and experience
Add your answer

Q1. The questions relevant to my skills and experience
Add your answer
Q2. The questions relevant to job requirements
Add your answer

Q1. General discussion about the profession and career
Add your answer
Q2. Discussed job location and client
Add your answer

Q1. Discussed about client and company
Add your answer
Q2. Orientation related things discussed.
Add your answer

Assessment via link MCQ

Q1. Microservices theory, Kafka
Add your answer
Q2. Singoloton design pattern, concurrent package, core java, collection questions, Java 8 related problem solving stream api questions
Add your answer

Q1. Same like round 1, little bit managerial
Add your answer
Q2. Producer consumer multithreading, Java 8 , core java, project
Add your answer

Q1. Behavioral questions
Add your answer
Q2. Situation based questions
Add your answer

Q1. Command to check disk utilisation and health in Hadoop
Ans. 
Use 'hdfs diskbalancer' command to check disk utilisation and health in Hadoop
• Run 'hdfs diskbalancer -report' to get a report on disk utilisation

• Use 'hdfs diskbalancer -plan <path>' to generate a plan for balancing disk usage

• Check the Hadoop logs for any disk health issues
Answered by AI
Add your answer
Q2. Spark Architecture & the significance of each member of spark Architecture
Ans. 
Spark Architecture consists of Driver, Cluster Manager, and Executors. Driver manages the execution of Spark jobs.
• Driver: Manages the execution of Spark jobs, converts user code into tasks, and coordinates with Cluster Manager.

• Cluster Manager: Manages resources across the cluster and allocates resources to Spark applications.

• Executors: Execute tasks assigned by the Driver and store data in memory or disk for further pr...read more
Answered by AI
Add your answer
Q3. Partitioning and bucketing
Add your answer
Q4. Spark optimization techniques
Ans. 
Optimization techniques in Spark improve performance and efficiency of data processing.
• Partitioning data to distribute workload evenly

• Caching frequently accessed data in memory

• Using broadcast variables for small lookup tables

• Avoiding shuffling operations whenever possible

• Tuning memory settings and garbage collection parameters
Answered by AI
Add your answer
Q5. Second highest salary
Ans. 
I am unable to provide this information as it is confidential.
• Confidential information about salaries in previous organizations should not be disclosed.

• It is important to respect the privacy and confidentiality of past employers.

• Discussing specific salary details may not be appropriate in a professional setting.
Answered by AI
Add your answer
Q6. Pivot table creation in SQL from not pivot one
Ans. 
To create a pivot table in SQL from a non-pivot table, you can use the CASE statement with aggregate functions.
• Use the CASE statement to categorize data into columns

• Apply aggregate functions like SUM, COUNT, AVG, etc. to calculate values for each category

• Group the data by the columns you want to pivot on
Answered by AI
Add your answer
Q7. How to create triggers
Ans. 
Creating triggers in a database involves defining the trigger, specifying the event that will activate it, and writing the code to be executed.
• Define the trigger using the CREATE TRIGGER statement

• Specify the event that will activate the trigger (e.g. INSERT, UPDATE, DELETE)

• Write the code or actions to be executed when the trigger is activated

• Test the trigger to ensure it functions as intended
Answered by AI
Add your answer