Filter interviews by
I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.
posted on 26 Oct 2023
I applied via Referral and was interviewed before Oct 2022. There were 4 interview rounds.
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
posted on 25 Apr 2024
posted on 24 Jul 2024
I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 3 interview rounds.
I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 2 interview rounds.
Developed a web application for online shopping with user authentication and payment gateway integration.
Used React.js for front-end development
Implemented user authentication using JWT tokens
Integrated Stripe API for payment processing
Optimization techniques are methods used to improve the efficiency and performance of software applications.
Use of algorithms like dynamic programming and greedy algorithms
Profiling and performance tuning to identify bottlenecks
Code refactoring to improve readability and maintainability
Utilizing caching and memoization for faster access to data
Parallel processing and multi-threading for improved concurrency
Find duplicates in an ArrayList of strings.
Iterate through the ArrayList and use a HashSet to keep track of seen elements.
If an element is already in the HashSet, it is a duplicate.
Store the duplicates in a separate ArrayList or print them directly.
I applied via Recruitment Consulltant and was interviewed before May 2023. There were 2 interview rounds.
Primary is used to define a primary bean when multiple beans of the same type are present, while Qualifier is used to specify which bean to autowire when multiple beans of the same type are present.
Primary annotation is used to give a higher preference to a bean when multiple beans of the same type are present in the Spring application context.
Qualifier annotation is used to specify which bean to autowire when multiple...
Fault tolerance in Microservices can be achieved through redundancy, graceful degradation, and circuit breakers.
Implementing redundancy by having multiple instances of each microservice running to handle failures.
Using graceful degradation to ensure that the system can still function even if certain microservices are unavailable.
Utilizing circuit breakers to prevent cascading failures by temporarily stopping requests t
Implementing Spring Security involves configuring security settings in the Spring application.
Add Spring Security dependency in pom.xml
Configure security settings in SecurityConfig class
Define user roles and permissions
Use annotations like @EnableWebSecurity and @Secured
OAuth 2 is an authorization framework that allows a third-party application to obtain limited access to an HTTP service.
OAuth 2 is used for delegated access, allowing a user to grant a third-party application access to their resources without sharing their credentials.
It involves the use of access tokens, which are issued by the authorization server after the user authenticates and authorizes the application.
OAuth 2 su...
Java uses automatic memory management through garbage collection to allocate and deallocate memory.
Java uses garbage collection to automatically manage memory by deallocating objects that are no longer needed.
The JVM has a heap where objects are allocated and garbage collection is performed to reclaim memory.
Java provides the 'finalize()' method for objects to perform cleanup before they are garbage collected.
Memory le...
Different types of garbage collection algorithms in software development.
Mark and Sweep: Identifies and removes unreachable objects.
Generational: Divides objects into different generations based on age.
Parallel: Uses multiple threads to perform garbage collection concurrently.
Incremental: Spreads garbage collection work over multiple cycles to reduce pause times.
Executors are a class that provides factory and utility methods for Executor, ExecutorService is an interface that represents an asynchronous execution service.
Executors class provides factory and utility methods for Executor interface
ExecutorService is an interface that represents an asynchronous execution service
ExecutorService extends Executor interface
ExecutorService provides methods to manage termination and produ...
based on 1 review
Rating in categories
Senior Analyst
113
salaries
| ₹5.3 L/yr - ₹14.9 L/yr |
Analyst
96
salaries
| ₹4.5 L/yr - ₹9 L/yr |
Financial Analyst
62
salaries
| ₹4 L/yr - ₹9.6 L/yr |
Lead Analyst
55
salaries
| ₹8 L/yr - ₹17.6 L/yr |
Team Lead
33
salaries
| ₹8 L/yr - ₹27 L/yr |
Wells Fargo
JPMorgan Chase & Co.
Citicorp
Morningstar