AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Flydubai Senior Plsql Developer Interview Questions and Answers
Flydubai Senior Plsql Developer Interview Experiences
1 interview found
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
Top trending discussions
Interview questions from similar companies
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
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 applied via Newspaper Ad and was interviewed before Apr 2021. There were 2 interview rounds.
(1 Question)
- Q1. How will you take care of subbordnates & customers
- Ans.
I prioritize open communication, support, and proactive problem-solving to ensure the well-being of subordinates and satisfaction of customers.
Foster open communication: Regular one-on-one meetings to understand team concerns and feedback.
Provide training and development: Organize workshops to enhance skills, like customer service training for better client interactions.
Recognize achievements: Celebrate team successes ...
(1 Question)
- Q1. Standing instructions company policies etc
- Ans. All the facts & figure of Company
Interview Preparation Tips
I appeared for an interview before Oct 2020.
Interview Questionnaire
1 Question
- Q1. Regarding the fuel mixturrr ratio
Interview Preparation Tips
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
- Q2. They had given a case and if you are position of pricing manager how do you resolve.
- Ans.
As a pricing manager, I would analyze market data, customer needs, and competitor pricing to develop an effective pricing strategy.
Conduct market research to understand customer willingness to pay and identify price sensitivity.
Analyze competitor pricing strategies to ensure competitive positioning; for example, if competitors offer discounts, consider a promotional strategy.
Utilize data analytics tools to forecast dem...
(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
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
Flydubai Interview FAQs
Tell us how to improve this page.
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
|
Change Manager
5
salaries
|  ₹5 L/yr - ₹16 L/yr |
|
IT Developer
5
salaries
| ₹7.5 L/yr - ₹12 L/yr |
|
Reservation & Ticketing Officer
5
salaries
| ₹2.2 L/yr - ₹3.6 L/yr |
|
Sales Executive
4
salaries
| ₹12.6 L/yr - ₹15 L/yr |
|
IT Support Officer
4
salaries
| ₹9.7 L/yr - ₹12 L/yr |
InterGlobe Aviation
Air India
Spicejet
Air India Sats Airport Services
- Home >
- Interviews >
- Flydubai Interview Questions
