Flydubai Interview Questions and Answers

Q1. Basic HR questions
Add your answer

Q1. Do you work on Performance Tuning?
Add your answer
Q2. What are the index and types?
Add your answer
Q3. Define B-Tree Indexes and Bit Map Indexes.
Add your answer
Q4. Which index is preferred for OLAP and OLTP.
Add your answer
Q5. What are the collections?
Add your answer
Q6. Can we give null value to a Primary Key?
Add your answer
Q7. What arer the analytical functions. Given a query to get a desired output.
Add your answer
Q8. What are the Compound Triggers?
Add your answer
Q9. Do you know about mataerialized views? difference between View?
Add your answer
Q10. Can we update a View?
Add your answer
Q11. What is the output of select * from emp where rownum between 3 and 10; (where max 5 columns are there.)
Add your answer
Q12. Insert, roolback, update basic queries.
Add your answer

Q1. Top 3rd salary from Employee table
Add your answer
Q2. About Partitioning, Range Partitioning
Add your answer
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.
Answered by AI
Add your answer
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
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer

Q1. Previous work related questions
Add your answer

Numerical, Arithmetic, Graphical, comprehensive

Q1. Telling about self and achievements
Add your answer

Q1. Regular HR interview
Add your answer