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
Interview questions from similar companies
(2 Questions)
- Q1. There were questions of DSA, DBMS, OS etc
- Q2. There were questions around project that were mentioned in resume.
Interview Preparation Tips
pooja r
Selected
I applied via Campus Placement and was interviewed before May 2023. There were 2 interview rounds.
Medium to hard level questions were asked and that mostly covers basics of DSA
(1 Question)
- Q1. Oops ,DBMS and DSA logical questions
AYU
Very good coding test ques of linked list were asked
(1 Question)
- Q1. About my work experience & background
Harsh Yadav
Good questions like what is data science
What is python boss was a good
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in Feb 2023. There were 2 interview rounds.
(5 Questions)
- Q1. What is the reason for leaving?
- Q2. Would you like to rejoin if management recall you?
- Q3. Can you stay back if we assure you to hike your salary after 6 months?
- Ans. After six months is long time.
- Q4. Can you stay back if we Promote you in Next April?
- Ans. There is no promotion in 5.5 years hence, I can not wait for further 6 months.
- Q5. Is there any other problem from your Team Leader or HOD?
Interview Preparation Tips
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
Flydubai Interview FAQs
Tell us how to improve this page.
Flydubai Interviews By Designations
Interview Questions for Popular Designations
- Senior Executive Interview Questions
- Software Engineer Interview Questions
- Senior Associate Interview Questions
- Senior Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Accountant Interview Questions
- Test Engineer Interview Questions
- Show more
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
|  ₹0 L/yr - ₹0 L/yr |
|
Change Manager
5
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Reservation & Ticketing Officer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
|
IT Support Officer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Sales Executive
4
salaries
| ₹0 L/yr - ₹0 L/yr |
InterGlobe Aviation
Spicejet
Air India
Go First
- Home >
- Interviews >
- Flydubai Interview Questions
