400+ Analyst Interview Questions and Answers for Freshers

The amount of water used in the college depends on various factors such as the number of students, staff, and facilities.

• The amount of water used in the college varies depending on the size of the college.

• The number of students, staff, and facilities also play a significant role in determining the amount of water used.

• The college may have water-saving measures in place to reduce water usage.

• The amount of water used may also vary depending on the season and weather conditions....read more

I can help RBS grow by leveraging my analytical skills and expertise to identify opportunities for improvement and develop strategies for expansion.

• Conducting thorough market research to identify potential growth areas

• Analyzing financial data to identify cost-saving opportunities

• Developing and implementing strategies to attract new customers and retain existing ones

• Identifying and mitigating risks that may hinder growth

• Collaborating with cross-functional teams to drive innova...read more

Median is best because it is not affected by outliers and gives a better representation of central tendency.

• Median is the middle value in a dataset, which makes it less affected by extreme values or outliers.

• It gives a better representation of central tendency as compared to mean, which can be skewed by outliers.

• Mode is not always useful as it may not exist or may not be unique in a dataset.

• For example, in a dataset of salaries, the median would give a better representation o...read more

Answering questions related to SDLC, Grant VS Revoke, Alpha testing VS Beta Testing, DDL VS DML.

• SDLC stands for Software Development Life Cycle and includes phases like planning, designing, testing, and maintenance.

• Grant and revoke are SQL commands used to grant or revoke privileges to users.

• Alpha testing is done by the developers before releasing the software to the public, while beta testing is done by the end-users.

• DDL stands for Data Definition Language and is used to def...read more

Performing joins on two tables based on specified criteria using SQL.

• Identify the common column(s) between the two tables.

• Choose the appropriate join type (inner, left, right, full outer) based on the desired output.

• Write the SQL query using the JOIN keyword and the ON clause to specify the join criteria.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Creating patterns using Python involves using loops and conditional statements to generate desired sequences of characters.

• Use loops like for and while to iterate through characters or rows

• Use conditional statements like if-else to control the pattern generation

• Combine different patterns to create complex designs

• Utilize string manipulation functions to modify and format the patterns

HTML5 introduced new features like canvas, video, audio, and semantic elements compared to its previous version.

• HTML5 introduced new semantic elements like <header>, <footer>, <nav>, <article>, <section> for better structure and accessibility.

• HTML5 added support for audio and video elements without the need for plugins, making multimedia integration easier.

• HTML5 introduced the <canvas> element for drawing graphics and animations directly on the web page.

• HTML5 brought improvem...read more

Express JEE rank as xy + yx (put y=1, x = rank - 1)

• JEE rank = 1234 can be expressed as 1221 + 2112

• Replace x with rank - 1 and y with 1 to get the answer

• For example, if rank = 5, then x = 4 and y = 1, so the answer is 4321 + 1234 = 5555

scanf() and printf() are functions used for input and output operations in C programming language.

• scanf() is used to read input from the user and store it in variables.

• printf() is used to display output on the screen.

• Both functions are part of the standard input/output library in C.

• They are commonly used in programs for user interaction and displaying results.

I have extensive experience with Excel, Python, R, and SQL for data analysis and programming tasks.

• Proficient in Excel for data manipulation, analysis, and visualization

• Skilled in Python for data cleaning, statistical analysis, and machine learning

• Familiar with R for statistical modeling and data visualization

• Experience with SQL for querying databases and extracting insights

Cash and cash equivalents are highly liquid assets that can be easily converted into cash, such as bank accounts and short-term investments.

• Cash in hand

• Bank accounts

• Short-term investments like money market funds

• Petty cash

• Where to record: Typically recorded under current assets on the balance sheet

SQL Queries using Joins and sub-queries

• Joins are used to combine rows from different tables based on a related column

• Sub-queries are queries nested within another query

• Joins and sub-queries can be used together to retrieve specific data from multiple tables

CO2 is more oxidized than glucose.

• CO2 has a higher oxidation state than glucose.

