i
CDW
Filter interviews by
I applied via Campus Placement and was interviewed in Mar 2023. There were 2 interview rounds.
The aptitude round had the topics of train and distance and time , OOPS , Core Java , JavaScript questions , Operating System questions and DBMS questions.
I applied via Recruitment Consultant and was interviewed in May 2021. There was 1 interview round.
I applied via Referral and was interviewed in Apr 2020. There were 5 interview rounds.
Normalization is a process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and establishing relationships between them.
There are different levels of normalization, with each level having specific rules to follow.
Normalization helps to prevent data inconsistencies and anomalies.
Examples of normalization include converting r...
I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.
CTE and temp tables are used to store intermediate results in SQL queries.
CTE stands for Common Table Expression and is defined within a query.
Temp tables are created in the tempdb database and can be accessed across sessions.
CTEs are generally faster and more readable than temp tables.
Temp tables are useful for complex queries with multiple steps or when data needs to be manipulated.
CTEs are useful for recursive queri
Asynchronous programming in .NET allows for non-blocking execution of code, improving performance and responsiveness.
Async and Await keywords used to implement asynchronous programming
Allows for parallel execution of multiple tasks
Improves performance and responsiveness of applications
Examples include web applications, file I/O operations, and database queries
Threading in .NET allows for concurrent execution of code, improving performance and responsiveness.
Threading allows for multiple threads of execution to run concurrently
Thread class is used to create and manage threads
Thread synchronization is important to prevent race conditions and deadlocks
Async/await is a newer approach to concurrency in .NET
TPL (Task Parallel Library) provides higher-level abstractions for concur
Performance tuning of SQL stored procedure involves optimizing query execution time and reducing resource usage.
Identify and optimize the most resource-intensive queries
Use appropriate indexing and partitioning techniques
Minimize network round trips and data transfers
Avoid using cursors and temporary tables
Use query hints and plan guides to influence query execution plan
Regularly monitor and analyze query performance u...
All multiple choices consisting of code output based questions and logical reasoning
I appeared for an interview in Jul 2022.
I appeared for an interview in Feb 2025, where I was asked the following questions.
This code reverses the characters of a string while keeping the order of words intact in C++.
Split the string into words using a space as a delimiter.
Reverse the entire string to get the characters in reverse order.
Reverse each individual word to restore their original order.
Example: Input: 'Hello World' -> Output: 'dlroW olleH'
Deep copy creates a new object with copies of nested objects; shallow copy copies references to nested objects.
Shallow Copy: Copies the object's reference, not the actual object. Example: `list2 = list1.copy()`.
Deep Copy: Creates a new object and recursively copies all objects found in the original. Example: `import copy; list2 = copy.deepcopy(list1)`.
Shallow Copy is faster but can lead to unintended side effects if th...
Use a SQL query to filter records where age is greater than 2.
Basic SQL syntax: SELECT column_name FROM table_name WHERE condition;
Example query: SELECT * FROM users WHERE age > 2;
This query retrieves all records from the 'users' table where the age column has values greater than 2.
Ensure the 'age' column is of a numeric type to avoid errors.
based on 1 interview
Interview experience
Consultant
92
salaries
| ₹4 L/yr - ₹15.5 L/yr |
Associate Consultant
59
salaries
| ₹4 L/yr - ₹9.2 L/yr |
Senior System Administrator
51
salaries
| ₹6.3 L/yr - ₹11 L/yr |
System Administrator
34
salaries
| ₹3 L/yr - ₹7.2 L/yr |
Senior Consultant
27
salaries
| ₹6.2 L/yr - ₹19.5 L/yr |
HTC Global Services
HERE Technologies
Collabera Technologies
Unisys