Filter interviews by
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
No, COMMIT cannot be used in triggers.
COMMIT cannot be used in triggers as it can cause mutating table errors.
Triggers are automatically committed by the database after they are executed.
Using COMMIT in triggers can lead to data integrity issues and performance problems.
Use SQL query to find employees who were absent for 2 consecutive days.
Use a SQL query to join the employee table with the attendance table
Filter the results to only include employees who have consecutive absent days
Group the results by employee to identify those who were absent for 2 consecutive days
Varrays are fixed-size arrays while Nested Tables are dynamic arrays in PL/SQL.
Varrays have a maximum size specified at declaration, while Nested Tables can grow dynamically.
Varrays are stored in contiguous memory locations, while Nested Tables are stored in a separate table.
Varrays can be sparse, while Nested Tables are always dense.
Example: Varray - DECLARE TYPE phone_numbers IS VARRAY(3) OF VARCHAR2(15); Nested Tabl...
Top trending discussions
I applied via Other and was interviewed in Nov 2019. There were 5 interview rounds.
posted on 7 May 2017
I appeared for an interview in Jun 2016.
I appeared for an interview in Dec 2018.
I appeared for an interview before Oct 2020.
As a pricing manager, I would analyze market data, customer needs, and competitor pricing to develop an effective pricing strategy.
Conduct market research to understand customer willingness to pay and identify price sensitivity.
Analyze competitor pricing strategies to ensure competitive positioning; for example, if competitors offer discounts, consider a promotional strategy.
Utilize data analytics tools to forecast dem...
I appeared for an interview in Nov 2020.
I applied via Newspaper Ad and was interviewed before Apr 2021. There were 2 interview rounds.
I prioritize open communication, support, and proactive problem-solving to ensure the well-being of subordinates and satisfaction of customers.
Foster open communication: Regular one-on-one meetings to understand team concerns and feedback.
Provide training and development: Organize workshops to enhance skills, like customer service training for better client interactions.
Recognize achievements: Celebrate team successes ...
I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.
Node.js is a runtime environment that allows you to run JavaScript on the server side.
Node.js is built on Chrome's V8 JavaScript engine.
It uses an event-driven, non-blocking I/O model that makes it lightweight and efficient.
Node.js is commonly used for building server-side applications, APIs, and real-time applications.
It has a large ecosystem of libraries and frameworks, such as Express.js and Socket.io.
In Node.js, timers can be implemented using functions like setTimeout() and setInterval().
Use setTimeout() to execute a function once after a specified delay
Use setInterval() to execute a function repeatedly at a specified interval
Clear a timer using clearTimeout() or clearInterval()
Example: setTimeout(() => { console.log('Timer executed!'); }, 2000);
I applied via Recruitment Consultant and was interviewed in Jun 2021. There were 4 interview rounds.
based on 1 interview experience
Difficulty level
Duration
Change Manager
5
salaries
| ₹8.6 L/yr - ₹16 L/yr |
IT Developer
5
salaries
| ₹5.3 L/yr - ₹12 L/yr |
Reservation & Ticketing Officer
5
salaries
| ₹2.2 L/yr - ₹3.6 L/yr |
Sales Executive
4
salaries
| ₹9.9 L/yr - ₹15 L/yr |
IT Support Officer
4
salaries
| ₹5.4 L/yr - ₹12 L/yr |
InterGlobe Aviation
Air India
Spicejet
Air India Sats Airport Services