Oracle 9i Fundamentals I Exam Cram 2
Home > Computing and Information Technology > Databases > Database software > Oracle 9i Fundamentals I Exam Cram 2
Oracle 9i Fundamentals I Exam Cram 2

Oracle 9i Fundamentals I Exam Cram 2


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Whether you're studying for the Oracle 9i Fundamentals I exam or just need to take the New Features update exam, Oracle 9i Funamentals I Exam Cram 2 can help you get certified. This efficient guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i Fundamentals I Exam Cram 2 is your smartest way to get certified.

Table of Contents:
Introduction. Self-Assessment. 1. Oracle Architecture Components.     Database Versus Instance.       Oracle Server.       Database.       Instance.       Data Blocks.       Block Size Choices.       Disk Blocks.       Extents.       Segments.     Datafiles.       Tablespaces.       Synonym.       Schema.       Schema Objects.       Table.       Index.       View.       Redo Log Files.       Control Files.      Memory Structures.       System Global Area.     Shared SQL Area.       Shared PL/SQL Area.     Program Global Areas (PGA) Overview.       Private SQL Area.       SQL Work Areas.     Process Architecture.     Background Processes.       Database Writer (DBWn).       Log Writer (LGWR).       Checkpoint (CKPT).       System Monitor (SMON).       Process Monitor (PMON).       Archiver (ARCn).       Recoverer (RECO).       Job Queue Processes (Jnnn).       Dispatcher (Dnnn).       Lock Manager Server (LMS).       Queue Monitor (QMNn).     Connecting to an Instance.       Connection.       Session.     Exam Prep Questions.     Need to Know More? 2. Getting Started with the Oracle Server.     Administrative Tools.     Oracle Universal Installer (OUI).       OUI Interactive.       OUI Noninteractive.       Multiple Oracle Homes.       Creating an Oracle Home.     Oracle Database Configuration Assistant (DBCA).     Optimal Flexible Architecture (OFA).     Password File Authentication.       Locked and Expired Default Accounts.       Elimination of Default Passwords.       Password File.     DBA Tools.       SQLPlus.       Oracle Enterprise Manager (OEM).       OMS Repository.     Exam Prep Questions. 3. Creating a Database.     Prerequisites for Database Creation.     Planning Database File Locations.     Creating the Database.     Oracle Database Configuration Assistant.       Create a Database.       Database Configuration Options.     Create a Database Manually.       Step 1: Decide on Your Instance's System Identifier (SID).       Step 2: Create the Initialization Parameter File.       Step 3: Connect to and Start the Instance.       Step 4: Issue the CREATE DATABASE Statement.       Step 5: Run Scripts to Build Data Dictionary Views.       Step 6: Run Scripts to Install Additional Options.       Step 7: Create a Server Parameter File.       Step 8: Back Up the Database.       Step 9: Create Additional Tablespaces.     What to Do If Database Creation Fails.     Exam Prep Questions.     Need to Know More? 4. Managing an Instance.     Initialization Parameter Files.       Working with PFILE.       Working with SPFILE.       Specifying Often-Used Initialization Parameters.     Oracle Managed File (OMF) System.       Initialization File Parameters for OMF.       OMF Naming Conventions.     Database Startup.       STARTUP NOMOUNT.       STARTUP MOUNT.       STARTUP OPEN.     Working with the STARTUP Command.       Automating Startup.       Altering the Database State.       Setting Restricted Mode.       Setting Read-Only Mode.     Shutting Down the Database.       SHUTDOWN NORMAL.       SHUTDOWN TRANSACTIONAL.       SHUTDOWN IMMEDIATE.       SHUTDOWN ABORT.       Shutting Down and Starting Up Using OEM.     Managing the Instance by Monitoring the Diagnostic Files.       Alert Log.       Background Trace Files.       User Trace Files.     Exam Prep Questions.     Need to Know More? 5. Data Dictionary Content and Usage.     Oracle's Data Dictionary.     How the Data Dictionary Is Used.       Program Units.       Views on Base Tables.     Accessing Data Dictionary and Dynamic Performance Views.       Fast Access of the Data Dictionary.     Creating the Data Dictionary.       Running the Catalog Scripts.       Running the catproc.sql Script.     Common Views and Their Uses.     Exam Prep Questions.     Need to Know More? 6. Storage Structure and Relationships.     Segments.       Table Segments.       Table Partition Segment.       Cluster Segments.       Index Segments.       Index-Organized Table.       Index Partition.       Undo Segment.       Temporary Segment.       LOB Segment.       Nested Table Segment.       Bootstrap Segment.     Extents.     Database Data Blocks.       Automatic Segment Space Management.       Manual Segment Space Management.       Data Block Layout.     Block Utilization Parameter.       INITRANS.       MAXTRANS.       PCTFREE.       PCTUSED.     Storage Structure Information in the Data Dictionary.       DBA_TABLESPACES.       DBA_DATA_FILES.       DBA_SEGMENTS.       DBA_EXTENTS.       DBA_FREE_SPACE.     Exam Prep Questions.     Need to Know More? 7. Globalization Support.     Globalization Support.     Character Sets and Encoding Schemes.       Single-Byte Character Sets.       Varying-Width Multibyte Character Sets.       Fixed-Width Multibyte Character Sets.       Unicode Character Set.     Database Character Set.     National Character Set.       Should You Use Unicode?     Language-Dependent Behavior Specification.       Initialization Parameters.       NLS_LANGUAGE.       NLS_TERRITORY.     Setting Environment Variables.       Working with NLS_LANG.       Using ALTER SESSION to Set Environment Variables.     Linguistic Sorting.       Binary Sorting.       Monolingual Sorting.       Multilingual Sorting.     Language-Dependent Application Behavior.       Linguistic Index Support.       Importing and Loading Data Using NLS.     Globalization Support Information in the Data Dictionary.       V$NLS_PARAMETERS.     Globalization Support Utilities.       Oracle Locale Builder.       Character Set Scanner.     Exam Prep Questions. 8. Maintaining Control Files.     What Are Control Files?       Uses of the Control Files.       Contents of the Control Files.     Multiplexing Control Files.       Multiplexing Using SPFILE.       Multiplexing Using PFILE.     The CREATE CONTROLFILE Command.       CREATE CONTROLFILE Parameters and Options.       CREATE CONTROLFILE Troubleshooting.     Dropping Control Files.     Backing Up the Control File.     Obtaining Control File Information.     Control File-Related Parameters.     Managing the Control File with OMF.     Exam Prep Questions. 9. Maintaining Redo Log Files.     Purpose of Online Redo Log Files.     Structure of Online Redo Log Files.       Online Redo Log Groups.       Online Redo Log Members.       Creating the Initial Redo Log Files.       How Redo Logs Work.     Control Log Switches and Checkpoints.       Log Switches.       Checkpoints.       Force Log Switch.       Force Checkpoint.     Multiplexing and Maintaining Online Redo Log Files.       Adding a Log File Member to a Group.       Optimum Number of Online Redo Log Files.       Location, Location, Location.       Sizing the Redo Log Files.       Dropping Redo Log Groups.       Clearing Online Redo Logs.       Relocating and Renaming Online Redo Logs.     Using OEM to Maintain Redo Log Groups and Members.       Adding Redo Log Groups.       Dropping Redo Log Groups.       Relocating and Renaming Redo Log Members.     Managing Redo Log Files with OMF.     Data Dictionary Redo Information.     Archived Redo Log Files.       NOARCHIVELOG Mode.       ARCHIVELOG Mode.       LOG_ARCHIVE_START.       Archiver Information in the Data Dictionary.       Obtaining Archiver Information from OEM.     Exam Prep Questions. 10. Managing Tablespaces and Data Files.     Logical Structure of the Database.       Managing Tablespace Status.     Types of Tablespaces.       Undo Tablespace.       Temporary Tablespaces.       Default Temporary Tablespaces.     Creating Tablespaces.      Dropping Tablespaces.     Space Management in Tablespaces.       Locally Managed Tablespaces.       Dictionary Managed Tablespaces.     Changing the Size of the Tablespace.       Resizing a Tablespace.       Moving Data Files with ALTER TABLESPACE.        Moving Data Files with ALTER DATABASE.     Manipulating Tablespaces and Data Files with OEM.       Changing the Storage Settings.       Creating a Temporary Tablespace.       Bringing a Tablespace Offline or Online.       Dropping a Tablespace.       Enabling or Disabling AUTOEXTEND.       Adding a Data File.       Creating a Tablespace.     Implementing Oracle Managed Files (OMF).     Data Dictionary Tablespace and Data File Information.     Exam Prep Questions.     Need to Know More? 11. Managing Undo Data.     Logical Structure of Undo Segments in the Database.     Purpose of Undo Data.       Transaction Rollback.       Transaction Recovery.       Read Consistency.       Transaction Read Consistency.     Types of Undo Data.       SYSTEM.       Non-SYSTEM.       Deferred.     Implementing Automatic Undo Management.       Altering the Undo Tablespace.       Switching Undo Tablespaces.       Dropping an Undo Tablespace.       Automatic Undo Management Parameters.       Sizing the Undo Tablespace.       Undo Quota.     Data Dictionary Information on Undo.     Exam Prep Questions. 12. Managing Tables.     Methods of Storing Data.       Regular Tables.       Partitioned Tables.       Index-Organized Tables.       Cluster Tables.     Oracle Data Types.       User-Defined Data Types.       Built-In Data Types.       Collection Data.       Relationship Data Types.       Extended Versus a Restricted ROWID.       Restricted ROWID.       Extended ROWID.     Structure of a Row.     Creating Regular and Temporary Tables.       Temporary Table Creation.     External Tables.     Managing Storage Structures.       Manually Allocating Extents.     Regular Table Operations.       Reorganizing Tables.       Redefining Tables.       Moving Tables.       Truncating Tables.       Dropping Tables.     Column Operations.       Dropping a Column.       Unused Columns.       Adding Columns.       Altering Columns.     Data Dictionary Information on Tables.     Exam Prep Questions. 13. Managing Indexes.     Different Types of Indexes and Their Uses.       Logical Index Classifications.       Physical Index Classifications.     Creating Indexes. Criteria for Creating an Index. Creating a B-Tree Index. Using OEM to Create a B-Tree Index. Creating a Bitmap Index.     Changing Storage Parameters for Indexes.     Reorganizing Indexes.       Rebuilding Indexes.       Coalescing Indexes.       Validating Indexes.       Drop Indexes.     Index Information in the Data Dictionary.     Exam Prep Questions. 14. Maintaining Data Integrity.     Defining Data Integrity.       Application Code.       Database Triggers.       Integrity Constraints.       Guidelines for Using Constraints.     Implementing Data Integrity Constraints.       Foreign Keys.        Defining Constraints at Table Creation Time.       Table Constraints.     Maintaining Integrity Constraints.       Enabling Constraints.       Using the EXCEPTIONS Table.     Constraint Information in the Data Dictionary.     Exam Prep Questions. 15. Managing Users.     Creating New Users.       Database Authentication.       External Authentication.       User Account Defaults.     Altering Users.     Dropping Users.     User Information in the Data Dictionary.     Exam Prep Questions. 16. Managing Password Security and Resources.     Manage Passwords Using Profiles.       DEFAULT Profile.       Profile Usage.       Passwords.     Administering Profiles.       Creating Profiles.       Assigning Profiles.       Altering Profiles.       Dropping Profiles.     Controlling Resources Using Profiles.     Managing Resource Plans and Consumer Groups.       Oracle Database Resource Manager.       Enabling Database Resource Manager.     Data Dictionary Information About Profiles, Password, Management, and Resources.     Exam Prep Questions. 17. Managing Privileges.     System Privileges.       Special System Roles.     Object Privileges.     Auditing Capabilities.       Moving the Audit Trail Out of the SYSTEM Tablespace.       Auditing Categories.       Enabling and Disabling Auditing.       Audit Options.       Statement Execution.       Audit Data Generation.       Reviewing Audit Information.       Fine-Grained Auditing.     Data Dictionary Information.     Exam Prep Questions. 18. Managing Roles.     Creating and Modifying Roles.       Granting Privileges to Roles.       Application Roles.     Granting Roles.       Default Roles.     Controlling Availability of Roles.     Removing Roles.     Using Predefined Roles.       Enabling and Disabling Roles.     Role Creation Guidelines.       Using Passwords with Roles.     Role Information in the Data Dictionary.     Exam Prep Questions. 19. Practice Exam 1. 20. Exam 1 Answers. 21. Practice Exam 2. 22. Exam 2 Answers. Appendix A. CD Contents and Installation Instructions.     Multiple Test Modes.       Study Mode.       Certification Mode.       Custom Mode.       Adaptive Mode.       Missed Question Mode.       Non-Duplicate Mode.     Question Types.     Random Questions and Order of Answers.     Detailed Explanations of Correct and Incorrect Answers.     Attention to Exam Objectives.     Installing the CD.       Creating a Shortcut to the MeasureUp Practice Tests.     Technical Support. Appendix B. Glossary. Appendix C. Need to Know More?     Part 1: Oracle Architectural Components.     Part 2: Getting Started with the Oracle Server.     Part 3: Creating a Database.     Part 4: Managing an Instance.     Part 5: Data Dictionary Content and Usage.     Part 6: Storage Structure and Relationships.     Part 7: Globalization Support.     Part 8: Maintaining Control Files.     Part 9: Maintaining Redo Log Files.     Part 10: Managing Tablespaces and Data Files.     Part 11: Managing Undo Data.     Part 12: Managing Tables.     Part 13: Managing Indexes.      Part 14: Maintaining Data Integrity.     Part 15: Managing Users.     Part 16: Managing Password Security and Resources.     Part 17: Managing Privileges.     Part 18: Managing Roles. Index.

