Filter interviews by
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization helps in minimizing data redundancy by dividing the database into multiple tables.
It ensures data integrity by avoiding update anomalies.
Normalization is achieved through a series of rules known as normal forms, such as 1NF, 2NF, 3NF, etc.
Data modelling is the process of creating a visual representation of data and its relationships to help understand and analyze it.
Data modelling involves identifying entities, attributes, and relationships in a database.
It helps in designing databases that are efficient, scalable, and easy to maintain.
Examples of data modelling tools include ER diagrams, UML diagrams, and data flow diagrams.
Procedure is a set of instructions that performs a specific task, while a function is a block of code that returns a value.
Procedure does not return a value, while a function does.
Functions can be called from within SQL statements, while procedures cannot.
Functions can be used in expressions, while procedures cannot.
Procedures can have both input and output parameters, while functions can only have input parameters.
Ranking functions are used to assign a rank to each row in a result set based on specific criteria.
Ranking functions include RANK(), DENSE_RANK(), and ROW_NUMBER()
They are commonly used in SQL queries to order and rank data
RANK() assigns a unique rank to each row, with gaps in the ranking if there are ties
DENSE_RANK() assigns a unique rank to each row without any gaps
ROW_NUMBER() assigns a unique sequential integer to
posted on 10 Dec 2024
I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.
I am a software engineer with 5 years of experience in developing web applications using Java, Spring Boot, and Angular.
5 years of experience in software development
Proficient in Java, Spring Boot, and Angular
Strong problem-solving skills
Experience working in Agile development environment
Bachelor's degree in Computer Science from XYZ University
I come from a close-knit family of five, including my parents, older sister, and younger brother.
Close-knit family of five
Parents, older sister, and younger brother
We enjoy spending time together traveling and trying new restaurants
Seeking new challenges and opportunities for growth in a different environment.
Desire for new challenges and learning opportunities
Seeking a better work-life balance
Interested in working with new technologies or industries
Looking for a more collaborative team environment
PHP supports all major Object-Oriented Programming concepts including classes, objects, inheritance, encapsulation, and polymorphism.
Classes: PHP allows you to define classes using the 'class' keyword.
Objects: You can create objects of a class using the 'new' keyword.
Inheritance: PHP supports inheritance where a class can inherit properties and methods from another class.
Encapsulation: PHP allows you to restrict access...
PHP provides a variety of pre-defined functions for string manipulation.
strlen() - returns the length of a string
str_replace() - replaces all occurrences of a search string with a replacement string
substr() - returns a part of a string
strtolower() - converts a string to lowercase
strtoupper() - converts a string to uppercase
Third-party services can be managed by integrating them into the MVC framework using libraries or APIs.
Use libraries or APIs provided by the third-party service to interact with it within the MVC framework.
Create service classes or components to encapsulate the logic for interacting with the third-party service.
Utilize dependency injection to inject the third-party service dependencies into the controllers or models.
Ha...
I was interviewed in Jul 2024.
Leet code medium level question
Hashmap is a data structure that stores key-value pairs and allows for fast retrieval of values based on keys.
Hashmap uses a hashing function to map keys to indices in an array.
It allows for constant time complexity O(1) for insertion, deletion, and retrieval operations.
Example: HashMap<String, Integer> map = new HashMap<>(); map.put("key", 123); int value = map.get("key");
Nothing it went well
Same here , asked basics of java and C#
posted on 5 Jan 2025
60 MCQ questions are there
Array list is faster for accessing elements by index, while Linked List is better for frequent insertions and deletions.
Array list has constant time access to elements by index, while Linked List requires traversing the list to find an element.
Linked List is better for frequent insertions and deletions as it only requires changing pointers, while Array list may require shifting elements.
Array list uses contiguous memor...
posted on 28 Jun 2024
I applied via Job Fair and was interviewed in May 2024. There were 4 interview rounds.
About front end , html, css, reasoning,
posted on 26 Dec 2024
Interview experience
based on 2 reviews
Rating in categories
Senior Consultant
114
salaries
| ₹9.6 L/yr - ₹31 L/yr |
Consultant
73
salaries
| ₹6.1 L/yr - ₹22.2 L/yr |
Engineer
72
salaries
| ₹4 L/yr - ₹8.5 L/yr |
Senior Engineer
61
salaries
| ₹6.2 L/yr - ₹20.1 L/yr |
Lead Consultant
28
salaries
| ₹15.8 L/yr - ₹35.5 L/yr |
CtrlS
Sify Technologies
Tata Communications
Reliance Communications