...Oracle DBA Interview Questions and Answers Compiled By Mohamed Fowjil Abdul Hameed Contents Oracle DBA Interviews - Overview 2 Oracle DBA Interview Questions and Answers – ARCHITECTURE 4 SENIOR ORACLE DBA INTERVIEW QUESTIONS 31 MID LEVEL ORACLE DBA INTERVIEW QUESTIONS 57 Oracle 11g Database New Features Interview Questions and Answers 65 Oracle RAC Interview Questions and Answers 70 Oracle RAC Interview Questions (10g) Questions and Answers 137 Oracle Data Guard Interview Questions and Answers 168 Oracle ASM Interview Questions and Answers 205 Oracle Patching,Cloning and Upgrade Interview Questions and Answers 219 Oracle Backup and Recovery Interview Questions and Answers 228 Oracle RMAN Interview Questions and Answers 232 Oracle Performance Tuning Interview Questions and Answers 237 Oracle Performance Tuning Interview Questions and Answers 245 Oracle Export/Import (exp/imp)- Data Pump (expdp/imp) Interview Questions and Answers 249 UNIX Interview Questions and Answers for Oracle DBAs 254 Oracle DBA Interviews - Overview Dear Readers, Hereby, I am sharing my experience of interviews asd technical discussion with various MNC Dba’s, Project managers and Project delivery managers and Technical architects, as part of my interview preparation, I used to refer my own work note as well as web sources below details are a consolidate form of my interview preparation and Oracle dba interviews questions and answers General Guide line:...
Words: 97621 - Pages: 391
...á«Hô©dG ô°üe ájQƒ¡ªL º«∏©àdGh á«HÎdG IQGRh ÖàμdG ´É£b iOGóYE’G ådÉãdG ∞°ü∏d ∞````«dCÉJ πª÷G ø°ùM óªfi º«gGôHEG Ω 2012 - 2011 ≈°SGQódG ΩÉ©dG º«∏©àdGh á«HÎdG IQGRh êQÉN ÜÉàμdG Gòg ∫hGóàH ìô°üe ÒZ CMYK CMYK á`````eó```≤``e AÉ°SQEG ≈a ÉgQhO ,™ªàÛG ≈a ICGôŸG QhO óMCG ≈∏Y ≈Øîj ’ º∏°ùdG ≈Øa .Üô◊Gh º∏°ùdG ≈a ÉgQhO ,¬°ù°SCG â«ÑãJh ,¬ªFÉYO ¢Sô¨Jh ,áÁƒb ájƒHôJ ¢ù°SCG ≈∏Y ∫É«LC’G Å°ûæJh ôª©Jh ≈æÑJ .샪£dGh Iõ©dG º¡«a ,√QRCG øe ó°ûJ ¬d GAOQ πLôdG AGQh øe ∞≤J Üô◊G ≈ah k ä’ƒ£H ∫ÉÛG Gòg ≈a â≤≤M óbh .ô°üædG ¬d ºàj ≈àM ¬æ«©Jh .ÚØ≤ãª∏d GOGRh ,ÜÉÑ°û∏d Ihób âdGRÉe ,IódÉN k â≤°T ,äGódÉîdG ÉæFÉ°ùf øe IóFGQ Ωó≤f ÜÉàμdG Gòg ≈ah ,É¡JOGQEG Iƒbh ,É¡àÁõ©H Égó› â©æ°Uh ,ôî°üdG ≈a É¡≤jôW .(@)zQódG Iôé°T{ á°üb É¡fEG ∞``dDƒ```ªdG .AÉàdG ¿hóH zQódG ôé°T{ OQh ɪc ™LGôªdG ¢†©H ≈a AÉàdÉH zQódG Iôé°T{ º°SG OQh (@) .Qƒ°TÉY ìÉàØdGóÑY ó«©°S :Qƒàcó∏d zΩÉ°ûdGh ô°üe ≈a ∂«dɪªdGh ¿ƒ«HƒjC’G{ :™LôªdG CMYK º`````jó```````≤J ¬JÉÑdÉWh iOGóYE’G ådÉãdG ∞°üdG ÜÓW ÉæJÉæHh ÉæFÉæHCG ¤EG π˘˘Ñ˘ ofh áÁõ˘˘©˘ dG ᢢHÓ˘˘°Uh IOGQE’G Iƒ˘˘ b ó˘˘ °ùŒ ᢢ °üb º˘˘ μ˘ d Ωó˘˘ ≤˘ f ¿Éc ɪ¡e ¿É°ùfE’G 샪W ≥«≤– ≈a ∂dP ôKCG RÈJh ,¥ÓNC’G â°TÉY ób ÉÄk «°T ÉgôeCG øe ∂∏“ ’ IÉàa √ò¡a ,∫ÉæŸG Ö©°U ’h ,ájQÉ÷G ¥Q ∞≤j ⁄h ,iΰûoJh ´ÉÑoJ ájQÉL ¤hC’G É¡JÉ«M É¡aGógCG ≥«≤– ≈∏Y â∏ªY ó≤a ,É¡MƒªW ΩÉeCG ICGôŸG ∞©°V áë∏°ùàeh ,É¡Jó°T øe ºZôdÉH äÉÑ≤©dGh ÜÉ©°üdG πc IRhÉéàe iCGôdG ÉgRƒ©j øμj ⁄h .Ú∏J ’ IOGQEGh ,∞©°†J ’ áÁõ©H ,çGóMCÓd á«∏Ñ≤à°ùe ájDhQ É¡d âfÉc ó≤a ¬«dEG êÉà– ÚM ójó°ùdG â©bh GPEÉa ,∫ƒ∏◊G É¡d ™°†Jh ,É¡Yƒbh πÑb É¡H Égô©°ûà°ùJ .ádƒ¡°Sh...
Words: 32038 - Pages: 129
...Electrical Engineering Mathematics-I Engineering Graphics Communication Skills Chemistry/Physics Laboratory Workshop Physical Training-I NCC/NSO/NSS L 3 3 3 1 3 0 0 0 0 13 T 1 0 1 0 0 0 0 0 0 2 1 1 1 1 0 0 0 0 4 1 1 0 0 0 0 0 0 2 0 0 0 0 P 0 0 0 3 0 2 3 2 2 8 0 0 0 0 0 2 2 2 2 0 0 0 0 0 2 2 2 6 0 0 8 2 C 8 6 8 5 6 2 3 0 0 38 8 8 8 8 6 2 0 0 40 8 8 6 6 6 2 2 2 40 6 6 8 2 Course No EC-1101 CS-1101 MA-1102 ME-1101 PH-1101/ CH-1101 CS-1111 EE-1111 PH-1111/ CH-1111 Course Name Semester-2 Basic Electronics Introduction to Computing Mathematics-II Engineering Mechanics Physics/Chemistry Computing Laboratory Electrical Science Laboratory Physics/Chemistry Laboratory Physical Training –II NCC/NSO/NSS Semester-4 Structural Analysis-I Hydraulics Environmental Engg-I Structural Design-I Managerial Economics Engg. Geology Laboratory Hydraulics Laboratory Physical Training-IV NCC/NSO/NSS Semester-6 Structural Design-II Structural Analysis-III Foundation Engineering Transportation Engineering-II Hydrology &Flood Control Concrete Lab Structural Engineering Lab L 3 3 3 3 3 0 0 0 0 0 15 3 3 3 3 3 0 0 0 0 15 3 3 3 3 3 0 0 T 0 0 1 1 1 0 0 0 0 0 3 1 1 0 1 0 0 0 0 0 3 1 1 1 0 0 0 0 P 0 0 0 0 0 2 2 2 2 2 6 0 0 0 0 0 2 2 2 2 4 0 0 0 0 0 2 2 C 6 6 8 8 8 2 2 2 0 0 42 8 8 6 8 6 2 2 0 0 40 8 8 8 6 6 2 2 MA-1201 CE- 1201 CE -1202 CE -1203 CE-1204 CE-1211 Semester-3 Mathematics-III Building Materials and...
Words: 126345 - Pages: 506
...Employment News 11 - 17 February 2012 www.employmentnews.gov.in 21 Union Public Service Commission EXAMINATION NOTICE NO. 04/2012-CSP DATED 11.02.2012 (LAST DATE FOR RECEIPT OF APPLICATIONS : 05.03.2012) CIVIL SERVICES EXAMINATION, 2012 (Commission's website - http://www.upsc.gov.in) F. No. 1/4/2011-E.I(B) : Preliminary Examination of the Civil Services Examination for recruitment to the Services and Posts mentioned below will be held by the Union Public Service Commission on 20th May, 2012 in accordance with the Rules published by the Department of Personnel & Training in the Gazette of India Extraordinary dated 4th February, 2012. (i) Indian Administrative Service. (ii) Indian Foreign Service. (iii) Indian Police Service. (iv) Indian P & T Accounts & Finance Service, Group ‘A’. (v) Indian Audit and Accounts Service, Group ‘A’. (vi) Indian Revenue Service (Customs and Central Excise), Group ‘A’. (vii) Indian Defence Accounts Service, Group ‘A’. (viii) Indian Revenue Service (I.T.), Group ‘A’. (ix) Indian Ordnance Factories Service, Group ‘A’ (Assistant Works Manager, Administration). (x) Indian Postal Service, Group ‘A’. (xi) Indian Civil Accounts Service, Group ‘A’. (xii) Indian Railway Traffic Service, Group ‘A’. (xiii) Indian Railway Accounts Service, Group 'A'. (xiv) Indian Railway Personnel Service, Group ‘A’. (xv) Post of Assistant Security Commissioner in Railway Protection Force, Group ‘A’ (xvi) Indian Defence Estates Service, Group ‘A’. (xvii) Indian Information...
Words: 50586 - Pages: 203