i
Zensar Technologies
Filter interviews by
Truncate removes all data from a table quickly, while delete removes specific rows one by one.
Truncate is faster than delete as it does not log individual row deletions.
Truncate resets identity columns, while delete does not.
Truncate cannot be rolled back, while delete can be.
Truncate is a DDL operation, while delete is a DML operation.
I applied via Approached by Company and was interviewed before Mar 2023. There was 1 interview round.
Writing a REST API for a real-time example
Choose a real-time example, such as a chat application or a stock market tracker
Design the API endpoints and their corresponding HTTP methods
Implement the API using a framework like Express.js or Django
Use WebSockets or long-polling for real-time updates
Ensure authentication and authorization mechanisms are in place
Handle error cases and provide appropriate error responses
Zensar Technologies interview questions for designations
I applied via Company Website and was interviewed in Oct 2024. There were 2 interview rounds.
One question related to string manipulation which is of medium level difficulty.
posted on 17 Oct 2024
REST API is lightweight, flexible, and widely used, while SOAP API is more rigid and heavy.
REST API uses standard HTTP methods like GET, POST, PUT, DELETE, while SOAP API uses XML for communication.
REST API is stateless and can be cached, making it faster, while SOAP API is stateful and requires more bandwidth.
REST API is easier to implement and understand, while SOAP API has more built-in security features.
Examples: R
posted on 19 Aug 2024
Questions from Resume, solving code snippets, DSA Algo
GCD, Core Data, Higher Order Functions, ARC are key concepts in iOS development.
GCD (Grand Central Dispatch) is a technology for managing concurrent operations.
Core Data is a framework for managing the model layer objects in an application.
Higher Order Functions are functions that operate on other functions, taking them as arguments or returning them.
ARC (Automatic Reference Counting) is a memory management technology
I applied via Job Portal and was interviewed in Feb 2024. There were 2 interview rounds.
CTE stands for Common Table Expressions, used to create temporary result sets within a SQL query.
CTE is defined using the WITH keyword in SQL.
It helps in simplifying complex queries by breaking them into smaller, more manageable parts.
CTEs can reference themselves recursively, making them useful for hierarchical data.
Example: WITH cte AS (SELECT * FROM table_name) SELECT * FROM cte;
Print even and odd numbers between 1 to 20.
Iterate from 1 to 20 and check if the number is even or odd.
Use a conditional statement to determine if the number is even or odd.
Print the number along with its type (even or odd).
posted on 22 May 2024
1 hr coding round, mostly JAVA questions
based on 23 reviews
Rating in categories
Software Engineer
3.9k
salaries
| ₹2.4 L/yr - ₹10 L/yr |
Senior Software Engineer
3.8k
salaries
| ₹5.2 L/yr - ₹22.9 L/yr |
Technical Specialist
1.5k
salaries
| ₹9.4 L/yr - ₹33 L/yr |
Softwaretest Engineer
833
salaries
| ₹2.6 L/yr - ₹9.5 L/yr |
Senior Technical Specialist
704
salaries
| ₹11.5 L/yr - ₹40.2 L/yr |
TCS
Infosys
Wipro
HCLTech