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
No Name
Selected
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
Array String Data strucure, pyhon, java
India vs pak , india vs russia
avi singh
(1 Question)
- Q1. AWS system design question
I applied via Recruitment Consulltant and was interviewed in Feb 2024. There was 1 interview round.
Write a simple algorithm for string manipulation
Simple string manipulation
(1 Question)
- Q1. Basic c# questions
(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.
- 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
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed before Aug 2023. There were 2 interview rounds.
(2 Questions)
- Q1. All about basic dsa
- Q2. Tech stack related what we mentioned in resume
(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.
- 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
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.
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
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
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
Go First
Calculate your in-hand salary
- Home >
- Interviews >
- Flydubai Interview Questions >
- Flydubai Senior Plsql Developer Interview Questions
