Filter interviews by
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization is used to eliminate data redundancy by breaking up tables into smaller, related tables.
It helps in reducing data anomalies such as update anomalies, insert anomalies, and delete anomalies.
There are different levels of normalization - 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules t...
Top trending discussions
Temp data is used to store data for a single request, while view data is used to pass data between controller and view.
Temp data is used to store data for a single request and is accessible only in the current request.
View data is used to pass data between controller and view and is accessible in the current request and the subsequent request.
Temp data is typically used for passing error messages or status messages bet...
Object-oriented programming paradigm that focuses on objects and classes
Encapsulation: bundling data and methods that operate on the data into a single unit
Inheritance: ability of a class to inherit properties and behavior from another class
Polymorphism: ability to present the same interface for different data types
Abstraction: hiding the complex implementation details and showing only the necessary features
MVC architecture is a software design pattern that separates an application into three main components: Model, View, and Controller.
Model: Represents the data and business logic of the application
View: Represents the UI components of the application
Controller: Acts as an intermediary between Model and View, handling user input and updating the Model accordingly
A project plan is a detailed document that outlines the scope, objectives, timeline, resources, and deliverables of a project.
Defines project scope and objectives
Outlines timeline and milestones
Identifies resources needed
Specifies deliverables and success criteria
Helps in tracking progress and managing risks
I was interviewed in Jun 2024.
Union combines and removes duplicates, Union all combines without removing duplicates.
Union is used to combine the result sets of two or more SELECT statements and removes duplicates.
Union all is used to combine the result sets of two or more SELECT statements without removing duplicates.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FRO
OLTP is for transaction processing, OLAP is for analytical processing.
OLTP stands for Online Transaction Processing, used for real-time transaction processing.
OLAP stands for Online Analytical Processing, used for complex queries and data analysis.
OLTP databases are normalized, while OLAP databases are denormalized.
OLTP systems are optimized for read and write operations, while OLAP systems are optimized for read-heavy...
Senior Recruitment Associate
262
salaries
| ₹3 L/yr - ₹8 L/yr |
Recruitment Associate
136
salaries
| ₹2.5 L/yr - ₹5.2 L/yr |
Recruitment Specialist
118
salaries
| ₹3.8 L/yr - ₹10.6 L/yr |
Payroll Specialist
92
salaries
| ₹2 L/yr - ₹7 L/yr |
Principal Consultant
73
salaries
| ₹3.5 L/yr - ₹11 L/yr |
Keka HR Payroll Software
Darwinbox
SAP
Ramco Systems