OCP Oracle9i Database : FundamentalsⅠExam Guide=OCP Oracle9i Database:FundamentalsⅠ考试指南 /
副标题：无
作 者：Jason S.Couchman and Sudheer N.Marisetti.
分类号：
ISBN：9787111100966
微信扫一扫,移动浏览光盘
简介
This book is divided into two units, the first containing preparatory material for the Oracle9i DBA Fundamentals I exam, part of the Oracle's, Oracle9i DBA certification track. The first unit has six chapters, each containing several discussions that focus on a particular topic or subtopic objective listed by the Oracle Certified Professional Oracle9i DBA Track Candidate Guide for the DBA Fundamentals I exam. (For a complete listing of all the topics tested for this exam, see Chapter 1 .)These discussions are followed by a For Review section, each listing the three or four most important concepts for you to retain from the discussion. After the review, you'll see two to six exercise questions in exam-based multiple choice or short answer format. Following the questions you will find an answer key for those questions, which should help you master the material even more quickly. Thus,with this book you're never more than a few pages away from demonstrating what you've learned about Oracle9i DBA topics for the OCP exam.
目录
part i
preparing for ocp database administration
fundamentals i exam
i basics of the oracle database architecture
oracle archit6ctural components
oracle server architecture
reading data from disk for users: the server process
structures that connect users to oracle servers
stages in processing queries, changes, and commits
getting started with the oracle server
common database administrative tools
the oracle universal installer
benefits of optimal flexible architecture
setting up password file authentication
using orac1e enterprise manager components
managing an oracle instance
creating and managing initialization parameter file
configuring oracle-managed files (omf)
starting an instance
monitoring use of diagnostic files
.creating an orac1e database
prerequisites for database creation
creating databases using database configuration assistant
creating a database manually
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
2 managing the physical database structure
data dictionary content and usage
constructing the data dietionary views
key data dictionary components and c
querying the data dictionary
maintaining contro1 fi1es
how control files are used
examining cootrol file contents
managing contro1 files with oracle-managed fites
obtaining information about control files
mu1tip1exing control files
maintaining redo log files
the purpose and structure of online redo logs
controlting log switches and checkpoints
multiplexing and maintaining redo log files
managing on1ine redo log files with omf
chapter summary
two-minute drill
chapter questions
answers to chapter questions
3 managingtablespaces and data files
describing the logica1 structure of the database
creating tablespaces
changing tablespace size
allocating space for temporary segments
temporary segments in permanent tablespaces
changing tablespace status
changing tablespace storage settings
oracle-managed files (omf)
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
4 storage structures and undo data
storage structures and relationships
different segment types and their uses
controlling the use of extents by segments
using b1ock space utilization parameters
obtaining information about storage structures
managing undo data
the purpose of undo segments
implementing automatic undo management
creating and configuring undo segments manually
obtaining information about undo data
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
5 managing database objects
managingtables,
various methods of storing data
distinguishing oracle datatypes
extended and restricted rowids
structure of data blocks and rows
creating permanent and temporary tables
managing storage structures in a table
reorganizing, truncating, and dropping tables
dropping unused columns from tables
managing indexes
different index types and their uses
creating b-tree and bitmap indexes
reorganizing indexes
dropping indexes
getting index information from the data dictionary
monitoring use of indexes
managing data integrity
implementing data integrity constraints
maintaining integrity constraints
obtaining constraint information from oracle
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
6 managing database users
managing users
creating new database users
altering and dropping existing users
monitoring information about existing users
managing password security and resources
controlling resource use with profiles
administering profiles
administering passwords using profiles
obtaining profile information from the data dictionary
managing privileges
identifying system and object privileges
granting and revoking privileges
identifying audit capabilities
managing roles
creating and modifying roles
controlling availability of roles
removing roles
using predefined roles
displaying role information from the data dictionary
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
part 2
ocp oracle9i dba fundamentals i practice exams
7 ocp database administration fundamentals i
practice exam 1
practice exam 2
practice exam 3
answers to practice exam 1
answers to practice exam 2
answers to practice exam 3
a globalization support
choosing a database and a national character set for a database
specifying language-dependent behavior
nls parameters
obtaining information about globalization support usage
index
preparing for ocp database administration
fundamentals i exam
i basics of the oracle database architecture
oracle archit6ctural components
oracle server architecture
reading data from disk for users: the server process
structures that connect users to oracle servers
stages in processing queries, changes, and commits
getting started with the oracle server
common database administrative tools
the oracle universal installer
benefits of optimal flexible architecture
setting up password file authentication
using orac1e enterprise manager components
managing an oracle instance
creating and managing initialization parameter file
configuring oracle-managed files (omf)
starting an instance
monitoring use of diagnostic files
.creating an orac1e database
prerequisites for database creation
creating databases using database configuration assistant
creating a database manually
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
2 managing the physical database structure
data dictionary content and usage
constructing the data dietionary views
key data dictionary components and c
querying the data dictionary
maintaining contro1 fi1es
how control files are used
examining cootrol file contents
managing contro1 files with oracle-managed fites
obtaining information about control files
mu1tip1exing control files
maintaining redo log files
the purpose and structure of online redo logs
controlting log switches and checkpoints
multiplexing and maintaining redo log files
managing on1ine redo log files with omf
chapter summary
two-minute drill
chapter questions
answers to chapter questions
3 managingtablespaces and data files
describing the logica1 structure of the database
creating tablespaces
changing tablespace size
allocating space for temporary segments
temporary segments in permanent tablespaces
changing tablespace status
changing tablespace storage settings
oracle-managed files (omf)
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
4 storage structures and undo data
storage structures and relationships
different segment types and their uses
controlling the use of extents by segments
using b1ock space utilization parameters
obtaining information about storage structures
managing undo data
the purpose of undo segments
implementing automatic undo management
creating and configuring undo segments manually
obtaining information about undo data
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
5 managing database objects
managingtables,
various methods of storing data
distinguishing oracle datatypes
extended and restricted rowids
structure of data blocks and rows
creating permanent and temporary tables
managing storage structures in a table
reorganizing, truncating, and dropping tables
dropping unused columns from tables
managing indexes
different index types and their uses
creating b-tree and bitmap indexes
reorganizing indexes
dropping indexes
getting index information from the data dictionary
monitoring use of indexes
managing data integrity
implementing data integrity constraints
maintaining integrity constraints
obtaining constraint information from oracle
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
6 managing database users
managing users
creating new database users
altering and dropping existing users
monitoring information about existing users
managing password security and resources
controlling resource use with profiles
administering profiles
administering passwords using profiles
obtaining profile information from the data dictionary
managing privileges
identifying system and object privileges
granting and revoking privileges
identifying audit capabilities
managing roles
creating and modifying roles
controlling availability of roles
removing roles
using predefined roles
displaying role information from the data dictionary
chapter summary
two-minute drill
fill-in-the-blank questions
chapter questions
fill-in-the-blank answers
answers to chapter questions
part 2
ocp oracle9i dba fundamentals i practice exams
7 ocp database administration fundamentals i
practice exam 1
practice exam 2
practice exam 3
answers to practice exam 1
answers to practice exam 2
answers to practice exam 3
a globalization support
choosing a database and a national character set for a database
specifying language-dependent behavior
nls parameters
obtaining information about globalization support usage
index
OCP Oracle9i Database : FundamentalsⅠExam Guide=OCP Oracle9i Database:FundamentalsⅠ考试指南 /
- 名称
- 类型
- 大小
光盘服务联系方式: 020-38250260 客服QQ：4006604884
云图客服：
用户发送的提问，这种方式就需要有位在线客服来回答用户的问题，这种 就属于对话式的,问题是这种提问是否需要用户登录才能提问
Video Player
×
Audio Player
×
pdf Player
×
亲爱的云图用户，
光盘内的文件都可以直接点击浏览哦
无需下载，在线查阅资料！
