|
ISBN:
0-9797951-2-5 |
Library of
Congress Number: xxx |
200
pages
Perfect bind - 9x7 |
Publication Date:
Dec 2008 |
|
Shelving:
Databases/Oracle |
Job Interview Series
#xxx |
|
|
The Oracle Job
Interview Handbook
IT
Manager Guide for Oracle Job Interviews with Oracle Interview Questions
Andrew Kerber
Retail Price $29.95
/ £24.95
| Order now at 30% off and
get access to the
code depot! |
Only $34.95
(30% off) |
|
|
As professional consultants, Don Burleson has
interviewed hundreds of Oracle job candidates. With over
four decades of interviewing experience, Burleson tells
you how to quickly identify acceptable Oracle job candidates by
asking the right Oracle job interview questions.
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.
About the Author:
Donald Burleson |
Donald
K. 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 30 books, published more
than 100 articles in National Magazines, and serves as
Editor-in-Chief of Rampant TechPress. Don is a popular lecturer
and teacher and is a frequent speaker at Oracle Openworld and
other international database conferences.
Table of Contents:
All examples are elaborated in detail and compared with the
other techniques and tools introduced in the book.
|
Section I – The UNIX Environment
CHAPTER 1 – The UNIX environment
A brief history of UNIX
UNIX, Linux, System V and BSD
What is a shell?
ksh, sh and bash
Files and file systems
CHAPTER 2 – Why shell scripting?
The shell, Oracle and you
Why bourne and bash?
Building a shell script, the 10,000-foot view
CHAPTER 3 – Key concepts
Commands, options and operands
Shell and environmental variables
Conditions
Loops
Wildcards (* and ?)
Parsing
Using grep, sed and awk
Relative and absolute paths
Permissions & Ownership
CHAPTER 4 – Setting up your
environment
Entering a shell
Configuring your default shell
Setting the prompt
Setting up the path, manual path and library path
Keeping your scripts organized
The .forward file
CHAPTER 5 – Key tools
A brief discussion of command-line and graphical editors
Finding help online – a warning
vi
grep
sed
awk
Section II – Shell Scripting
CHAPTER 6 – Simple scripting
Setting up your first script
The importance of comments
Standard output and error output
Redirecting output
Reading files
Variables and scope
Debugging and debug mode
CHAPTER 7 – Interacting with
SQL*Plus
Using SQL*Plus from shell scripts with EOF
Calling SQL scripts from shell scripts
Running shell commands from SQL*Plus
Passing variables into SQL*Plus
Getting information out of SQL*Plus
|
|
CHAPTER
8 – Making Decisions
Conditions
if and elseif
while
for
case
CHAPTER 9 – Checking and reporting
results
Exit conditions: the unseen result
Scanning logs for output
Gathering data from other commands
CHAPTER 10 – Flow and process
control Control
Running more than one thing at once
Checking on what's running
Killing runaway scripts
CHAPTER 11 – Automating scripts
Scheduling scripts with cron and at
Doing things when you log in
Running scripts at startup and shutdown
CHAPTER 12 – Reaching Further
File transfer
Executing commands on another system
Executing commands as another user
Making scripts email you
Section III – The Scripts
CHAPTER 13 – Oracle Database maintenance
Maintaining log files
Finding and removing old dump files
CHAPTER 14 – Database backup and
recovery
Backups without RMAN
Backups with RMAN
Export and import
Cloning
CHAPTER 15 – Oracle Application
Server maintenance
Application server log files
Controlling Application server
CHAPTER 16 – Oracle database
monitoring
Alert log monitoring
Listener availability
Database availability
CHAPTER 17 – Monitoring the system
Checking the system log
Monitoring disk space
Monitoring disk i/o
Monitoring network i/o
Monitoring memory
Monitoring system load
|
Reviews
From the
series Editor:
|
|
 |
