Oracle8i Certified Professional DBA Certification Exam Guide
副标题：无
作 者：(美)Jason S.Couchman，(美)Ulrike Schwinn著
分类号：
ISBN：9787111093886
微信扫一扫,移动浏览光盘
简介
This book is divided into five units, each covering an exam in the Oracle8i DBA certification track from Oracle. Each unit has several chapters covering the materialyou need to know in order to pass the exam. Within each chapter, there are severalsection discussions. These section discussions correspond directly to subject areastested in the OCP exams. The discussion presents facts about the Oracle database.Commands and keywords that the user enters arepresented in courier, while newterms or emphasized facts are presented in italics. Particularly important facts andsuggestions are set apart from regular text. They are preceded by the word TIP, and a special icon appears in the margin next to them.
目录
unit 1 preparing for ocp dba exam i:sql and pl/sql
i selecting data from oracle
overview of sql and pl/sql
writing basic sql statements
restricting and sorting row data
using single-row functions
chapter summary
two-minute drill
fill-in-the-blanks
chapterquestions
fill -in-the-blankanswers
answers to chapter questions
2 advanced data selection in oracle
displaying data from multiple tables
group functions and their uses
using subqueries
multiple-column subqueries
producing readable output with sql*plus
chapter summary
two-minute drill
.fill-in-the-blanks
answers to chapter
3 creating oracle database objects
creating the tables of an oracle database
including constraints
the oracle data dictionary
manipulating oracle data
chapter summary
two-minute drili
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
4 creating other database objects in oracle
creating views
other database objects
user access control
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
5 introducing pl/sql
overview of pl/sql
writing executable statements
writing control structures
interacting with the oracle database
working with composite datatypes
explicit cursor handling
advanced explicit cursor concepts
error handling
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
unit ii
preparing for ocp dba exam 2: database administration
6 basics of the oraele database architecture
oracle architectural components
getting started with the oracle server
managing an oracle instance
creating an oracle database
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
7 managing the physical database structure
data dictionary views and standard packages
managing control files
maintaining redo log files
managing tablespaces and datafiles
storage structures and relationships
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
e managine database objects i
managing rollback segments
managing tables
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
9 managing database objects ii
managing indexes
managing data integrity
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
10 managing database use
managing users
managing password security and resources
managing privileges
managing roles
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
ii data loads and national language support
loading data
reorganizing data
using national language support
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
unit ⅲ
preparing for ocp dba exam 3: backup
and recovery workshop
12 overview of backup and recovery
backup and recovery considerations
oracle recovery structures and processes
oracle backup and recovery configuration
physical backups in oracle without rman
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
13 database failure and recovery
oracle utilities for troubleshooting
complete recovery without rman
oracle standby database
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
14 topics in data recovery
oracle export and import utilities
incomplete recovery with archiving
additional oracle recovery issues
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
15 using recovery manager for baekups
oracle recovery manager overview
oracle recovery catalog maintenance
backups using recovery manager
restoration and recovery using rman
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
unit ⅳ
preparing for ocp dba exam 4: performance
tuning workshop
16 introducing database tuning
tuning overview
oracle alert logs and trace files
utilities and dynamic performance views
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
17 tuning oracle memory usage
general note on tuning memory
tuning the shared pool
tuning the buffer cache
tuning redo mechanisms
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
18 tuning disk utilization
database configuration and i/o issues
tuning rollback segments
using oracle blocks efficiently
tuning sort operations
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
19 tuning database applications
application requirements and sql tuning
monitoring and detecting lock contention
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
20 tuning other areas of the oracle database
managing a mixed workload
tuning with oracle expert
multithreaded server tuning issues
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
unit v is found only on the cd-rom accompanying this book.
unit ⅴ
preparing for ocp exam 5: network administration
21 overview of net8 for client and server
22 oraele names on mts
23 connection manager, troubleshooting, and security
glossary of common oraele terms
index
i selecting data from oracle
overview of sql and pl/sql
writing basic sql statements
restricting and sorting row data
using single-row functions
chapter summary
two-minute drill
fill-in-the-blanks
chapterquestions
fill -in-the-blankanswers
answers to chapter questions
2 advanced data selection in oracle
displaying data from multiple tables
group functions and their uses
using subqueries
multiple-column subqueries
producing readable output with sql*plus
chapter summary
two-minute drill
.fill-in-the-blanks
answers to chapter
3 creating oracle database objects
creating the tables of an oracle database
including constraints
the oracle data dictionary
manipulating oracle data
chapter summary
two-minute drili
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
4 creating other database objects in oracle
creating views
other database objects
user access control
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
5 introducing pl/sql
overview of pl/sql
writing executable statements
writing control structures
interacting with the oracle database
working with composite datatypes
explicit cursor handling
advanced explicit cursor concepts
error handling
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
unit ii
preparing for ocp dba exam 2: database administration
6 basics of the oraele database architecture
oracle architectural components
getting started with the oracle server
managing an oracle instance
creating an oracle database
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
7 managing the physical database structure
data dictionary views and standard packages
managing control files
maintaining redo log files
managing tablespaces and datafiles
storage structures and relationships
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
e managine database objects i
managing rollback segments
managing tables
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
9 managing database objects ii
managing indexes
managing data integrity
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
10 managing database use
managing users
managing password security and resources
managing privileges
managing roles
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
ii data loads and national language support
loading data
reorganizing data
using national language support
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
unit ⅲ
preparing for ocp dba exam 3: backup
and recovery workshop
12 overview of backup and recovery
backup and recovery considerations
oracle recovery structures and processes
oracle backup and recovery configuration
physical backups in oracle without rman
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
13 database failure and recovery
oracle utilities for troubleshooting
complete recovery without rman
oracle standby database
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
14 topics in data recovery
oracle export and import utilities
incomplete recovery with archiving
additional oracle recovery issues
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
15 using recovery manager for baekups
oracle recovery manager overview
oracle recovery catalog maintenance
backups using recovery manager
restoration and recovery using rman
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
unit ⅳ
preparing for ocp dba exam 4: performance
tuning workshop
16 introducing database tuning
tuning overview
oracle alert logs and trace files
utilities and dynamic performance views
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
17 tuning oracle memory usage
general note on tuning memory
tuning the shared pool
tuning the buffer cache
tuning redo mechanisms
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
18 tuning disk utilization
database configuration and i/o issues
tuning rollback segments
using oracle blocks efficiently
tuning sort operations
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
19 tuning database applications
application requirements and sql tuning
monitoring and detecting lock contention
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
20 tuning other areas of the oracle database
managing a mixed workload
tuning with oracle expert
multithreaded server tuning issues
chapter summary
two-minute drill
fill-in-the-blanks
chapter questions
fill-in-the-blank answers
answers to chapter questions
unit v is found only on the cd-rom accompanying this book.
unit ⅴ
preparing for ocp exam 5: network administration
21 overview of net8 for client and server
22 oraele names on mts
23 connection manager, troubleshooting, and security
glossary of common oraele terms
index
Oracle8i Certified Professional DBA Certification Exam Guide
- 名称
- 类型
- 大小
光盘服务联系方式: 020-38250260 客服QQ：4006604884
云图客服：
用户发送的提问，这种方式就需要有位在线客服来回答用户的问题，这种 就属于对话式的,问题是这种提问是否需要用户登录才能提问
Video Player
×
Audio Player
×
pdf Player
×
亲爱的云图用户，
光盘内的文件都可以直接点击浏览哦
无需下载，在线查阅资料！
