explain plan in oracle interview questions

Oracle PL SQL interview question Query was running fine yesterday but its very slow today | Tuning

Top 10 Frequently Asked Oracle Performance Tuning Interview Questions

Ans: Making optimal use of the system using existing resources is called performance tuning.

If you would like to become a professional and build a career in this domain, then visit Mindmajix – a global online training platform: Oracle Performance Tuning Training This course will help you to achieve excellence in this domain.

What are the different types of Tunings?


  • CPU Tuning
  • Memory Tuning
  • IO Tuning
  • Application Tuning
  • Database Tuning
  • PILOT INTERVIEW Questions And Answers! (How to PASS an Airline Pilot Interview)

    1. What is CRM process as Airline Pilot? The systematic and effective use of all available resources to ensure a desirable outcome and completion of the flight. Focusing on communication, teamwork, task allocation, decision-making and situational awareness. The major contributors in the CRM process are: Dispatchers, flight attendants, maintenance, ATC and of course the cockpit crew.

    2. What is the MAP on a non-precision approach? Non-precision: MAP is usually visually identified by a capitol and bold “M” in the Jepps or at the end of the solid line on NOS. There are several ways to id the MAP: Published DME at the MAP, Navaid such as the middle marker (MM), or timing from the FAF

    3. What is the importance of proficiency in several languages for a pilot? A private pilot may limit himself to knowledge of English good enough to understand control towers. Other pilots, being more publicly involved figures by necessity, greatly benefit from knowing more than one language.

    4. What is your Proudest accomplishment? Becoming a pilot and graduating from college as to be the biggest accomplish so far.

    5. What is the 1-2-3 rule? Requirements for filing an alternate. 1-2-3: 1hr before to 1hr after estimated time of arrival, the weather must be forecast to be 2000′ ceiling and 3SM vis.

    6. What makes a good captain or what do you expect from a Captain? one that is knowledgeable, decisive, conservative and safety conscious, good people skills, superior communication skills, solid piloting skills, can manage stress and avoid confrontation

    7. List your qualifications as a pilot? Besides relevant college degree(s), pilots graduate from flying school and participate in annual additional training.

    8. What is GRID MORA? It’s an altitude derived by Jepp or provided by state authorities. If derived by Jepp, Grid MORA clear all terrain and structures by 1000′ in areas where highest elevations are 5000′ MSL or lower. MORA values clear all terrain and structures by 2000′ in areas where highest elevations are 5001′ MSL or higher. Grid MORA (State) altitude supplied by the State Authority provides 2000′ clearance in mountainous areas and 1000′ in non-mountainous areas. Also… a +/- denote doubtful accuracy but are believed to provide sufficient reference point clearance.

    9. What is the definition of CRM? CRM is a system which allows optimum use of all available resources – equipment, procedures, interpersonal communication, team work – all to promote safety and enhance efficiency in operations

    10. What is Vso of your most recent aircraft? Cessna 172 is 41Kts

    11. What is the max distance from the runway if you were to circle to land? Depends on your speed

    12. Have you applied anywhere else? Just be honest on this one. If you are in the job hunt, it’s normal to apply to several companies. It’s great to tell them that Cathay is your top choice, but it would be suspect to say Cathay is your only choice.

    13. What is mach tuck? As the aircraft reaches critical mach the nose of the aircraft tends to pitch downwards due to the flow of air over the wing reaching supersonic speeds producing additional life and center of pressure moving rearward. As the center of pressure moves rearward the elevators become less effective, pushing the aircraft into a potentially unrecoverable dive.

    14. What is tower’s NORDO signal to be cleared to land? Steady green

    15. What is VMCG? minimum speed control in the ground

    16. What is the difference between Blue, Green Airports? blue is IFR (has approaches) green is VFR (no approaches)

    17. What is GRADIENT CLIMB? 3%

    18. What is VMCA? Minimun Speed Control in the Air

    19. What is windshear? its a change on direction and speed of the wind

    20. What is MOCA? Minimum Obstacle Clearance that provides obstable clearance between Vor airways. It also ensures VOR coverage 22nm from the nearest VOR

    21. What is hyperventilation? hyperventilation is when the body has too much Oxygen and not enough Co2

    22. Ever had an emergency? yes, many over the years

    23. Pilots have many simultaneous responsibilities during the flight. What can you tell me about this? Pilots navigate the flight, observe and direct the activities of the crew, check instruments, keep an eye on the weather, and monitor altitude and air traffic. Doing all these and more, often simultaneously, requires outstanding multi-tasking skills and power of concentration.

    24. What are the max airspeeds in C airspace? 200 KIAS within 4 NM of Primary Class C Airport

    25. How would you behave as the pilot of a plane during an emergency? Describe first what your emotional response would be. It is important to demonstrate, preferably through examples, that you can maintain your poise during such events, and that you possess enough presence of mind to activate emergency procedures and delegate duties among crew members as necessary.

    26. Where do you see yourself in 6 months? with your company

    27. Did you ever have to modify the flight course in the past? Pilots are able to modify the course in flight, if this is dictated by internal or external conditions. This is not a small responsibility and needs careful coordination with control towers and scrupulous attention to detail.

    28. What Is V2? takeoff safety speed

    29. What Is Max A/s In Class C? Airspeed maximum of 200 knots indicated within 4 nautical or 5 statute miles and 2500 feet above the ground of the primary airport.

    30. What Are The Cdi/raim Sensitivities Of A Gps Outside 30nm? Inside 30nm? +- 5 mi +- 1 mi

    31. What Is The Effect Of Aft Cg On Performance? rearward Cg gives better fuel efficiency

    32. What Is An Lda? a precision approach that is offset from the runway, it may have GS

    33. Where Is The Faf On A Vor/ils Approach? On a VOR approach, the FAP is whenever you are established on course inbound and the final decent may be started. For non-precision approaches, the FAF is the “Maltese Cross” and for precision, the arrow which identifies the GS intercept.

    34. Why Cape Air? big airline paneer

    35. What Kind Of Airspace Is Around Lax? Class B. Very congested airspace.

    36. What Is V1? Take off decision speed

    37. What is hypoxia? Lack of oxygen to body tissues

    38. Why do you like Compass? I like the new modern equipment and I like the fact that it’s got flow through to/ is part of Northwest.

    39. What is a squall line? It is a continuous narrow line active of thunderstorms ahead of cold front but can develop far removed of any front. May be too long to detour, too thick to penetrate. It forms very rapidly reach Max intensity in late afternoon or early evening. IT IS THE SINGLE MOST INTENSE WEATHER HAZARD FOR AIRCRAFT.

    40. Why do you want to work for Allegiant? growing company, day trips, upgrade potential

    41. Why Ameriflight? I’d like to fly cargo and gain the single-pilot IFR experience

    42. Did you ever have a problem with an F/O? Yes

    43. What is your clearance limit when cleared for the approach and then you loose coms? The published hold on the missed.

    44. What is MEA? Minimum En Route Altitude, lowest altitude on that airway that assures obstacle clearance and acceptable navigational reception.

    45. What is Definition of V2? Single engine climb speed until safe altitude or clear of obstacles

    46. What is Definition of V1? on a balance runway it is the last chance for you to decide not to go if you have and emergency and still stop on the runway according to the air data

    47. What is the definition of Hypoxia? Not enough Oxygen

    48. What is the seating capacity of the Dash 8 100 and 300 and how many flight attendants you need? DA-100 (37) DA-300 (50) FA 1

    49. Tell me the biggest factor as far as fuel conservation goes as it relates to a jet engine? TSFC thrust specific fuel consumption which directly inperpolates to power setting and altitude. Higher you climb the less fuel required. Throttle settings also have a say in conservation and relates more to maintenance issues which is why full throttle takeoffs are rarely done.

    50. What qualities make a good captain? Confident, Diligent, Good CRM skills, Good Problem Solver

    51. What’s your choice of base? PDX or Seattle

    52. World Airways Pilot Interview Questions:

  • Why World?
  • Why should we hire you?
  • What is the maximum take off weight of the aircraft I flew?
  • How did you get into an aviation career?
  • Tell me about a time that you made mistake in airplane? and what you learned from it.
  • Describe what a Captain is.
  • Do you want to be a Captain?
  • Do you mind being an FO for 5 years?
  • Was asked to grade my sim performance from the day before!
  • What engines are on the airplane you have been flying?
  • 53. Flight Express Airline Pilot Interview Questions:

  • Why you?
  • Are you sure this is what you want to do?
  • Tell me about yourself.
  • 54. Lion Air Airline Pilot Interview Questions:

  • What is Bernoulli law? how the aircraft can fly?
  • What is Newton’s Law?
  • What is ACN/PCN?
  • Know about Piston Engine
  • Loyalty to company
  • 55. LAN Airline Pilot Interview Questions:

  • Why do you want to become a pilot?
  • Why LAN Chile?
  • Where do you see yourself in 5 years?
  • Did you have any bad experience in the past?
  • What is your best quality?
  • What is your weakness?
  • What have you heard about LAN chile?
  • What would you do if you were on final and suddenly had an electrical fire in the cockpit?
  • What would you do if you were cruising and noticed that your captain was unconscious?
  • 56. Miami Air International Airline Pilot Interview Questions:

  • Tell something about your flying career.
  • What am I looking for in their company?
  • What is the dumbest thing you have done in an airplane?
  • What are you looking for in an airline?
  • Are you prepared for life at Miami Air Long days Away from home Pay 90 minute callout
  • Have you had any failed checkrides?
  • Have you had any traffic tickets?
  • Have you had a DUI?
  • Do you have a criminal record?
  • Do you have any accident s/ incidents on record?
  • 57. Mokulele Airlines Pilot Interview Questions:

  • Tell me about your previous work experience.
  • What are your strengths?
  • What is your weakness?
  • What has been your flying experience with the past 60 days?
  • What has been your flying experience with the past 30 days?
  • Why did you apply here?
  • Do you have any violations, incidents or accidents?
  • Do you have any weather experience?
  • 58. Ryan International Airlines Airline Pilot Interview Questions:

  • Why do you want to work with Ryan?
  • Describe your flying career.
  • What was your worst job?
  • What was your best job?
  • What would you do if the Captain smells like alcohol?
  • What would you do if the captain wants to continue below minimums?
  • What would you do if the captain wants to break a company rule?
  • Tell me a time you broke an FAR?
  • Tell me a time you had a conflict at work.
  • Approach lights for the cat 2 ILS: what do they look like and what do you need to see to continue?
  • 59. Seaborne Airlines Pilot Interview Questions:

  • What is your Total Flight Time?
  • What ratings do you have?
  • When did you fly last?
  • What is your total time in the last 6 months?
  • What is your total time in the last 12 months?
  • What class medical do you have?
  • When did you start flying?
  • Why did you start flying?
  • Wx goes below mins past the FAF, can you continue and when you would go missed.
  • Describe TDZE
  • 60. XOJET Airline Pilot Interview Questions:

  • Why XOJET?
  • Why not other companies like NetJets or Flextjet?
  • Do you want to work for the legacy airlines liked United, Delta or American?
  • Have you applied to anyone else?
  • What is the foundation of good leadership?
  • What is your leadership style?
  • If there is someone out there that you’ve had differences with and you would not go to that person for a recommendation, what would he/she say about you?
  • Tell us about yourself.
  • How did you get in aviation/flying?
  • What are your strengths?
  • Oracle Performance Tuning Interview Questions and Answers

    Are you planning to attend an interview for the Oracle Performance Tuning role but confused on how to crack that interview and also what would be the most probable Oracle Performance Tuning Interview Questions that the interviewer may ask? Well, you have reached the right place. Tekslate has collected the most frequently asked Oracle Performance Tuning Interview Questions which are often asked in multiple interviews.


    What is Oracle explain plan?

    The Oracle explain plan is a statement that returns execution plans for the requested SELECT, UPDATE, INSERT and DELETE statements. The execution plan for any given statement shows the operations in sequence used by Oracle to run that statement.

    How do you get explain plan of a query in Oracle?

    Running EXPLAIN PLAN

    EXPLAIN PLAN FOR SELECT last_name FROM employees; This explains the plan into the PLAN_TABLE table. You can then select the execution plan from PLAN_TABLE . This is useful if you do not have any other plans in PLAN_TABLE , or if you only want to look at the last statement.

    How do you explain a plan in Toad?

    In Toad, Open SQL editor by clicking on the menu Database > SQL Editor. Then type your SQL query and press Ctrl+E to execute Explain Plan for that query. If Plan Table does not exist in your database, then Toad will ask you to create a Plan Table.

    What is cost in Oracle explain plan?

    Cost is the estimated amount of work the plan will do. A higher cardinality => you’re going to fetch more rows => you’re going to do more work => the query will take longer. Thus the cost is (usually) higher. All other things being equal, a query with a higher cost will use more resources and thus take longer to run.

    Related Posts

    Leave a Reply

    Your email address will not be published. Required fields are marked *