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

 Application Architect

 (1)

 Junior Data Analyst

 (1)

 Plsql Developer

 (1)

 Senior Plsql Developer

 (1)

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.

Round 1 - Technical 

(5 Questions)

  • Q1. Can you describe your role and responsibilities in your last organization?
  • Q2. What is the difference between a language copy and a live copy?
  • Q3. What is the process for creating workflows?
  • Q4. What are dam renditions?
  • Q5. What is the difference between experience fragments and content fragments?
Round 2 - One-on-one 

(4 Questions)

  • Q1. Introduce yourself.
  • Q2. What are all html5 tags
  • Q3. How to write a function in javascript given some scenario?
  • Q4. Asked something about the api
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Group Discussion 

Group discussion (GD) involves addressing a specific problem or situation collaboratively through discussion and problem-solving.

Round 2 - Group Discussion 

Group discussion (GD) entails tackling a specific issue or topic collaboratively.

Round 3 - Aptitude Test 

My attitude is typical.

Round 4 - Assignment 

My CV is attached for your review.

Round 5 - One-on-one 

(3 Questions)

  • Q1. What round are you referring to?
  • Q2. How many interview rounds are there?
  • Q3. Where it is running from
  • Ans. 

    The question is asking about the origin or starting point of something.

    • The question could be referring to the origin of a flight or transportation service.

    • It could also be asking about the source or starting point of a process or system.

    • Examples: 'Where is the flight running from?' or 'Where is the project running from?'

  • Answered by AI
Round 6 - HR 

(2 Questions)

  • Q1. Who can serve as an HR representative?
  • Ans. 

    An HR representative can be someone from the HR department or a designated employee trained in HR responsibilities.

    • HR department staff

    • Designated employee with HR training

    • External HR consultant

    • Manager with HR responsibilities

  • Answered by AI
  • Q2. How is the human resources department structured for the group?
  • Ans. 

    The human resources department is structured with specialized teams handling recruitment, training, employee relations, and benefits.

    • The human resources department is typically divided into teams such as recruitment, training and development, employee relations, and benefits administration.

    • Each team is responsible for specific functions within the HR department, such as sourcing and hiring new employees, providing trai...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - One-on-one 

(5 Questions)

  • Q1. I'm from Leh Ladakh
  • Q2. 32 YEARS experience security side
  • Q3. I'm Ex retired Capt Army
  • Q4. Qualifications 12th pass
  • Q5. Skill is Transport Supervisor, Men Management, good leadership, Security Officer,

Interview Preparation Tips

Interview preparation tips for other job seekers - Good
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Company Website and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Basic questions for .Net and stored procedure
  • Q2. Questions like functions and sp difference, solid principles etc.
Round 2 - Technical 

(1 Question)

  • Q1. Two programs based on hacker earth test.
Round 3 - Technical 

(5 Questions)

  • Q1. Use less questions based on 25 horses running a race ...
  • Q2. Question based on reverse a string
  • Q3. Question on git commands(who asks these)
  • Q4. Questions based on stack and heap memory
  • Q5. Questions on explaining useless unworthy questions having no relevance to any experience of work.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for useless questions which you have never prepared thinking with experience of 8+ years who will ask.they may surprise you
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

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is the internal implementation of Hashing and what is collision?
  • Ans. 

    Hashing is a technique used to map data to a fixed-size array, collision occurs when two different inputs produce the same hash value.

    • Hashing involves using a hash function to map data to a fixed-size array.

    • Collision happens when two different inputs produce the same hash value.

    • Common techniques to handle collisions include chaining and open addressing.

  • Answered by AI
  • Q2. Is time complexity of HashMap always O(1) ?
  • Ans. 

    No, time complexity of HashMap is not always O(1).

    • Time complexity of HashMap is O(1) on average, but can degrade to O(n) in worst case scenarios.

    • Worst case scenarios include hash collisions, which can lead to linear probing and degrade performance.

    • Load factor and capacity of the HashMap can also affect time complexity.

    • In scenarios where many keys hash to the same index, the time complexity can degrade.

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

(1 Question)

  • Q1. Yet to have the interview. Ambition box is forcefully making me enter these details

Skills evaluated in this interview

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 in last 1 year

Interview experience

4
  
Good

People are getting interviews through

based on 4 Flydubai interviews
Company Website
Job Portal
Referral
25%
25%
25%
25% candidates got the interview through other sources.
Moderate Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates

Interview Questions from Similar Companies

Air India Interview Questions
3.8
 • 164 Interviews
Spicejet Interview Questions
3.6
 • 91 Interviews
Boeing Interview Questions
3.9
 • 81 Interviews
Go First Interview Questions
3.7
 • 46 Interviews
AirAsia Interview Questions
3.6
 • 31 Interviews
Jet Airways Interview Questions
4.6
 • 24 Interviews
Alliance Air Interview Questions
3.3
 • 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 & Benefits

4.4

Job Security

4.3

Company culture

3.2

Promotions/Appraisal

4.0

Work Satisfaction

Explore 20 Reviews and Ratings
IT Developer
6 salaries
unlock blur

₹7.5 L/yr - ₹12 L/yr

Change Manager
5 salaries
unlock blur

₹5 L/yr - ₹16 L/yr

Reservation & Ticketing Officer
5 salaries
unlock blur

₹2.2 L/yr - ₹3.6 L/yr

IT Support Officer
5 salaries
unlock blur

₹8 L/yr - ₹9.7 L/yr

Sales Executive
4 salaries
unlock blur

₹12.6 L/yr - ₹15 L/yr

Explore more salaries
Compare Flydubai with

InterGlobe Aviation

3.6
Compare

Spicejet

3.6
Compare

Air India

3.8
Compare

Go First

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview