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
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. At your level motivate subordinates and in turn they will serve Customers with a smile
(1 Question)
- Q1. Standing instructions company policies etc
- Ans. All the facts & figure of Company
Interview Preparation Tips
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.
I appeared for an interview before Oct 2020.
Interview Questionnaire
1 Question
- Q1. Regarding the fuel mixturrr ratio
Interview Preparation Tips
I applied via Company Website and was interviewed before Aug 2021. There were 3 interview rounds.
(6 Questions)
- Q1. App se koi ghuse me bat karta hai to kya karegi
- Q2. App ko koi jyda selery dega to app job choregi ya nhi
- Ans. Sir me job to nhi chorungi q ki ye mera mn lyak kam.hai jisme mn lge ohi kam karna chiye
- Q3. App tecket executive q karna chati hai
- Q4. Q sir me isme mhir hu or me achhe se kar leti hu
- Q5. App se koi staff batimiji se bat karta hai to kya karegi
- Q6. Me use achhe se bat karungi
Jyoti singh vill eksar post eksar
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
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
- Plsql Developer Interview Questions
- Software Developer Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- Java Developer Interview Questions
- Senior Software Developer Interview Questions
- Full Stack Developer Interview Questions
- Application Developer Interview Questions
- DOT NET Developer Interview Questions
- Show more
Flydubai Senior Plsql Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
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
Spicejet
Air India Sats Airport Services
Boeing
- Home >
- Interviews >
- Flydubai Interview Questions >
- Flydubai Senior Plsql Developer Interview Questions
