i
Wipro
Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Aug 2023. There were 3 interview rounds.
The .NET Framework is a software framework developed by Microsoft that provides a large library of pre-coded solutions to common programming problems.
Developed by Microsoft
Provides a large library of pre-coded solutions
Supports multiple programming languages
Used for building applications for Windows, web, mobile, and cloud
Consists of Common Language Runtime (CLR) and class library
LINQ stands for Language Integrated Query.
LINQ is a set of features introduced in .NET Framework that allows for querying data from different data sources using a uniform syntax.
LINQ can be used to query objects, databases, XML, and more.
LINQ provides a consistent model for working with data regardless of the data source.
Example: var query = from c in customers where c.City == 'London' select c;
Clustered index determines the physical order of data in a table, while non-clustered index does not.
Clustered index physically reorders the table data based on the indexed column
Non-clustered index creates a separate structure to store the index data
Clustered index is faster for retrieval but slower for insert and update operations
Non-clustered index is slower for retrieval but faster for insert and update operations
UNION combines the result sets of two or more SELECT statements, while UNION ALL does the same but includes duplicate rows.
UNION removes duplicate rows from the result set, while UNION ALL includes all rows
UNION is slower than UNION ALL because it performs a distinct operation
UNION requires that all SELECT statements have the same number of columns with compatible data types
Example: SELECT column1 FROM table1 UNION SEL...
Expected salary should be based on industry standards, experience, skills, and responsibilities of the role.
Research industry standards for the specific role and location
Consider your level of experience and skills
Factor in the responsibilities and expectations of the position
Be prepared to negotiate based on the company's budget and benefits package
I would join your company because of its reputation for innovation and growth opportunities.
Reputation for innovation in the industry
Opportunities for growth and advancement
Positive company culture and values
Exciting projects and challenges to work on
I applied via Referral and was interviewed before Feb 2022. There were 4 interview rounds.
Optimizing a React application involves reducing bundle size, improving rendering performance, and implementing code splitting.
Use code splitting to load only necessary code for each page
Minimize bundle size by removing unused dependencies and optimizing images
Use React.memo and shouldComponentUpdate to prevent unnecessary re-renders
Use lazy loading to defer loading of non-critical components
Use server-side rendering t...
Shadow DOM is a way to encapsulate the styling and behavior of a web component.
Shadow DOM allows for creating isolated DOM trees within a larger document.
It helps to prevent CSS conflicts and JavaScript collisions between different parts of a web page.
Shadow DOM can be used to create reusable web components that can be easily shared and used across different projects.
It is supported by all modern browsers including Chr
useMemo is used for memoization of a value, while useCallback is used for memoization of a function.
useMemo returns a memoized value, while useCallback returns a memoized function.
useMemo is used to optimize expensive computations, while useCallback is used to optimize expensive function creation.
useMemo takes a function and an array of dependencies, while useCallback takes a function and an array of dependencies and r...
A pure function is a function that always returns the same output for a given input and has no side effects.
Pure functions are deterministic and have no side effects.
They only depend on their input parameters and not on any external state.
Pure functions are easier to test and reason about than impure functions.
Examples of pure functions include mathematical functions like sin(x) and cos(x).
I applied via Recruitment Consulltant and was interviewed before May 2023. There were 2 interview rounds.
I applied via Recruitment Consultant and was interviewed in May 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed in Jun 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed in Dec 2020. There were 3 interview rounds.
I applied via Walk-in and was interviewed before Oct 2020. There were 5 interview rounds.
posted on 11 Nov 2019
I applied via Recruitment Consultant and was interviewed in May 2019. There were 3 interview rounds.
Answering types of JOINS for two given tables.
INNER JOIN: returns only matching rows from both tables
LEFT JOIN: returns all rows from left table and matching rows from right table
RIGHT JOIN: returns all rows from right table and matching rows from left table
FULL OUTER JOIN: returns all rows from both tables and NULL values where there is no match
CROSS JOIN: returns all possible combinations of rows from both tables
Java with DB is better than PL/SQL as it offers more flexibility and scalability.
Java with DB allows for easier integration with other technologies
Java offers more advanced programming features than PL/SQL
Java with DB can handle larger and more complex data sets
PL/SQL is limited to Oracle databases only
Java with DB is more widely used and has a larger community for support
Dynamic SQL is a technique to generate SQL statements at runtime based on user input or other conditions.
Dynamic SQL is used to create flexible and customizable queries.
It allows for the creation of complex queries with multiple conditions.
Dynamic SQL can be executed using prepared statements or by concatenating strings.
It is important to properly sanitize user input to prevent SQL injection attacks.
Overriding in PL/SQL is the ability to define a subprogram in a child package that has the same name and signature as a subprogram in a parent package.
Overriding allows a child package to provide its own implementation of a subprogram that is already defined in a parent package.
The child subprogram must have the same name and signature as the parent subprogram.
The child subprogram can have a different implementation th...
Triggers are database objects that are used to automatically execute a response when a certain event occurs.
DML Triggers
DDL Triggers
Logon Triggers
CLR Triggers
INSTEAD OF Triggers
Identifying type of join for given outputs of two tables.
Inner join: returns only the matching rows from both tables.
Left join: returns all rows from left table and matching rows from right table.
Right join: returns all rows from right table and matching rows from left table.
Full outer join: returns all rows from both tables and matching rows from both tables.
based on 2 interviews
Interview experience
based on 26 reviews
Rating in categories
Project Engineer
32.8k
salaries
| ₹1.8 L/yr - ₹8.3 L/yr |
Senior Software Engineer
23.1k
salaries
| ₹5.8 L/yr - ₹22 L/yr |
Senior Associate
21.3k
salaries
| ₹0.9 L/yr - ₹5.5 L/yr |
Senior Project Engineer
20.4k
salaries
| ₹5 L/yr - ₹19.5 L/yr |
Technical Lead
18.7k
salaries
| ₹8.5 L/yr - ₹36.5 L/yr |
TCS
Infosys
Tesla
Amazon