Filter interviews by
I applied via Campus Placement and was interviewed before Mar 2021. There was 1 interview round.
Indexing is a way to improve database performance by creating a separate data structure that allows faster data retrieval.
Clustered index: sorts and stores the data rows in the table based on their key values
Non-clustered index: creates a separate structure that includes the indexed columns and a pointer to the data row
Full-text index: enables full-text search on character-based data types
Filtered index: indexes a subs...
Query optimization techniques aim to improve the performance of database queries.
Use indexes to speed up query execution
Avoid using SELECT * and instead specify only required columns
Use JOINs instead of subqueries
Avoid using functions in WHERE clauses
Use EXPLAIN to analyze query execution plan
Functions return a value while stored procedures do not.
Functions are used to perform a specific task and return a value.
Stored procedures are used to execute a set of SQL statements and do not return a value.
Functions can be used in SQL statements while stored procedures cannot.
Functions can be called from within stored procedures.
Functions are deterministic while stored procedures may not be.
Functions can be used in
Temp table and magic table are used in SQL for temporary storage and tracking changes respectively.
Temp table is used to store intermediate results during a query execution.
Magic table is used to track changes made to a table during an INSERT, UPDATE or DELETE operation.
Temp table is created using CREATE TABLE statement with # or ## prefix.
Magic table is accessed using the special INSERTED and DELETED tables.
Temp table...
Yes, we can delete records from views. Views are virtual tables that display data from one or more tables.
Views are used to simplify complex queries by providing a virtual table with a specific subset of data.
Deleting records from a view will delete the corresponding records from the underlying table(s).
Views can also be used to restrict access to sensitive data by only allowing certain columns to be displayed.
Example:...
Constraints are limitations or rules that must be followed in software development.
Data constraints: limit the type or amount of data that can be entered
Domain constraints: limit the values that can be entered
Business rules: limit the actions that can be taken
Hardware constraints: limit the hardware that can be used
Time constraints: limit the time available for development or execution
Top trending discussions
Palindrome code should be designed to check if a given string is the same forwards and backwards.
Create a function that takes a string as input
Remove any spaces and punctuation from the string
Reverse the string and compare it to the original string to check if it is a palindrome
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
I am passionate about driving organizational effectiveness and employee engagement through strategic HR initiatives.
I have a strong background in HR strategy and business partnering
I enjoy collaborating with cross-functional teams to drive positive change
I am excited about the opportunity to make a meaningful impact on the organization's culture and performance
I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.
4 easy level questions will be asked basically from arrays and strings.
Assignment will be given after clearing coding round. In my case ELearning Platform project was given and 7 days time was given to complete.
posted on 17 Dec 2024
I applied via LinkedIn and was interviewed in Nov 2024. There were 2 interview rounds.
Utilize AWS or Azure services for scalable web applications
Use AWS Elastic Beanstalk or Azure App Service for easy deployment and scaling
Leverage AWS Lambda or Azure Functions for serverless computing
Utilize AWS Auto Scaling or Azure Autoscale to automatically adjust resources based on traffic
Store data in AWS RDS or Azure SQL Database for scalable database solutions
Use AWS CloudFront or Azure CDN for content delivery
I would use memory profiling tools to identify the source of the leaks and then fix them by properly managing memory allocation and deallocation.
Use memory profiling tools like Valgrind or Instruments to identify the source of the leaks
Review the code to ensure proper memory allocation and deallocation practices are being followed
Implement smart pointers or garbage collection to automatically manage memory
Use static co...
Yes, I have experience working on legacy systems.
I have successfully maintained and upgraded legacy systems to meet current business needs.
I have refactored legacy code to improve performance and scalability.
I have integrated new technologies with legacy systems to enhance functionality.
I have experience troubleshooting and debugging issues in legacy systems.
Yes, I have experience working with cross functional teams and resolving disputes effectively.
I have successfully collaborated with team members from different departments to achieve project goals.
I am skilled at mediating conflicts and finding mutually beneficial solutions.
I prioritize open communication and actively listen to all team members' perspectives.
I have experience using conflict resolution techniques such a
posted on 27 Sep 2024
I applied via Walk-in and was interviewed in Aug 2024. There were 3 interview rounds.
Basically It is a list of 25 questions having mix of Resoning,Aptitude &English. Each Queztion carries 2 marks and also there was a plus point that it doesn't have any negative marks
posted on 15 Jan 2025
List is mutable, tuple is immutable in Python.
List is mutable, meaning its elements can be changed after creation.
Tuple is immutable, meaning its elements cannot be changed after creation.
List is defined using square brackets [], tuple using parentheses ().
Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
posted on 24 Dec 2024
I applied via LinkedIn and was interviewed in Nov 2024. There were 4 interview rounds.
Experienced Full Stack Developer with expertise in front-end and back-end technologies.
Experienced in HTML, CSS, JavaScript for front-end development
Proficient in Node.js, Express, MongoDB for back-end development
Familiar with React, Angular for building interactive web applications
GraphQL is a query language for APIs and a runtime for executing those queries. REST API is a set of rules for building web services. Both have their own advantages.
GraphQL allows clients to request only the data they need, reducing over-fetching and under-fetching.
REST API follows a more rigid structure and is easier to understand for beginners.
GraphQL is more efficient for complex queries involving multiple resources...
I was asked to discuss the system design of Google Meet, with a primary focus on video processing and WebRTC.
A graph question regarding LC 1334.
Experienced Full Stack Developer with a passion for creating innovative solutions and a strong desire to contribute to a dynamic team.
Over 5 years of experience in full stack development, working on various projects from concept to deployment.
Proficient in front-end technologies such as HTML, CSS, JavaScript, and React.
Skilled in back-end technologies including Node.js, Express, and MongoDB.
Motivated by the opportunity...
posted on 26 Dec 2024
I applied via Company Website and was interviewed in Nov 2024. There was 1 interview round.
I am a Software Development Engineer with 5 years of experience in developing web applications using Java, Spring, and Angular.
5 years of experience in software development
Proficient in Java, Spring, and Angular
Strong problem-solving skills
Experience in developing web applications
Good team player
posted on 10 Jan 2025
based on 11 reviews
Rating in categories
PHP Developer
9
salaries
| ₹1.2 L/yr - ₹4.4 L/yr |
Laravel Developer
7
salaries
| ₹1.4 L/yr - ₹3.1 L/yr |
Software Developer
6
salaries
| ₹3.3 L/yr - ₹6.6 L/yr |
Business Analyst
5
salaries
| ₹2 L/yr - ₹5.4 L/yr |
Web Designer
5
salaries
| ₹2.4 L/yr - ₹4.7 L/yr |
TCS
Infosys
Wipro
HCLTech