Upload Button Icon Add office photos

Filter interviews by

Flydubai Plsql Developer Interview Questions and Answers

Updated 7 Dec 2024

Flydubai Plsql Developer Interview Experiences

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

Interview questions from similar companies

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.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Coding Test 

Write a simple algorithm for string manipulation

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is gcd? And explain it
  • Ans. 

    gcd stands for greatest common divisor, the largest positive integer that divides two or more numbers without leaving a remainder.

    • gcd is used to find the largest integer that can evenly divide two or more numbers.

    • It is commonly used in mathematics and computer science algorithms.

    • For example, the gcd of 12 and 18 is 6, as 6 is the largest number that can divide both 12 and 18 without leaving a remainder.

  • Answered by AI
  • Q2. What is arc and explain it
  • Ans. 

    ARC stands for Automatic Reference Counting, a memory management technique used in programming languages like Objective-C and Swift.

    • ARC automatically tracks and manages the memory used by objects in a program

    • It increases the retain count of an object when it is referenced and decreases it when it is no longer needed

    • ARC helps prevent memory leaks and retain cycles in iOS and macOS development

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Read react native basics

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. All about basic dsa
  • Q2. Tech stack related what we mentioned in resume
Round 2 - HR 

(2 Questions)

  • Q1. Challenge's we faced ?
  • Ans. 

    Some challenges we faced included tight deadlines, changing requirements, and technical limitations.

    • Tight deadlines required us to work efficiently and prioritize tasks.

    • Changing requirements meant we had to adapt quickly and communicate effectively with stakeholders.

    • Technical limitations forced us to find creative solutions and workarounds to achieve our goals.

  • Answered by AI
  • Q2. How to overcome challenges?
  • Ans. 

    To overcome challenges, I break them down into smaller tasks, seek help from colleagues, stay organized, and stay persistent.

    • Break down the challenge into smaller tasks to make it more manageable

    • Seek help from colleagues or mentors for advice and support

    • Stay organized by creating a plan or timeline to track progress

    • Stay persistent and motivated, even when facing setbacks

  • Answered by AI

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.
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
-
Result
No response
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. FHA is performed
  • Q2. Flow of requirements tight from beginning
  • Ans. 

    Flow of requirements should be tight from the beginning to ensure project success.

    • Establish clear and specific requirements from stakeholders

    • Document requirements in a detailed manner

    • Regularly review and update requirements as needed

    • Ensure all team members understand and agree on requirements

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Simple string manipulation

Round 2 - Technical 

(1 Question)

  • Q1. Basic c# questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - Coding Test 

MCQ on Python and some aptitude questions.

Round 2 - Technical 

(1 Question)

  • Q1. Array rotation coding question followed by past project experience
Round 3 - HR 

(1 Question)

  • Q1. STAR type interview.

I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.

Round 1 - One-on-one 

(3 Questions)

  • Q1. The interview questions are completely project based.
  • Q2. The intervierws arw very friendly. If you get stuck they give you some hints which you can catch and complete the answer
  • Q3. Be genuine and tell them the teuth that you dont know the answer or cant recollect it as of now

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn your project well. Be simple and specific

Flydubai Interview FAQs

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

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

  1. what is the output of select * from emp where rownum between 3 and 10; (where m...read more
  2. What arer the analytical functions. Given a query to get a desired outp...read more
  3. Do you know about mataerialized views? difference between Vi...read more

Tell us how to improve this page.

Flydubai Plsql Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Air India Interview Questions
3.7
 • 152 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
View all
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

Air India

3.7
Compare

Spicejet

3.6
Compare

Air India Sats Airport Services

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