i
Aryupay
Filter interviews by
Be the first one to contribute and help others!
posted on 22 Dec 2021
I applied via Naukri.com and was interviewed in Jun 2021. There were 4 interview rounds.
Improving SQL performance involves optimizing queries, indexes, and server resources.
Optimize queries by reducing complexity and avoiding unnecessary joins
Use indexes to speed up data retrieval
Ensure server resources are adequate for the workload
Consider partitioning large tables to improve query performance
Use stored procedures to reduce network traffic and improve security
Index, trigger, and stored procedure are database objects used to improve performance and automate tasks.
An index is a data structure that improves the speed of data retrieval operations on a database table.
A trigger is a set of instructions that automatically executes in response to certain events, such as an insert, update, or delete operation on a table.
A stored procedure is a precompiled set of SQL statements that ...
Relationship in SQL refers to the association between two or more tables based on common fields.
Relationships are established using foreign keys
Types of relationships include one-to-one, one-to-many, and many-to-many
Relationships can be visualized using ER diagrams
Joins are used to retrieve data from related tables
Class module is a custom object in VBA that allows you to define your own properties and methods.
Class modules are used to create custom objects in VBA
They allow you to define your own properties and methods
You can create instances of a class module and use them in your code
Class modules are useful for encapsulating complex logic and data
They can be used to create reusable code libraries
Objects in MS Access are used to represent tables, forms, reports, and other database objects.
Objects are used to organize and manage data in MS Access.
Tables are the most basic object and store data in rows and columns.
Forms are used to display and edit data in a user-friendly way.
Reports are used to present data in a formatted and organized way.
Queries are used to retrieve and manipulate data from tables.
Modules are ...
Design view is used to create and modify database objects, while Datasheet view is used to view and edit data in tables.
Design view allows users to create and modify tables, queries, forms, reports, and macros.
Datasheet view displays data in a spreadsheet-like format and allows users to edit data directly.
Design view is used to set properties and define relationships between tables.
Datasheet view is used to sort, filte...
Joins are used to combine data from two or more tables in SQL. There are different types of joins.
Inner join returns only the matching rows from both tables
Left join returns all the rows from the left table and matching rows from the right table
Right join returns all the rows from the right table and matching rows from the left table
Full outer join returns all the rows from both tables
Cross join returns the Cartesian p
Yes, I have computer knowledge.
Proficient in Microsoft Office Suite
Familiar with CRM software such as Salesforce
Experience with data analysis tools like Excel and Tableau
I applied via Referral and was interviewed in Nov 2022. There was 1 interview round.
The stock market is a platform where publicly traded companies sell shares to investors, allowing them to buy and sell ownership in the company.
Stock market is a place where stocks, bonds, and other securities are traded
Investors buy and sell stocks to make a profit
Stock prices are influenced by various factors such as company performance, economic indicators, and global events
Stock market indices such as the Dow Jones...
I applied via LinkedIn and was interviewed in Feb 2023. There were 3 interview rounds.
Hackerrank test medium difficulty
Presenting the case study which was given as a take-home assignment
I applied via Naukri.com and was interviewed in Sep 2023. There were 4 interview rounds.
I applied via Walk-in and was interviewed before Feb 2023. There was 1 interview round.
I applied via Recruitment Consulltant and was interviewed in Mar 2022. There were 2 interview rounds.
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
Share market is a platform where buying and selling of company stocks and securities takes place.
Share market allows companies to raise capital by selling shares to investors
Investors can buy and sell shares of publicly traded companies
Prices of shares fluctuate based on supply and demand in the market
Investors can make profits by selling shares at a higher price than they bought them for
To convince clients to invest in the share market, highlight potential returns, diversification benefits, and long-term growth opportunities.
Educate clients on the potential returns and benefits of investing in the share market.
Highlight the benefits of diversification to reduce risk in their investment portfolio.
Emphasize the long-term growth opportunities in the share market compared to other investment options.
Provi...
I applied via Direct and was interviewed in Apr 2024. There were 2 interview rounds.
About any article or product selling
Like how to look forward
Market cap, short for market capitalization, is the total value of a company's outstanding shares of stock.
Market cap is calculated by multiplying the current stock price by the total number of outstanding shares.
It is used to determine the size of a company and its relative value compared to other companies.
Market cap is an important metric for investors to consider when making investment decisions.
For example, if a c...
Technical indicators are mathematical calculations based on historical price, volume, or open interest data used to forecast future price movements in trading.
Technical indicators help traders make informed decisions by providing insights into market trends and potential price movements.
Examples of technical indicators include moving averages, relative strength index (RSI), and Bollinger Bands.
Traders use technical ind...
Bajaj Finserv
Wells Fargo
JPMorgan Chase & Co.
Motilal Oswal Financial Services