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
Top trending discussions
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
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,
let, var, and const are keywords used in JavaScript to declare variables with different scopes and mutability.
let is used to declare variables with block scope and allows reassignment
var is used to declare variables with function scope and allows redeclaration
const is used to declare variables with block scope and does not allow reassignment, but the value can still be mutable
Angular is a popular open-source front-end web application framework developed by Google.
Angular is used for building dynamic web applications.
It allows for the creation of single-page applications.
Angular uses TypeScript for building applications.
It provides features like data binding, dependency injection, and routing.
Angular has a large community and ecosystem of libraries and tools.
Examples: AngularJS, Angular 2, A...
Services in Angular are singleton objects that can be used to share data and functionality across components.
Services are used to encapsulate reusable functionality, such as data fetching, logging, or authentication.
Services can be injected into components, directives, or other services using Angular's dependency injection system.
Services are typically defined using the @Injectable decorator.
Example: A DataService serv...
posted on 26 Dec 2024
Angular is a popular open-source front-end web application framework developed by Google.
Angular is used for building dynamic web applications.
It allows for the creation of single-page applications.
Angular uses TypeScript for building applications.
It provides features like data binding, dependency injection, and routing.
Angular has a large community and ecosystem with many libraries and tools available.
Angular is a popular open-source web application framework developed by Google.
Angular is used for building dynamic web applications.
It allows for the creation of single-page applications.
Angular uses TypeScript for building applications.
It provides features like data binding, dependency injection, and routing.
Angular has a large community and ecosystem with many libraries and tools available.
posted on 28 Sep 2023
I applied via Job Portal
Binary search is a divide and conquer algorithm that efficiently finds the target value within a sorted array.
Start by defining the low and high indices of the array.
Calculate the middle index and compare the target value with the middle element.
If the target value is less than the middle element, search the left subarray. If greater, search the right subarray.
Repeat the process until the target value is found or the s
CI/CD flow stands for Continuous Integration/Continuous Deployment flow, which is a software development practice where code changes are automatically built, tested, and deployed.
CI/CD flow involves automating the process of integrating code changes into a shared repository, running automated tests, and deploying the changes to production.
Continuous Integration (CI) focuses on automating the build and testing of code c...
Enums are a feature in programming languages that allow you to define a set of named constants.
Enums can be used to improve code readability by giving meaningful names to values
Enums can be used in switch statements to handle different cases
Enums can have associated values or raw values for more flexibility
Yes, Singleton handles synchronization by ensuring only one instance of a class is created and providing global access to that instance.
Singleton pattern restricts the instantiation of a class to one object.
It provides a global point of access to the instance.
Synchronization can be implemented in the Singleton pattern to ensure thread safety.
Example: Singleton pattern is commonly used in database connections to ensure
External libraries are pre-written code that can be imported and used in a project to provide additional functionality.
External libraries help in reducing development time by providing ready-made solutions for common tasks.
Examples include React for front-end development, NumPy for scientific computing in Python, and Retrofit for making network calls in Android apps.
based on 2 reviews
Rating in categories
Senior Consultant
113
salaries
| ₹9.6 L/yr - ₹31 L/yr |
Engineer
76
salaries
| ₹4 L/yr - ₹8.5 L/yr |
Consultant
72
salaries
| ₹6.1 L/yr - ₹22.2 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