| Jason S. Couchman is a database consultant and the author ofOracle8i Certified Professional DBA Certification Exam Cuide,also from Oracle Press. He is a regular presenter on Oracle and OCP at international Oracle user conferences and meetings. His work has been published by Oracle Magazine Harvard Business School Publishing, and Gannett Newspapers, among others. .. << 查看详细 |
| part 1 ocp oracle8i dba practice exams 1 ocp exam 1: introduction to sql and pl/sql ocp exam 1 topic areas practice exam 1 practice exam 2 practice exam 3 answers to practice exam 1 answers to practice exam 2 answers to pract1ce exam 3 2 ocp exam 2: database administration ocp exam 2 topic areas practice exam 1 practice exam 2 practice exam 3 answers to practice exam 1 answers to practice exam 2 answers to practice exam 3 3 ocp exam 3: backup and recovery workshop ocp exam 3 topic areas .practice exam 1 practice exam 2 practice exam 3 answers to practice exam 1 answers to practice exam 2 answers to practice exam 3 4 ocp exam 4: performance tuning workshop ocp exam 4 topic areas practice exam 1 practice exam 2 practice exam 3 answers to practice exam 1 answers to practice exam 2 answers to practice exam 3 5 ocp exam 5: network administration ocp exam 5 topic areas practice exam 1 practice exam 2 practice exam 3 answers to practice exam 1 answers to practice exam 2 answers to practice exam 3 part ii ocp key terms and concepts 6 ocp exam i terms and concepts overview of relational databases, sql, and pl/sql writing basic sql statements restricting and sorting data single-row functions displaying data from multiple tables aggregating data using group functions subqueries multiple-column subqueries producing readable output from sql*plus manipulating data creating and managing tables including constraints creating views oracle data dictionary other database objects controlling user access declaring variables write executable statements interacting with the oracie server writing control structures working with composite datatypes writing explicit cursors advanced explicit cursor concepts handling exceptions fill-in-the-blanks fill-in-the-blank answers 7 ocp exam 2 terms and concepts oracle architectural components getting started with oracle server managing an oracle instance creating a database data dictionary views and standard packages maintaining the control fiie maintaining redo log files managing tablespaces and datafiles storage structures and relationships managing rollback segments managing tables managing indexes maintaining data integrity loading data reorganizing data managing password security and resources managing users managing privileges managing roles using national language support fill-in-the-blanks fill-in-the-blank answers 8 ocp exam 3 terms and concepts backup and recovery considerations oracle recovery structures and processes oracle backup and recovery configuration physical backups without oracle recovery manager oracle recovery without recovery manager incomplete oracle recovery with archiving oracle export and import utilities additional oracle recovery issues oracle utilities for troubleshooting oracie recovery manager overview oracle recovery catalog creation and maintenance backups using rman restoration and recovery using rman oracle standby database fiil-in-the-blanks fill-in-the-blank answers 9 ocp exam 4 terms and concepts tuning overview oracle alert and trace files utilities and dynamic performance views tuning the shared pool tuning the buffer cache tuning the redo log buffer database configuration and i/o issues using oracle blocks efficiently optimize sort operations rollback segment tuning monitoring and detecting lock contention sql issues and tuning considerations for different applications managing a mixed workload tuning with oracle expert multithreaded server tuning issues fill-in-the-blanks fill-in-the-blank answers 10 ocp exam 5 terms and concepts networking overview basic net8 architecture basic net8 server-side configuration basic net8 client side configuration centralized naming concepts usage and configuration of oracle names usage and configuration of the multithreaded server usage and configuration of connection manager troubleshoot the network environment security in the network environment fill-in-the-blanks fill-in-the-blank answers a additional ocp topical questions new features questions answers to new features questions b glossary of common oracle terms index |
内容加载中，请稍后...
商品评论（0条）