Filter interviews by
I appeared for an interview in Feb 2024.
Yes, views can be updated in SQL.
Views can be updated in SQL by using the CREATE OR REPLACE VIEW statement.
The data in the underlying tables will be affected when the view is updated.
Views can be updated to include new columns or filter criteria.
Example: CREATE OR REPLACE VIEW my_view AS SELECT * FROM my_table WHERE column = 'value';
Types of triggers include DML triggers, DDL triggers, and logon triggers.
DML triggers are fired in response to data manipulation language (DML) events like INSERT, UPDATE, DELETE.
DDL triggers are fired in response to data definition language (DDL) events like CREATE, ALTER, DROP.
Logon triggers are fired in response to a LOGON event.
INSTEAD OF triggers are used to perform an action instead of the triggering action.
Views can improve query performance by simplifying complex queries and reducing the need for redundant code.
Views can store complex queries and calculations, allowing for easier access and reuse of data.
Views can help optimize performance by pre-aggregating data or joining tables in advance.
Views can reduce the need for writing repetitive code by encapsulating common logic.
However, views can also introduce overhead if ...
Using sp_ prefix for stored procedures can cause performance issues and conflicts with system procedures.
sp_ prefix is reserved for system stored procedures in SQL Server, so using it for user-defined procedures can lead to conflicts.
Using sp_ prefix can cause unnecessary overhead as SQL Server first searches in the master database for system procedures before looking in the user database.
Avoiding sp_ prefix can improv...
I manage daily tasks by prioritizing sprint tasks and addressing user issues promptly.
Prioritize sprint tasks based on deadlines and importance
Communicate with team members to ensure tasks are on track
Address user issues promptly to maintain system functionality
Use project management tools like Jira to track progress
A closure is a function that has access to its own scope, the scope in which it was defined, and the global scope.
A closure is created when a function is defined inside another function.
The inner function has access to the variables and parameters of the outer function, even after the outer function has finished executing.
Closures are useful for creating private variables and functions in JavaScript.
They can also be us...
Encapsulation is the process of hiding internal details and providing a public interface for accessing and manipulating data.
Encapsulation bundles data and methods together into a single unit.
It helps in achieving data abstraction and data hiding.
By encapsulating data, we can control access to it and prevent unauthorized modifications.
Encapsulation promotes code reusability and maintainability.
Example: A class in objec...
Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.
Inheritance allows for code reuse and promotes the concept of hierarchy.
The class that is being inherited from is called the superclass or base class.
The class that inherits from the superclass is called the subclass or derived class.
The subclass can access the public and protected members of the s...
Abstraction is the process of simplifying complex systems by focusing on essential details.
Abstraction involves hiding unnecessary details and exposing only relevant information.
It allows developers to create models or representations that capture the essential aspects of a system.
Abstraction helps in managing complexity, improving code reusability, and enhancing maintainability.
For example, in object-oriented programm...
Polymorphism is the ability of an object to take on many forms. It allows objects of different classes to be treated as the same type.
Polymorphism is a fundamental concept in object-oriented programming.
It enables code reusability and flexibility.
Polymorphism can be achieved through method overriding and method overloading.
Example: A parent class Animal can have multiple child classes like Dog, Cat, and Bird. They can ...
posted on 3 Apr 2024
I applied via Walk-in and was interviewed before Apr 2023. There were 3 interview rounds.
Aptitude and coding questions both were included
Javascript has various data types including string, number, boolean, object, array, null, and undefined.
Data types in Javascript include string, number, boolean, object, array, null, and undefined.
Strings are sequences of characters enclosed in quotes.
Numbers can be integers or floating-point numbers.
Booleans represent true or false values.
Objects are collections of key-value pairs.
Arrays are ordered collections of val...
let is block scoped while var is function scoped in JavaScript.
let was introduced in ES6 while var has been around since the beginning of JavaScript.
Variables declared with let are only accessible within the block they are declared in.
Variables declared with var are accessible throughout the function they are declared in.
Using let can help prevent variable hoisting issues.
let is preferred over var for variable declarat
posted on 1 Nov 2024
I applied via Naukri.com and was interviewed before Nov 2023. There were 3 interview rounds.
Basic Questions like rev string, Palindrome, Pattern
General Topics like OTT VS Theaters
posted on 2 May 2024
I applied via Walk-in and was interviewed in Apr 2024. There were 4 interview rounds.
Nice,,,i like the interview process...
I like the interview process...
Nice i like the interview process...
..
I applied via Recruitment Consultant and was interviewed in May 2021. There were 5 interview rounds.
Explaining the differences between const and var, their accessibility, and other related concepts.
const is a keyword used to declare a variable that cannot be reassigned.
var is a keyword used to declare a variable with function scope.
let is a keyword used to declare a variable with block scope.
Accessibility refers to the scope of a variable and where it can be accessed from.
Other related concepts include hoisting, clos
An entity is a thing or object in the real world that can be distinctly identified.
Entities can be people, places, objects, events, or concepts.
In software engineering, an entity refers to a data object or a class that represents a real-world entity.
For example, in a database, a 'Customer' entity may have attributes like name, address, and phone number.
Questions of quant and coding
Program to find duplicate strings in an array
Iterate through the array and store each string in a HashSet
If a string is already in the HashSet, it is a duplicate
Return a list of all duplicate strings found
I applied via Walk-in and was interviewed in May 2021. There were 4 interview rounds.
based on 1 interview
Interview experience
Associate Project Manager
839
salaries
| ₹3.8 L/yr - ₹9 L/yr |
Senior Project Coordinator
238
salaries
| ₹3 L/yr - ₹6.5 L/yr |
Project Manager
206
salaries
| ₹4.1 L/yr - ₹14 L/yr |
Project Coordinator
101
salaries
| ₹2.2 L/yr - ₹5.5 L/yr |
Software Engineer
90
salaries
| ₹3 L/yr - ₹10 L/yr |
Aptara
MPS Limited
Crimson Interactive
Hurix Systems