AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Flydubai Interview Questions and Answers
Flydubai Interview Experiences
4 interviews found
mohammed danish
I applied via Job Portal and was interviewed in Nov 2024. There were 2 interview rounds.
(1 Question)
- Q1. Basic HR questions
(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
Plsql Developer Interview Questions asked at other Companies
Anonymous
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
(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.
- 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
- 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...
Skills evaluated in this interview
Senior Plsql Developer Interview Questions asked at other Companies
I applied via Company Website and was interviewed in Sep 2023. There was 1 interview round.
(1 Question)
- Q1. Previous work related questions
Junior Data Analyst Interview Questions asked at other Companies
I applied via Referral
Numerical, Arithmetic, Graphical, comprehensive
(1 Question)
- Q1. Telling about self and achievements
(1 Question)
- Q1. Regular HR interview
Interview Preparation Tips
Application Architect Interview Questions asked at other Companies
Flydubai interview questions for popular designations
Top trending discussions
Interview questions from similar companies
Intern Interview Questions & Answers
Airports Authority of India
KRISHNABIR SINGH
posted on 7 May 2017
I appeared for an interview in Jun 2016.
Interview Preparation Tips
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
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 in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Job profile Question. Managerial skill question. Basic Engineering question.
Interview Preparation Tips
Application software know how knowledge.
S M
I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.
(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.
- 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);
(2 Questions)
- Q1. HLD questions on db and backend
- Q2. Relational non relational db
Skills evaluated in this interview
Simple string manipulation
(1 Question)
- Q1. Basic c# questions
Selected
I applied via Referral and was interviewed before Apr 2023. There were 3 interview rounds.
MCQ on Python and some aptitude questions.
(1 Question)
- Q1. Array rotation coding question followed by past project experience
(1 Question)
- Q1. STAR type interview.
Flydubai Interview FAQs
Tell us how to improve this page.
Flydubai Interviews By Designations
Interview Questions for Popular Designations
Flydubai Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Flydubai Reviews and Ratings
based on 21 reviews
Rating in categories
|
IT Developer
6
salaries
|  ₹7.5 L/yr - ₹12 L/yr |
|
Change Manager
5
salaries
| ₹5 L/yr - ₹16 L/yr |
|
Reservation & Ticketing Officer
5
salaries
| ₹2.2 L/yr - ₹3.6 L/yr |
|
IT Support Officer
5
salaries
| ₹8 L/yr - ₹9.7 L/yr |
|
Sales Executive
4
salaries
| ₹12.6 L/yr - ₹15 L/yr |
InterGlobe Aviation
Air India
Spicejet
Air India Sats Airport Services
- Home >
- Interviews >
- Flydubai Interview Questions