About the Author :
April Wells is Senior Oracle DBA, Oracle APPS DBA, and DB2 DBA for CS Stars, an insurance claims processing and risk management ASP in Amarillo, Texas. She holds an Oracle 8, 8i, and 9i OCP and has taken numerous database and Oracle-specific classes. Her background includes experience with IMS databases; DB2; SQL Server; Oracle 8, 8i, and 9i; and dBase; working as a webmaster and Linux System Administrator as well as a Cobol programmer; Oracle Forms designer; and Visual Basic programmer. April has presented at IOUG and has recently published Oracle 11i E-Business Suite from the Front Lines, Grid Database Design, and several articles on databases for InformIT. She is working on two more books (Grid Applications Design and Oracle 9i/10i Data Warehouse Field Guide). She graduated with a BS in Information Science from the University of Pittsburgh's School of Library and Information Sciences and earned her MBA from the Texas A&M University System.


Best Sellers


Product Details
  • ISBN-13: 9780789732651
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Pearson IT Certification
  • Height: 100 mm
  • No of Pages: 544
  • Weight: 100 gr
  • ISBN-10: 0789732653
  • Publisher Date: 16 Dec 2004
  • Binding: SA
  • Language: English
  • Spine Width: 100 mm
  • Width: 100 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Oracle 9i Fundamentals I Exam Cram 2
Pearson Education (US) -
Oracle 9i Fundamentals I Exam Cram 2
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Oracle 9i Fundamentals I Exam Cram 2

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!