• In CO2, carbon is fully oxidized to its highest oxidation state (+4), while in glucose, carbon is partially oxidized to its lowest oxidation state (-4).

• Glucose contains more reduced carbon atoms compared to CO2.

• Glucose has more hydrogen atoms bonded to carbon, indicating a lower degree of oxidation compared to CO2.

Destructive refers to something that causes damage or destruction, while construction refers to building or creating something.

• Destructive actions can include things like vandalism, arson, or warfare.

• Construction can involve building structures like buildings, bridges, or roads.

• Both destructive and construction can be used in a variety of contexts, from physical actions to abstract concepts like language or ideas.

• In some cases, destruction can be necessary for construction to...read more

My area of interest is artificial intelligence and machine learning.

• I am fascinated by the potential of AI and ML to revolutionize various industries.

• I enjoy exploring the latest advancements in deep learning and natural language processing.

• I am particularly interested in the ethical implications of AI and the need for responsible development.

• Some of my favorite examples of AI in action include self-driving cars, virtual assistants, and image recognition technology.

QE stands for Quantitative Easing. It is a monetary policy used by central banks to stimulate the economy.

• QE involves the central bank buying government bonds or other securities from the market to increase the money supply.

• The increased money supply is intended to lower interest rates, encourage borrowing and spending, and boost economic activity.

• QE is typically used when interest rates are already low and traditional monetary policy measures are no longer effective.

• Examples...read more

The OSI model has 7 layers that define how data is transmitted over a network.

• Layer 1: Physical layer - deals with the physical aspects of transmitting data

• Layer 2: Data link layer - responsible for error-free transfer of data between nodes

• Layer 3: Network layer - manages the routing of data between nodes

• Layer 4: Transport layer - ensures reliable delivery of data between applications

• Layer 5: Session layer - establishes and manages connections between applications

• Layer 6: Pre...read more

The question is irrelevant and unanswerable.

• The first part is a mathematical calculation while the second part is a completely unrelated question.

• There is no way to estimate the number of Arsenal fans in India based on the given information.

• The question may have been asked to test the candidate's ability to handle unexpected or irrelevant questions.

Jvm is Java Virtual Machine. It manages threads on its own.

• Jvm is a virtual machine that executes Java bytecode.

• It provides a runtime environment for Java programs.

• Jvm manages threads on its own using its own thread scheduler.

• Jvm is platform-independent and provides a layer of abstraction between the Java code and the underlying operating system.

• Examples of popular JVM implementations include Oracle's HotSpot and OpenJDK.

The evidences refer to the proof or supporting facts that validate a claim or argument.

• Evidences can be in the form of data, statistics, research studies, expert opinions, eyewitness accounts, etc.

• For example, in a court case, evidences can include DNA samples, fingerprints, and witness testimonies.

• In scientific research, evidences can include experimental data, peer-reviewed studies, and expert analysis.

• In journalism, evidences can include interviews, documents, and photogra...read more

Indian banks face several technical problems that need to be addressed.

• Outdated technology infrastructure

• Inadequate cybersecurity measures

• Lack of interoperability between different banking systems

• Inefficient data management and analytics

• Limited adoption of digital banking solutions

• Inadequate customer support and grievance redressal mechanisms

Golden rules of accounting and equities vs debt instruments

• Golden rules of accounting are: 1. Debit the receiver, credit the giver 2. Debit what comes in, credit what goes out 3. Debit expenses and losses, credit income and gains

• Equities are ownership shares in a company, while debt instruments are loans made to a company

• Equities provide ownership and potential for profit, while debt instruments provide a fixed return on investment

• Examples of equities include stocks and share...read more

Yes, I have experience communicating with international clients in my previous job.

• I have worked with clients from different countries in my previous job

• I am fluent in English and have basic knowledge of Spanish and French

• I am comfortable using video conferencing tools like Zoom and Skype for communication

Multithreading in Java refers to the concurrent execution of two or more parts of a program for maximum utilization of CPU.

• Multithreading allows multiple threads to run concurrently within a single program.

