Upload Button Icon Add office photos

Filter interviews by

Flydubai Interview Questions and Answers

Updated 11 Dec 2024

Flydubai Interview Experiences

Popular Designations

4 interviews found

Plsql Developer Interview Questions & Answers

user image mohammed danish

posted on 7 Dec 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Job Portal and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Basic HR questions
Round 2 - Technical 

(12 Questions)

  • Q1. Do you work on Performance Tuning?
  • Q2. What are the index and types?
  • Q3. Define B-Tree Indexes and Bit Map Indexes.
  • Q4. Which index is preferred for OLAP and OLTP.
  • Q5. What are the collections?
  • Q6. Can we give null value to a Primary Key?
  • Q7. What arer the analytical functions. Given a query to get a desired output.
  • Q8. What are the Compound Triggers?
  • Q9. Do you know about mataerialized views? difference between View?
  • Q10. Can we update a View?
  • Q11. What is the output of select * from emp where rownum between 3 and 10; (where max 5 columns are there.)
  • Q12. Insert, roolback, update basic queries.

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on Analytical functions, and basic but tricky queries.

Plsql Developer Interview Questions asked at other Companies

Q1. What is procedure in plsql and it's syntax and difference between procedure and function?
View answer (7)
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

Senior Plsql Developer Interview Questions asked at other Companies

Q1. Did you ever work on query tuning and optimization? What do you see in explain plan?
View answer (1)
Interview experience
3
Average
Difficulty level
Hard
Process Duration
-
Result
Not Selected

I applied via Company Website and was interviewed in Sep 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Previous work related questions

Junior Data Analyst Interview Questions asked at other Companies

Q1. What is the main difference between data mining and data analysis?
View answer (4)

I applied via Referral

Round 1 - Aptitude Test 

Numerical, Arithmetic, Graphical, comprehensive

Round 2 - Video Synthesis 

(1 Question)

  • Q1. Telling about self and achievements
Round 3 - HR 

(1 Question)

  • Q1. Regular HR interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Be better prepared with aptitude test and for the video snip share you need to prepare and byheart your answers already and then record them as to what were you doing in your previous company and what can you do for the current company

Application Architect Interview Questions asked at other Companies

Q1. How Single Sign On (SSO) gets configured?
View answer (1)

Flydubai interview questions for popular designations

 Senior Plsql Developer

 (1)

 Plsql Developer

 (1)

 Application Architect

 (1)

 Junior Data Analyst

 (1)

Interview questions from similar companies

I was interviewed 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.

Interview Questionnaire 

2 Questions

  • Q1. Tell about yourself
  • Ans. 

    I am a business analyst with experience in data analysis, process improvement, and project management.

    • Experienced in data analysis using tools like Excel, SQL, and Tableau

    • Skilled in process improvement and optimization

    • Proficient in project management and stakeholder communication

    • Strong analytical and problem-solving skills

    • Excellent communication and interpersonal skills

  • Answered by AI
  • Q2. They had given a case and if you are position of pricing manager how do you resolve.

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

I was interviewed 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

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. At your level motivate subordinates and in turn they will serve Customers with a smile
  • Answered Anonymously
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

I was interviewed 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

Flydubai Interview FAQs

How many rounds are there in Flydubai interview?
Flydubai interview process usually has 1-2 rounds. The most common rounds in the Flydubai interview process are Technical, HR and Aptitude Test.
What are the top questions asked in Flydubai interview?

Some of the top questions asked at the Flydubai 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.

Flydubai Interview Process

based on 3 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Air India Interview Questions
3.7
 • 150 Interviews
Spicejet Interview Questions
3.6
 • 86 Interviews
Boeing Interview Questions
3.9
 • 85 Interviews
Qatar Airways Interview Questions
3.9
 • 55 Interviews
Go First Interview Questions
3.7
 • 46 Interviews
AirAsia Interview Questions
3.6
 • 29 Interviews
Jet Airways Interview Questions
4.6
 • 21 Interviews
Alliance Air Interview Questions
3.0
 • 2 Interviews
View all

Flydubai Reviews and Ratings

based on 20 reviews

4.7/5

Rating in categories

4.0

Skill development

3.9

Work-life balance

3.9

Salary

4.4

Job security

4.3

Company culture

3.2

Promotions

4.0

Work satisfaction

Explore 20 Reviews and Ratings
IT Developer
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Change Manager
5 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Reservation & Ticketing Officer
5 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

IT Support Officer
5 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Executive
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Flydubai with

InterGlobe Aviation

3.6
Compare

Spicejet

3.6
Compare

Air India

3.7
Compare

Go First

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview