Oracle DBA Job Interview Questions and Answers 1 :: When using Oracle export/import what character set concerns might come up? How do you handle them? Be sure to set NLS_LANG for example to "AMERCIAN_AMERICA.WE8ISO8859P1". If your source database is US7ASCII, beware of 8-bit ...
5. What is the cache hit ratio, what impact does it have on performance of an Oracle database andwhat is involved in tuning it? 6. Other than making use of the statspack utility, what would you check when you are monitoring orrunning a health check on an Oracle 8i or 9i database?
Ans: With each patch a file with name f.ldt is delivered , which contain the file versions of the files dilivered with the patch. Adpatch will use this file to compare the file versions of files its delivering with the file on file system. 33. What is the adpatch log file location?
Technical Interview Round 2:This is a personal interview round where tricky and complex questions based on data structures are asked. Questions related to the candidate's CV may also be asked in this round. Also, some interviewers like to ask for puzzles to test the thinking ability of the c...
interview Questions with Answers for Oracle, DBA, and developer candidates [size=large][/size] [Hide TOC] 1 Introduction 2 Questions/Answers 2.1 PL/SQL Questions 2.2 DBA 2.3 SQL/ SQLPlus 2.4 Tuning Questions 2.5 Installation/Configuration
Launched new edition of Oracle DBA Interview Questions...Kendba
SQL Server Interview Questions and Answers MySQL Interview Questions DB2 Interview Questions and Answers PL/SQL Interview Questions and Answers Oracle DBA Interview Questions and Answers Top 35 Database Testing Interview Questions and Answers How to Find the Second Highest Salary in SQLDB2...
Frequently asked SQL Server Interview Questions and Answers for freshers, intermediate, and experienced which will definitely ace your SQL Server Interview.
Oracle PL/SQL Questions 1. What is normalization. 2. Difference between procedure and functions. 3. Oracle 9i Vs 10g. 4. how to improve the performance of a query. 5. %type vs %rowtype. 6. regression testing. 7. deleting the duplicate records without using rowid in oracle. 8. Row ch...
14 years of strong experience in the field of online DBA training and job assistance to fresher’s for acquiring jobs, Kendba is pioneer in this field. They provide Oracle DBA trainings,Oracle DBA job assistance, Interview questions books and much more. ...