Filter interviews by
Clear (1)
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
Top trending discussions
I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.
Puzzles, Psychometric Test
I appeared for an interview before Jun 2016.
I am a passionate software developer with 5 years of experience in web development and a strong background in computer science.
5 years of experience in web development
Strong background in computer science
Passionate about software development
To separate personal and professional calls, and to ensure availability and accessibility.
Separate personal and professional calls
Ensure availability and accessibility
Maintain work-life balance
Avoid mixing personal and work-related contacts
I appeared for an interview in Sep 2016.
I am a passionate software developer with experience in Java, Python, and web development.
Experienced in Java, Python, and web development technologies
Strong problem-solving skills and ability to work in a team
Completed multiple projects including a web-based inventory management system
I appeared for an interview in May 2017.
I appeared for an interview in Jun 2017.
I appeared for an interview in May 2017.
I appeared for an interview in Aug 2017.
I appeared for an interview before Aug 2016.
based on 1 interview
Interview experience
Associate Project Manager
712
salaries
| ₹3.8 L/yr - ₹9.2 L/yr |
Senior Project Coordinator
239
salaries
| ₹3 L/yr - ₹6.5 L/yr |
Project Manager
184
salaries
| ₹4.1 L/yr - ₹14 L/yr |
Project Coordinator
98
salaries
| ₹2.2 L/yr - ₹5.2 L/yr |
Software Engineer
90
salaries
| ₹3 L/yr - ₹10 L/yr |
Appen
TTEC India
Cognizant
Wipro