• It improves the performance of the program by utilizing the CPU more efficiently.

• Java provides built-in support for multithreading through the java.lang.Thread class.

• Multithreading can be used for tasks such as background processing, animation, and network communication.

• Exa...read more

Tower Research does not align with my career goals and interests.

• I am looking for a company that aligns with my values and interests

• I have researched Tower Research and do not feel it is the right fit for me

• I am seeking a company with a strong focus on innovation and collaboration

• Tower Research may be a great fit for others, but it is not the right fit for me

I have used techniques like hyperparameter tuning, feature engineering, and model selection in Databricks for optimization.

• Hyperparameter tuning using GridSearchCV or RandomizedSearchCV

• Feature engineering to create new features or transform existing ones

• Model selection using techniques like cross-validation or ensemble methods

Securitisation is the process of pooling various types of debt and selling them as securities to investors.

• Securitisation involves bundling together various types of debt, such as mortgages, auto loans, or credit card debt.

• These debts are then sold to a special purpose vehicle (SPV) which issues securities backed by the cash flows from the underlying assets.

• Investors purchase these securities and receive payments based on the performance of the underlying assets.

• Securitisatio...read more

Capital refers to the financial assets or resources owned by a company, and it is recorded in the balance sheet under the equity section.

• Capital represents the funds contributed by the owners or shareholders of a company.

• It can include common stock, preferred stock, retained earnings, and additional paid-in capital.

• Capital is recorded in the balance sheet under the equity section, which shows the company's total assets minus its total liabilities.

• For example, if a company iss...read more

The peak bandwidth of 5G network is around 10 Gbps.

• Peak bandwidth of 5G network can reach up to 10 Gbps (Gigabits per second).

• 5G technology offers significantly higher peak data rates compared to 4G networks.

• The actual peak bandwidth may vary depending on network conditions and deployment.

• 5G networks use advanced technologies like massive MIMO and beamforming to achieve high data rates.

Various techniques are used to study protein-protein interactions.

• Yeast two-hybrid assay

• Co-immunoprecipitation

• Surface plasmon resonance

• Fluorescence resonance energy transfer (FRET)

• Proximity ligation assay (PLA)

Loops are used to execute a set of statements repeatedly until a certain condition is met.

• There are three types of loops: for loop, while loop, and do-while loop.

• For loop is used when the number of iterations is known beforehand.

• While loop is used when the number of iterations is not known beforehand.

• Do-while loop is similar to while loop, but it executes the statements at least once before checking the condition.

