Filter interviews by
I was interviewed 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
Top trending discussions
I applied via Job Portal and was interviewed in Jul 2024. There was 1 interview round.
A pn junction diode is a semiconductor device that allows current to flow in one direction only.
Consists of p-type and n-type semiconductor materials
When forward biased, allows current to flow easily
When reverse biased, blocks current flow
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...
..
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 6 Jun 2024
30 min .. time, speed, distance
Normal easy qus via leetcode
posted on 23 Dec 2022
I applied via Walk-in and was interviewed in Nov 2022. There were 2 interview rounds.
All MCQ questions 2hrs time , difficulty easy-medium then coding will be asked
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
based on 1 interview
Interview experience
Associate Project Manager
709
salaries
| ₹3.8 L/yr - ₹9 L/yr |
Senior Project Coordinator
225
salaries
| ₹3 L/yr - ₹6.5 L/yr |
Project Manager
195
salaries
| ₹4.1 L/yr - ₹13.1 L/yr |
Project Coordinator
100
salaries
| ₹2.2 L/yr - ₹5.2 L/yr |
Software Engineer
91
salaries
| ₹3 L/yr - ₹10 L/yr |
TTEC India
Cognizant
Wipro
Accenture