Yazdani, S: Oracle Certified DBA Test Prep Guide

Structure Information. Answers to the Questions in Part Three. IV. UNDERSTANDING DATABASE OBJECTS AND THEIR INTEGRITY CONSTRAINTS. 12. Managing Rollback Segments. Transactions and Rollback Segments. Types of Rollback Segments. Creating Rollback Segments. Altering the Rollback Segments' Availability. Dropping Rollback Segments. Obtaining the Rollback Segment Information. 13. Managing Temporary Segments. When and How Temporary Segments Are Allocated. Types of Temporary Segments. Guidelines for Temporary Segments. Obtaining Temporary Segment Information. 14. Managing Tables. Distinguishing Different Structures of Storing Data. Creating Tables. Guidelines for Storage Settings. Controlling the Space Used by Tables. Validating Table Structure. Partitioned Tables. Obtaining Information About Tables. 15. Managing Indexes. Different Types of Indexes and Their Uses. Comparing B*Tree and Bitmap Indexes. Creating Indexes. Reorganizing Indexes. Dropping Indexes. 16. Managing Views, Sequences, and Synonyms. Creating, Altering, and Dropping Views. Creating, Altering, and Dropping Sequences. Creating and Dropping Synonyms. 17. Managing Triggers and Integrity Constraints. Types of Triggers and Integrity Constraints. Creating Triggers and Integrity Constraints. Managing Triggers and Integrity Constraints. Obtaining Constraint and Trigger Information. Answers to the Questions in Part Four. V. MANAGING DATABASE RESOURCES. 18. Managing Clusters and Index-Organized Tables. Creating and Maintaining Clusters. Creating and Maintaining Index-Organized Tables (IOTs). Obtaining Information About Clusters and IOTs. 19. Managing Users. Session and User Licensing. Create Users. Alter and Drop Existing Users. Obtaining Information About Existing Users. 20. Managing Profiles. Creating User Profiles. Controlling the Use of Resources with Profiles. Altering and Dropping Profiles. Obtaining Information About Profiles. 21. Managing Privileges. Identifying System and Object Privileges. Granting and Revoking Privileges. Obtaining Information About Privileges. 22. Managing Roles. Creating and Modifying Roles. Altering the Availability of Roles. Using Predefined Roles. Obtaining Information About Roles. Answers to the Questions in Part Five. VI. ORACLE8 ADVANCED TOPICS AND ORACLE8I NEW FEATURES. 23. Auditing. Guidelines for Auditing. Managing Auditing. Database and Value-Based Auditing. Obtaining Information About Auditing. 24. Using National Language Support. NLS Features. Types of Encoding Schemes. Using Different Types of NLS Parameters. Specifying Language-Dependent Behavior. Obtaining Information About NLS Usage. 25. Oracle8i Features. Java in the Database. Memory Management. Indexes. Index-Organized Tables. New Object-Relational Features. LOB Enhancements. Composite Partitioning. Tablespace Enhancements. Constraint Enhancements. Database Security. PKI-Based User Authentication. Answers to the Questions in Part Six. Index.