Upload Button Icon Add office photos

Flydubai

Compare button icon Compare button icon Compare

Filter interviews by

Flydubai Senior Plsql Developer Interview Questions and Answers

Updated 11 Dec 2024

Flydubai Senior Plsql Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. Top 3rd salary from Employee table
  • Q2. About Partitioning, Range Partitioning
  • Q3. Can we use commit in Triggers
  • Ans. 

    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.

  • Answered by AI
  • Q4. Find the employee for 2 consecutive days absent
  • Ans. 

    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

  • Answered by AI
  • Q5. Difference between Varray and Nested Tables
  • Ans. 

    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...

  • Answered by AI

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
1w (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about Flydubai?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Other and was interviewed in Nov 2019. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Written test , objective + two programs to write
  • Q2. Question on linked list , stack

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well and be confident while answering

Senior Plsql Developer Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Did you ever work on query tuning and optimization? What do you s ... read more
asked in LTIMindtree
Q2. How can I write an anonymous block to add a column to a table tha ... read more
Q3. How do you write a package? What is the syntax for creating a pac ... read more
Q4. Difference between PK & UK. How many Nulls are allowed for UK
asked in Deloitte
Q5. How do you debug a procedure that has a nested procedure in it?

I appeared for an interview in Jun 2016.

Interview Preparation Tips

Round: Resume Shortlist
Tips: 1.Keep you resume simple and use the right keywords
2.Name your resume.
3.Use appropriate headings.
4. Only provide those details which is required for the job.

Round: Technical Interview
Tips: 1. Be specific while giving any answer.
2. Take your time to answer.
3. Be consice.
4.Be strong in the basics.



Skills: Leadership Skills, Problem Solving Abilties, Communication skills
College Name: Maharaja Surajmal Institute of Technology

I appeared for an interview in Dec 2018.

Interview Questionnaire 

3 Questions

  • Q1. Hindi mideeyam me
  • Q2. Compuret ves
  • Q3. Gk

Interview Preparation Tips

Round: Resume Shortlist
Experience: resume

Round: Test
Experience: test in hindi

General Tips: computer bes par and samanya gyan
Skills: Basics Of Computer Science
Duration: 1-4 weeks

I appeared for an interview before Oct 2020.

Interview Questionnaire 

1 Question

  • Q1. Regarding the fuel mixturrr ratio

Interview Preparation Tips

Interview preparation tips for other job seekers - I had given them a answer but they rejected it but it went well

Interview Questionnaire 

2 Questions

  • Q1. Tell about yourself
  • Q2. They had given a case and if you are position of pricing manager how do you resolve.
  • Ans. 

    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...

  • Answered by AI

I appeared for an interview in Nov 2020.

Interview Questionnaire 

1 Question

  • Q1. Job profile Question. Managerial skill question. Basic Engineering question.

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic engineering concept.
Application software know how knowledge.
Are these interview questions helpful?

I applied via Newspaper Ad and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. How will you take care of subbordnates & customers
  • Ans. 

    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 ...

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. Standing instructions company policies etc
  • Ans. All the facts & figure of Company
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Your Answer should lead to next Question you are prepared
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Node js working in detail
  • Ans. 

    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.

  • Answered by AI
  • Q2. Timer working in node
  • Ans. 

    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);

  • Answered by AI
Round 2 - Behavioral 

(2 Questions)

  • Q1. HLD questions on db and backend
  • Q2. Relational non relational db

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Jun 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Java Basics, oops concept, collections, error handling, springboot architecture, springboot annotations, microservices architecture, pros and cons of microservices, structural questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be cool, answers all the questions with smile. Give the interviewer the confidence that you can perform your job well.

Flydubai Interview FAQs

How many rounds are there in Flydubai Senior Plsql Developer interview?
Flydubai interview process usually has 1 rounds. The most common rounds in the Flydubai interview process are Technical.
What are the top questions asked in Flydubai Senior Plsql Developer interview?

Some of the top questions asked at the Flydubai Senior Plsql Developer interview -

  1. find the employee for 2 consecutive days abs...read more
  2. Difference between Varray and Nested Tab...read more
  3. Can we use commit in Trigg...read more

Tell us how to improve this page.

Overall Interview Experience Rating

5/5

based on 1 interview experience

Difficulty level

Easy 100%

Duration

Less than 2 weeks 100%
View more

Interview Questions from Similar Companies

Air India Interview Questions
3.5
 • 166 Interviews
Spicejet Interview Questions
3.6
 • 94 Interviews
Boeing Interview Questions
3.9
 • 91 Interviews
Qatar Airways Interview Questions
3.8
 • 60 Interviews
Go First Interview Questions
3.8
 • 49 Interviews
AirAsia Interview Questions
3.6
 • 30 Interviews
British Airways Interview Questions
3.0
 • 29 Interviews
View all
Change Manager
5 salaries
unlock blur

₹8.6 L/yr - ₹16 L/yr

IT Developer
5 salaries
unlock blur

₹5.3 L/yr - ₹12 L/yr

Reservation & Ticketing Officer
5 salaries
unlock blur

₹2.2 L/yr - ₹3.6 L/yr

Sales Executive
4 salaries
unlock blur

₹9.9 L/yr - ₹15 L/yr

IT Support Officer
4 salaries
unlock blur

₹5.4 L/yr - ₹12 L/yr

Explore more salaries
Compare Flydubai with

InterGlobe Aviation

3.5
Compare

Air India

3.5
Compare

Spicejet

3.6
Compare

Air India Sats Airport Services

3.6
Compare
write
Share an Interview