• Example: for(int i=0; i<10; i++) { //statements }

• Example: while...read more

Perfect numbers within a given range

• A perfect number is a positive integer that is equal to the sum of its proper divisors

• The first few perfect numbers are 6, 28, 496, and 8128

• To find perfect numbers within a given range, iterate through the range and check if each number is perfect

I have a strong understanding of financial statements, valuation methods, risk management, and investment strategies.

• Financial statements: Understanding income statements, balance sheets, and cash flow statements.

• Valuation methods: Knowledge of discounted cash flow analysis, comparable company analysis, and precedent transactions.

• Risk management: Familiarity with hedging strategies, diversification, and risk assessment.

• Investment strategies: Understanding of asset allocation,...read more

A warehouse is a large storage facility used to store goods and products for distribution or sale.

• Warehouses are used by manufacturers, wholesalers, retailers, and other businesses to store their products.

• They can be used for short-term or long-term storage, depending on the needs of the business.

• Warehouses can also be used for cross-docking, where products are quickly transferred from one truck to another for faster distribution.

• Some warehouses are fully automated, using rob...read more

Alpha in financial markets is a measure of an investment's performance compared to a benchmark index.

• Alpha is used to assess the skill of a portfolio manager in generating returns above the market return.

• A positive alpha indicates outperformance, while a negative alpha indicates underperformance.

• Alpha is often used in conjunction with beta, which measures the volatility of an investment compared to the market.

I enjoy reading a variety of genres, including mystery, science fiction, and historical fiction.

• Mystery

• Science fiction

• Historical fiction

A database is a collection of data that is organized in a way that allows for efficient retrieval and manipulation.

• Databases are used to store and manage large amounts of data.

• They allow for easy retrieval and manipulation of data.

• Examples of databases include MySQL, Oracle, and MongoDB.

• Databases are used in various industries such as finance, healthcare, and e-commerce.

Micro in Excel refers to a small unit of measurement, typically used in recording financial data.

• Micro in Excel is a term used to represent a fraction of a whole unit, such as a microsecond or a microgram.

• It is commonly used in financial modeling to represent very small amounts of data, such as fractions of a cent or a percentage point.

• For example, if a company's revenue increased by 0.0001%, it would be represented as a micro increase in Excel.

VPN stands for Virtual Private Network, which allows users to securely access a private network over a public network.

• VPN creates a secure connection between a user and a private network, encrypting data to ensure privacy and security.

• It is commonly used by remote workers to access company resources securely.

• VPN can also be used to bypass geo-restrictions and access region-locked content.

• Popular VPN services include NordVPN, ExpressVPN, and CyberGhost.

One thing can impact all three statements in financial analysis.

• A change in revenue can affect net income, balance sheet, and cash flow statement.

• An increase in accounts receivable can decrease cash flow from operations and increase the balance sheet's current assets.

• A decrease in inventory can increase cash flow from operations and decrease the balance sheet's current assets.

• A change in depreciation expense can affect net income and the balance sheet's property, plant, and e...read more

Derivatives are financial instruments that derive their value from an underlying asset or security.

• Derivatives can be used for hedging or speculation.

• Examples of derivatives include futures, options, and swaps.

• Derivatives can be traded on exchanges or over-the-counter.

• Derivatives can be complex and involve significant risk.

• Derivatives played a role in the 2008 financial crisis.

Prime Services is a suite of financial services offered by investment banks to hedge funds and other institutional clients.

• Prime brokerage

• Securities lending

• Cash management

• Risk management

• Trade execution

• Reporting and analytics

• Examples: Goldman Sachs Prime Services, J.P. Morgan Prime Services

Fractals offer a unique way to understand complex patterns and structures in nature and mathematics.

• Fractals can be found in natural phenomena such as snowflakes, coastlines, and ferns.

• They have practical applications in computer graphics, data compression, and cryptography.

• Fractal geometry provides a new perspective on understanding the behavior of complex systems.

• Fractals have been used to model the growth of tumors and the spread of diseases in medical research.

• The study o...read more

A journal is a publication that contains scholarly articles on a specific subject. It is published through a peer-review process.

• Journals are academic publications that contain research articles, reviews, and other scholarly content.

• They are typically published on a regular basis, such as monthly or quarterly.

• The publication process involves submitting a manuscript to the journal, which is then reviewed by experts in the field before being accepted for publication.

• Journals ca...read more

Glucose is finally metabolized in the mitochondria to produce ATP, the energy currency of cells.

• Glucose is broken down through a series of metabolic pathways

• The final step of glucose metabolism occurs in the mitochondria

• Glucose is converted into pyruvate through glycolysis

• Pyruvate enters the mitochondria and undergoes the citric acid cycle

• The citric acid cycle produces high-energy molecules like NADH and FADH2

• NADH and FADH2 are used in oxidative phosphorylation to produce ATP

The three financial statements are interconnected and provide information about a company's financial performance.

• The income statement shows the company's revenue, expenses, and net income or loss for a specific period.

• The balance sheet shows the company's assets, liabilities, and equity at a specific point in time.

• The cash flow statement shows the company's cash inflows and outflows for a specific period.

• The net income from the income statement is used to calculate the retai...read more

Built-in functions in C are pre-defined functions provided by the C standard library.

• Built-in functions are ready-to-use functions that can be called in a C program without the need for their implementation.

• Examples of built-in functions include printf(), scanf(), strlen(), and malloc().

• These functions are included in the standard library header files such as stdio.h, string.h, and stdlib.h.

• Built-in functions can save time and effort in programming by providing commonly used ...read more