20+ Bank of America Interview Questions and Answers

Different types of joins in database management, null values in primary and unique key columns, and right join in SQL.

• Types of joins: inner join, outer join (left, right, full), cross join, self join

• Primary key column cannot contain null values

• Unique key column can contain null values, but only one null value is allowed

• Right join in SQL: returns all rows from the right table and the matched rows from the left table

I would conduct a thorough analysis of the supplier's offer and present a detailed comparison with the L1 and L2 suppliers to persuade my manager.

• Conduct a detailed cost analysis of the H1 supplier's offer, including all relevant factors such as quality, delivery time, and terms of payment.

• Prepare a comprehensive comparison chart showcasing the strengths and weaknesses of the H1 supplier in relation to the L1 and L2 suppliers.

• Highlight any potential cost savings or added valu...read more

Soliciting multiple quotes involves reaching out to various suppliers and evaluating them based on criteria like price, quality, lead time, and reliability.

• Reach out to a variety of suppliers to request quotes for the same product or service.

• Consider criteria such as price, quality, lead time, reliability, and supplier reputation.

• Evaluate the quotes based on the criteria and choose the supplier that best fits the needs of the project or organization.

• Negotiate with the selecte...read more

I would highlight the benefits and advantages of the specified supplier's proposal compared to others.

• Emphasize the unique value proposition of the specified supplier's proposal

• Highlight any cost savings or efficiencies that can be gained by choosing this supplier

• Provide evidence of the supplier's track record of delivering high-quality products or services

• Address any concerns or objections raised by the manager and offer solutions or alternatives

A line chart showing continuous sales data from January 2021 to December 2024.

• Use a line chart to display the trend of sales over time

• Include a time axis with months from January 2021 to December 2024

• Label the axes clearly and provide a legend if necessary

Yes, R can be integrated with JavaScript using the 'shiny' package to create interactive web applications.

• Use the 'shiny' package in R to create interactive web applications

• Use the 'htmlwidgets' package to embed interactive R visualizations in web pages

• Utilize the 'r2d3' package to create D3 visualizations in R and embed them in web applications

The 'V8' package in R is used to import and execute JavaScript code.

• Use the 'V8' package in R to import and execute JavaScript code.

• Install the 'V8' package using install.packages('V8').

• Load the 'V8' package using library(V8).

• Use the v8() function to create a new V8 context and execute JavaScript code.

Sales comparison between last year and current year with relevant filters

• Calculate total sales for last year and current year

• Apply any relevant filters such as product category or region

• Compare sales figures to identify trends or changes

• Visualize the comparison using charts or graphs for better understanding

Calculate a three-month running total using DAX and Excel

• In DAX, use the CALCULATE function with a FILTER for the three-month period

• In Excel, use a combination of SUM and OFFSET functions to calculate the running total

• For example, in DAX: CALCULATE(SUM([Value]), FILTER(ALL('Date'[Month]), 'Date'[Month] >= 'November' && 'Date'[Month] <= 'January'))

• For Excel: =SUM(OFFSET($A$2, MAX(ROW($A$2:$A$10)-2, 1), 0, 3, 1))

The man will fall into the pit after 3 steps.

• The man moves 2 steps forward and 1 step backward in each cycle.

• After the first cycle, the man will be 1 step ahead.

• After the second cycle, the man will be 2 steps ahead and fall into the pit on the third cycle.

Concatenate 3 columns and handle null values in SQL query

• Use CONCAT_WS function to concatenate columns and handle null values

• Provide a separator as the first argument in CONCAT_WS function

• Use IFNULL function to replace null values with a specified value

I use metrics such as accuracy, precision, recall, F1 score, ROC-AUC, and confusion matrix to test the models deployed.

• Accuracy: measures the overall correctness of the model

• Precision: measures the proportion of true positive predictions among all positive predictions

• Recall: measures the proportion of true positive predictions among all actual positives

• F1 score: balances precision and recall

• ROC-AUC: measures the area under the receiver operating characteristic curve

• Confusion ...read more

Compare last year sales for budget with the forecast and visualize the sales comparison between budget and forecast.

• Calculate the difference between last year sales, budget, and forecast.

• Create a bar chart showing the comparison of last year sales, budget, and forecast.

• Highlight any significant deviations between budget and forecast.

• Provide a narrative explaining the reasons for any discrepancies.

I have a basic understanding of JavaScript and can work with it to some extent.

• Familiar with basic JavaScript syntax and concepts

• Able to manipulate DOM elements using JavaScript

• Have experience working with JavaScript libraries like jQuery

Yes, the target molecule can be synthesized using different routes.

• One possible route is through a series of chemical reactions starting from readily available starting materials.

• Another route could involve using a different catalyst or reagent to achieve the desired transformation.

• Alternatively, a multi-step synthesis approach can be employed to access the target molecule.

• Different protecting groups or functional group transformations can also be explored to arrive at the ta...read more

The region with the highest sales is North America.

• Check sales data for each region or country

• Look for the region or country with the highest total sales

• Create a bar chart or pie chart to visualize the data

To find the third highest salary of an employee and calculate cumulative sales using SQL.

• To find the third highest salary of an employee, you can use the following SQL query: SELECT DISTINCT Salary FROM Employees ORDER BY Salary DESC LIMIT 2, 1

• To calculate cumulative sales, you can use the following SQL query: SELECT SUM(Sales) FROM SalesData

To rename a column in PySpark, use the 'withColumnRenamed' method.

• Use the 'withColumnRenamed' method on the DataFrame

• Specify the current column name and the new column name as arguments

• Assign the result to a new DataFrame to store the renamed column

Multiprocessing involves executing multiple processes simultaneously, while multithreading involves executing multiple threads within a single process.

• Multiprocessing utilizes multiple CPUs or cores to execute multiple processes concurrently.

• Multithreading involves creating multiple threads within a single process to execute tasks concurrently.

• Processes in multiprocessing have separate memory spaces, while threads in multithreading share the same memory space.

• Multiprocessing ...read more

Use GROUP BY to find distinct values in SQL without using the DISTINCT keyword.

• Use GROUP BY clause with all columns in the SELECT statement

• This will group the rows with the same values together, effectively giving distinct values

Create a React application for a specific purpose or functionality.

• Use create-react-app to set up a new React project

• Design components using JSX syntax

• Manage state and props to pass data between components

• Utilize React Router for navigation between different pages

• Fetch data from an API using Axios or Fetch for dynamic content