000			06161cam a22004217a 4500
001			ocm12746429
005			20240430143926.0
007			ta
008			050916s2002 nyua 001 0 eng d
010			_a 2002280108
020			_a0072195401
035			_a(OCoLC)ocm48962137
040			_aOCC _cOCC _dDLC
042			_alccopycat
090			_aQA 76.3 .O37 2002 v.1
100	1		_aCouchman, Jason S. _971376
245	1	0	_aOCP Oracle9i database : _bfundamentals I exam guide / _cJason S. Couchman, Sudheer N. Marisetti.
246	1	0	_aFundamentals I exam guide
260			_aNew York : _bOsborne/McGraw-Hill, _cc2002.
300			_axxvii, 524 p. : _bill. ; _c24 cm. + _e1 CD-ROM (4 3/4 in.)
500			_a"Oracle."
500			_a"Oracle Press."
505	0		_aPreparing 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			_aPrepare 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	0	0	_aOracle (Computer file) _971319
650		0	_aElectronic data processing personnel _xCertification. _971377
650		0	_aDatabase management _xExaminations _vStudy guides. _971378
700	1		_aMarisetti, Sudheer N. _971379
740	0	2	_aOCP Oracle 9i database
852			_y08-11-2002
907			_a12667 _b08-06-10 _c08-06-10
942			_cBOOK _00
998			_aaudmc _b08-11-02 _cm _da _e- _feng _gnyu _h0
906			_a0 _bibc _ccopycat _d2 _encip _f20 _gy-gencatlg
925	0		_aacquire _b2 shelf copies _xpolicy default
945			_g0 _i627562 _j0 _laudmc _nCopy Type:01 - Books _o- _p0.00 _q- _r- _s- _t1 _u0 _v0 _w0 _x0 _yi10180448 _z08-06-10
999			_c12667 _d12667