OCA: Oracle 10g Administration I Study Guide: Exam 1Z0-042
- Clear and concise information on database administration with Oracle 10g
- Practical examples and insights drawn from the authors' real-world experiences
- Leading-edge exam preparation software, including a test engine and electronic flashcards
You'll also find authoritative coverage of key exam topics, including:
- Installing Oracle Database 10g Software
- Creating and Controlling Oracle Databases
- Administering Users
- Managing Schema Objects and Data
- Implementing Oracle Security Features
- Monitoring Performance
- Performing Database Backup and Recovery
Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace
Chapter 1: Oracle Database 10g Components and Architecture.
Chapter 2: Creating and Controlling a Database.
Chapter 3: Database Storage and Schema Objects.
Chapter 4: Oracle Net Services.
Chapter 5: Oracle Shared Server.
Chapter 6: User Administration and Security.
Chapter 7: Managing Data With SQL, PL/SQL, and Utilities.
Chapter 8: Managing Consistency and Concurrency.
Chapter 9: Proactive Database Maintenance and Performance Monitoring.
Chapter 10: Implementing Database Backups.
Chapter 11: Implementing Database Recovery.
Matthew Weishan, OCP, is a senior specialist for EDS in Madison, Wisconsin.
Joseph C. Johnson, OCP, has over 8 years of experience in the management of Oracle databases, and is currently working as a Senior Database Administrator.
Bob Bryla, OCP, currently works as an Oracle DBA and Analyst for Lands' End.
Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.
In the NOTE- "hostname:5550" should be changed to "hostname:5500".
should be modified to
second NOTE, the word "system" should be changed to "SYSTEM" (fixed font).
The first complete CREATE TABLE statement should instead be:
In Table 4.2
In the second paragraph on page 214, "select the listener" should be replaced with "select Listeners".
On page 216, first paragraph, change "You will then see the new listener listed in the listener control screen" to "You will then see the new listener listed on the Listeners screen".
(FAILOVER=ON) is needed in the tsnnames.ora file for connect-time failover just after ADDRESS_LIST=
Table 5.1-Caption, "DISPATCHER" should be changed to "DISPATCHERS".
The create role statement "CREATE ROLE app1-dba;"
app1_dba IDENTIFIED BY seekwrit;", because the role is
has a IDENTIFIED BY clause in the statement,"SET ROLE
line #8 of the INSERT FIRST statement should be changed from..
In the line,"Events can be created on DML events, DLL events..." 'DLL' should be replaced with 'DDL'.
In table 7.7, "aata" should instead be "data".
On the last line of page 413,
"This parameter is not available as an initialization parameter. Unlike most every other command or procedure in the database, it is not available via the EM Database Control; you must use ALTER TABLESPACE at the command line to set it, as in the following example:" is incorrect
Three errors in the third paragraph of the text box at the top of page 470:
The last sentence of the second paragraph should read "Background process trace files are found in the directory specified by the BACKGROUND_DUMP_DEST parameter, and the user process trace files are found in the directory specified by the USER_DUMP_DEST parameter. Both of these parameters are defined in the PFILE or SPFILE."
In the statement,"Using the Indexes screen...recompile
the Indexes screen... rebuild indexes..". Indexes are
However, in the first paragraph on page 477, "JOBS_ID_PK" should be changed to "JOB_ID_PK".