Oracle8i to Oracle9i DBA OCP Upgrade - What To Know
MCSE, CISSP, Security+, Network+, A+ Certification Practice Exams, Study Guides and Vouchers Sign Up | Login   
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE Video + 10 Free Vouchers Practice Exams Exam Vouchers Video Training Get a free MS Cert
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE CCNA  A+ CERTIFICATION NETWORK+ ETHICAL HACKER SECURITY+   CISSP   CCNP MORE...
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
EXAMS: WHAT TO KNOW

Oracle8i to Oracle9i DBA OCP Upgrade - What To Know

Email this ArticleEmail this Article  Print this ArticlePrint this Article

• Relates to: Oracle9i DBA OCP Upgrade

What you should know to pass this test:

To pass this test, you need to be familiar with all the new features and improvements Oracle9i introduces.

Be familiar with all the new security features 9i introduces, including security application roles, global application context, partitioned fine-grained access control, and fine-grained auditing. Know what the new optional security products are and what they are used for.

Since Server Manager and CONNECT INTERNAL are deprecated, how do you start and stop Oracle? What does this mean for any scripts at your site that perform these functions?

Understand the new recovery improvements: minimal I/O recovery and fast-start time-based recovery limits. How do you set up these new features?

Be familiar with all the operations that can now be performed online: online index rebuilds, online Index Organized Table (IOT) management, online table redefinition, and online configuration parameter control.

Know about other high availability improvements, including Oracle Flashback, resumable space allocation, new Import/Export features, and Data Guard. Data Guard is a complex product: for the upgrade exam, you only need a conceptual understanding of it, plus the specific details introduced in 9i.

Understand LogMiner and its use. 9i introduces some key improvements to this product, including DDL tracking, the new LogMiner Viewer GUI interface, and dictionary extraction.

How have backup/recovery and RMAN been enhanced in 9i? Describe trial recovery, block media recovery, the RMAN CONFIGURE command, and other RMAN command enhancements.

Be familiar with the wide range of manageability improvements in 9i: Oracle Managed Files (OMFs), default temporary tablespaces, multiple blocksizes in one database, automatic global index management, list partitioning, the new metadata API, bitmap join indexes, automatic segment space management, the Data Resource Manager, scalable session management, workspace management, external tables, replication enhancements, and Real Application Clusters. As with Data Guard, the complexity of the replication enhancements and Real Application Clusters can be overwhelming – the exam expects you only to have a high-level understanding of these areas, plus knowledge of 9i specifics.

Know about 9i’s new performance enhancements, including index monitoring, skip scan access, first rows optimization, system statistics, and improved cursor sharing.

Be familiar with 9i’s SQL enhancements: SQL-99 syntax for joins, CASE expressions, new functions, and globalization improvements.


 Subscribe to our Free Must Know News Newsletter
 Name:     Email:  
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification

KEYWORD
 
What is this?
Microsoft, CompTIA, Cisco Realistic Practice Exams
Microsoft, CompTIA, Cisco Realistic Practice Exams
Microsoft, CompTIA, Cisco Realistic Practice Exams
FREE STUDY GUIDES
FREE RESOURCES
FREE QUESTIONS >>
HOME
CERTIFICATIONS
VIDEO TRAINING
PRACTICE EXAMS
AUDIO TRAINING
EXAM VOUCHERS
FREE IT MAGAZINES
CERT COMPARISON
EXAM COMPARISON
SALARY SURVEY
CAREER TRACKS
ARTICLE DIRECTORY
WHITE PAPERS
QUESTION OF THE DAY
NEWSLETTER
ADVERTISE
Industry Updates &
Special Offers
Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
Picks for December
Untitled Document > Persistent Group Chat: An Approach for More Profitable Team Communications : Unlike email, instant messages (IMs) do not allow group communication; nor do they persist -- you can't hold on to them for as long as you wish. Persistent group chat, however, allows businesses to organize persistent dialogue around business-critical topics, and keep them for easy retrieval later.

> Recent White Papers
> Get a free Microsoft Certification exam

> NetworkWorld - FREE Subscription Center

> Never Open a Book Again! LearnSmart Video Training for A+, CCNA, Network+ and more.

> Pass Guaranteed: Hundreds of practice exam questions and the most authentic exam simulation.

> Lecture Series audio: Learn at home, on your iPod or while driving to work.

> PMP: Learn everything for the Project Management Professional (PMP) certification

> Quiz Me Series Audio: Rapid-fire question and answer session training

Marketplace

Get a free second shot at your Microsoft Certification exam.
For a limited time, you can get an extra chance to pass any Microsoft IT Professional, Developer, or Microsoft Dynamics™ Certification exam – free. Register for this offer before your 1st exam and you’ll get two shots at success. Register now: www.microsoft.com/learning/secondshot

IT Certifications may waive some degree requirements for an online degree. Free catalog!
For several of the IT degrees at WGU, if you hold a relevant IT certification (such as MCSE), you automatically clear a significant portion of the degree requirements. Don't hold an IT certification yet? Don't worry. Not every WGU degree program requires an IT certification in advance. You can earn both at the same time. Lower tuition too!

Earn an online bachelor's degree in Information Technology plus eight IT certifications
Including CompTIA, MySQL Core, and Sun Certified Programmer for the Java Platform. Your prior college and IT certifications may waive some degree requirements; however, you do not have to hold a major certification to enroll.


Earn an affordable, online bachelor's degree in Information Technology—Security Emphasis
plus nine IT certifications including Sun Certified Programmer for the Java Platform, MySQL Core, and Security+. Your prior college and IT certifications may waive some degree requirements

FREE subscription to Network World.
Your complimentary subscription will include 50 weekly issues jam packed with news analysis, expert industry opinion and management/career advice, all of which is packaged with your business needs in mind. We want to help you connect the technology dots and help you advance your company's business goals




Sponsored Link

MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
Free Certification Training Free Certification Training Free Study Guides
   © 1999 - 2008 CramSession. All Rights Reserved. Home   Advertise   Corporate Info   Opportunities   Help