Oracle Training Oracle Support Development Oracle Apps

Free Oracle Tips

HTML Text

 Home
 Catalog
 Oracle Books
 Oracle Software
 Job Interview
 eBooks
 SQL Server Books
 News
 Oracle Scripts
 Oracle Tuning Book
 Remote DBA
 Oracle Tuning
 

  

 
 

  Conducting the Oracle Job Interview
IT Manager Guide for Oracle Job Interviews with Oracle Interview Questions

Mike Ault & Don Burleson
ISBN 0-9727513-1-9 
Retail Price $16.95 /  £10.95 

Order now and get 40% off the retail price!

You also receive online access to the interview questions and answers!

  Only $9.95

 

As professional consultants, Don Burleson and Mike Ault have interviewed hundreds of Oracle job candidates.  With over four decades of interviewing experience, Ault and Burleson tell you how to quickly identify acceptable Oracle job candidates by asking the right Oracle job interview questions.

Mike Ault and Don Burleson are recognized as the two best-selling Oracle Authors in the world.  With combined authorship of over 25 books, Ault & Burleson are the two most respected Oracle authorities on the planet.  For the first time ever, Ault & Burleson combine their talents in this exceptional handbook.

This book is the accumulated observations of the authors interviews with hundreds of Oracle professionals.  The authors provide useful insights into what characteristics make a good DBA and offer their accumulated techniques as an aid to interviewing an Oracle job candidate.

This handy guide has a complete set of Oracle job interview questions and provides a complete method for accurately accessing the technical abilities of Oracle job candidates. By using Oracle job interview questions that only an experienced person knows, your DBA can ask the right interview questions and fill your Oracle job with the best qualified DBA or developer.

Key Features:
 

  • Assists the IT manager in choosing the best-qualified Oracle professionals.

  • Provides proven techniques that can accurately ascertain a job candidates suitability for an Oracle position.

  • Lists the personality characteristics of successful Oracle professionals and how to identify candidates with the right demeanor.

  • Describes methods for evaluating academic and work history for Oracle professionals.

  • Includes managers’ checklist of personality and background characteristics that indicate a suitable Oracle job candidate.

  • Covers techniques for quickly scan resumes and find the best-qualified Oracle job candidates.

  • Includes oral interview questions for Oracle DBAs, Oracle developers and Oracle Analysts.

About the Authors:

Mike Ault

  Mike Ault is one of the leading names in Oracle technology.  The author of more than 20 Oracle books and hundreds of articles in national publications, Mike Ault has five Oracle Masters Certificates and was the first popular Oracle author with his landmark book "Oracle7 Administration and Management".  Mike also wrote several of the "Exam Cram" books, and enjoys a reputation as a leading author and Oracle consultant.

Mike started working with computers in 1979 right out of a stint in the Nuclear Navy. He began working with Oracle in 1990 and has since become a World Renowned Oracle expert. Mike is currently a Senior Technical Management Consultant and has two wonderful daughters.  Mike is kept out of trouble by his wife of 29 years, Susan.


Click here for Mike Ault's Books

 

Don Burleson

  Don Burleson is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems.  

A former Adjunct Professor, Don Burleson has written 32 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Oracle Internals. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

Click here for Don Burleson's books

 

 

Table of Contents:

 

Chapter 1 - Introduction to Oracle professional evaluation
 
    Preparing the Oracle job offering
      Preparing the incentive package
      Defining the Required Job Skills
      Basic skills for the Oracle Professional
      Basic IT skills
   Oracle Certified Professionals
   The value of Oracle certification
      Training for certification
   Characteristics of a top-notch Oracle professional
   Sample job sheet for an Oracle DBA
      Oracle Job Requirement sheet
      Education
      Work experience
      OCP Certification
      Publishing and Research
      Personal integrity
      USA Citizenship
      Additional Specialized skills
 
Chapter 2 - Qualities of the successful Oracle professional
 
 Evaluating Employment History
      Fraudulent work history
      Evaluating Personal integrity
      Evaluating Academic history
   Personality of the Successful Oracle Professional
      Self-confidence
      A Curious nature
      A Tenacious disposition
      Polite Manners
      Self-Motivating
      Detail Orientation

 


Chapter 3 - Roles for the Oracle Professional
 
Managing the Oracle Job Interview
   The Role of the DBA
      Installation
      Configuration management
      System security
      Monitoring and tuning
      Backup and recovery strategies
      Troubleshooting
      Communication skills
 
Chapter 4 - Initial Screening of the Oracle Professional
 
 Resume evaluation for Oracle Professionals
      Developing questions for interviews
      Appropriate Appearance
   Telephone Screening Oracle Job Candidates
   After hiring the candidate

Chapter 5 - The on-site technical interview
 
  Telephone pre-interview questions
   In-depth Technical Interview questions
      Tips for administering the job interview questions
      PL/SQL job interview questions
      Oracle DBA job interview questions
      SQL*Plus and SQL Job Interview Questions
      Oracle Performance Tuning Job Interview Questions
      Oracle Installation and Configuration Job Interview Questions
      Data Modeling Job Interview Questions
      Oracle UNIX Job Interview Questions
      Oracle Troubleshooting Job Interview Questions
      Results of the Interview with the potential Oracle DBA

 

 

Errata and Enhancements

IMPORTANT NOTE:

The test section is not intended to be used as a comprehensive Oracle technical exam, and the technical questions in this code depot are only intended to be examples. The only way to accurately evaluate the Oracle skills of a job applicant is to employ the services of an experienced Oracle DBA and conduct an in-depth technical interview and skills assessment.

Also note that the expected answers from the questions are highly dependent upon the version of Oracle.  We have tried to make the questions as version neutral as possible, but each release of Oracle brings hundreds of changes and new features, and these example questions may not be appropriate for your version of Oracle.  All of the interview questions presented in this book should be administered by an experienced Oracle DBA.

 

Enhancements to the expected answers are noted in red.

 

Page 35, question 7

 

7. What dictionary file tells the size of each database file?

 

The best answer is dba_data_files, although sys.file$ and sys.v$datafile are also correct.

 

Page 40, Question 11

11. What are the types of table triggers ?

 

 Skill Level:  Intermediate to High

 

Expected Answer: There are 12 types of triggers  in PL/SQL  that consist of combinations of the BEFORE, AFTER, ROW, TABLE, INSERT, UPDATE, DELETE and EACH key words. 

 

BEFORE INSERT FOR EACH ROW

AFTER INSERT FOR EACH ROW

BEFORE INSERT

AFTER INSERT

Etc.

 

Page 44, Question 10

10.  (On UNIX ) When should more than one DB writer process be used? How many should be used?

 

Skill Level: High

 

Expected answer: If the UNIX  system being used is capable of asynchronous IO, then only one is required. If the system is not capable of asynchronous IO, then up to twice the number of disks used by Oracle number of DB writers should be specified by use of the initialization parameter for your Oracle release that sets the number of DBWR processes.

 

Async IO usually indicates a multi-threaded model for disk access will be used and Oracle states several times that with async IO most systems don't need multiple db writers, however, in some cases multiple db writers can be helpful. The number varies from twice the number of cpus to the number of disks expected to be used, which ever value is smaller.

 

Other job interview books:

Java job interview
J2EE job interview
Linux job interview
UNIX job interview
web designer job interview
webmaster job interview
web master job interview
Windows advanced server job interview

 

    P. O. Box 511
Kittrell, NC, 27544