| 000 -LEADER | |
|---|---|
| fixed length control field | 06161cam a22004217a 4500 |
| 001 - CONTROL NUMBER | |
| control field | ocm12746429 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20240430143926.0 |
| 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION | |
| fixed length control field | ta |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 050916s2002 nyua 001 0 eng d |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER | |
| LC control number | 2002280108 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0072195401 |
| 035 ## - SYSTEM CONTROL NUMBER | |
| System control number | (OCoLC)ocm48962137 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | OCC |
| Transcribing agency | OCC |
| Modifying agency | DLC |
| 042 ## - AUTHENTICATION CODE | |
| Authentication code | lccopycat |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC) | |
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) | QA 76.3 .O37 2002 v.1 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Couchman, Jason S. |
| 9 (RLIN) | 71376 |
| 245 10 - TITLE STATEMENT | |
| Title | OCP Oracle9i database : |
| Remainder of title | fundamentals I exam guide / |
| Statement of responsibility, etc | Jason S. Couchman, Sudheer N. Marisetti. |
| 246 10 - VARYING FORM OF TITLE | |
| Title proper/short title | Fundamentals I exam guide |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc | New York : |
| Name of publisher, distributor, etc | Osborne/McGraw-Hill, |
| Date of publication, distribution, etc | c2002. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xxvii, 524 p. : |
| Other physical details | ill. ; |
| Dimensions | 24 cm. + |
| Accompanying material | 1 CD-ROM (4 3/4 in.) |
| 500 ## - GENERAL NOTE | |
| General note | "Oracle." |
| 500 ## - GENERAL NOTE | |
| General note | "Oracle Press." |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Preparing for OCP Database Administration Fundamentals I Exam -- Basics of the Oracle Database Architecture -- Oracle Architectural 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 Oracle 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 Oracle Database -- Prerequisites for Database Creation -- Creating Databases Using Database Configuration Assistant -- Creating a Database Manually -- Managing the Physical Database Structure -- Data Dictionary Content and Usage -- Constructing the Data Dictionary Views -- Key Data Dictionary Components and Contents -- Querying the Data Dictionary -- Maintaining Control Files -- How Control Files Are Used -- Examining Control File Contents -- Managing Control Files with Oracle-Managed Files -- Obtaining Information about Control Files -- Multiplexing Control Files -- Maintaining Redo Log Files -- The Purpose and Structure of Online Redo Logs -- Controlling Log Switches and Checkpoints -- Multiplexing and Maintaining Redo Log Files -- Managing Online Redo Log Files with OMF -- Managing Tablespaces and Datafiles -- Describing the Logical 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) -- Storage Structures and Undo Data -- Storage Structures and Relationships -- Different Segment Types and Their Uses -- Controlling the Use of Extents by Segments -- Using Block 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 -- Managing Database Objects -- Managing Tables -- 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 -- 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 -- OCP Oracle9i DBA Fundamentals I Practice Exams -- OCP Database Administration Fundamentals I -- Globalization Support -- Choosing a Database and a National Character Set for a Database -- Specifying Language-Dependent Behavior -- NLS Parameters. |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc | Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals I exam -- a required exam for Oracle9i DBA certification -- using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Fundamentals I exam. |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | Oracle (Computer file) |
| 9 (RLIN) | 71319 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Electronic data processing personnel |
| General subdivision | Certification. |
| 9 (RLIN) | 71377 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Database management |
| General subdivision | Examinations |
| Form subdivision | Study guides. |
| 9 (RLIN) | 71378 |
| 700 1# - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Marisetti, Sudheer N. |
| 9 (RLIN) | 71379 |
| 740 02 - ADDED ENTRY--UNCONTROLLED RELATED/ANALYTICAL TITLE | |
| Uncontrolled related/analytical title | OCP Oracle 9i database |
| 852 ## - LOCATION/CALL NUMBER | |
| -- | 08-11-2002 |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | |
| b | 08-06-10 |
| c | 08-06-10 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | Books |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| -- | audmc |
| Operator's initials, OID (RLIN) | 08-11-02 |
| Cataloger's initials, CIN (RLIN) | m |
| First Date, FD (RLIN) | a |
| -- | - |
| -- | eng |
| -- | nyu |
| -- | 0 |
| 906 ## - LOCAL DATA ELEMENT F, LDF (RLIN) | |
| a | 0 |
| b | ibc |
| c | copycat |
| d | 2 |
| e | ncip |
| f | 20 |
| g | y-gencatlg |
| 925 0# - | |
| -- | acquire |
| -- | 2 shelf copies |
| -- | policy default |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| g | 0 |
| i | 627562 |
| j | 0 |
| l | audmc |
| n | Copy Type:01 - Books |
| o | - |
| p | 0.00 |
| q | - |
| r | - |
| s | - |
| t | 1 |
| u | 0 |
| v | 0 |
| w | 0 |
| x | 0 |
| y | i10180448 |
| z | 08-06-10 |
| Lost status | Source of classification or shelving scheme | Materials specified (bound volume or other part) | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Cost, normal purchase price | Total Checkouts | Full call number | Barcode | Date last seen | Cost, replacement price | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Library of Congress Classification | Copy Type:01 - Books | American University in Dubai | American University in Dubai | Main Collection | 2010-08-06 | 0.00 | QA 76.3 .O37 2002 v.1 | 627562 | 2023-12-01 | 0.00 | 2015-07-25 | Books |