OCA /OCP Oracle Database 11g A ll-in-One Exam Guide- P5:There is an ever increasing demand for staff with IT industry certification. The benefits to employers are significant—they can be certain that staff have a certain level of competence—and the benefits to the individuals, in terms of demand for their services, are equally great. Many employers are now requiring technical staff to have certifications, and many IT purchasers will not buy from firms that do not have certified staff. | OCA OCP Oracle Database 11g All-in-One Exam Guide xxxiv ID Name Chapter Creating an Oracle Database Create a database by using the Database Configuration Assistant DBCA 2 Managing the Oracle Instance Setting database initialization parameters 3 Describe the stages of database startup and shutdown 3 Using alert log and trace files 3 Using data dictionary and dynamic performance views 3 Configuring the Oracle Network Environment Configure and manage the Oracle network 4 Using the Oracle Shared Server architecture 4 Managing Database Storage Structures Overview of tablespace and datafiles 5 Create and manage tablespaces 5 Space management in tablespaces 5 Administering User Security Create and manage database user accounts 6 Grant and revoke privileges 6 Create and manage roles 6 Create and manage profiles 6 Managing Schema Objects Create and modify tables 7 Manage constraints 7 Create indexes 7 Create and use temporary tables 7 Managing Data and Concurrency Manage data using DML 8 Identify and administer PL SQL objects 8 Monitor and resolve locking conflicts 8 Managing Undo Data Overview of undo 8 Transactions and undo data 8 Managing undo 8 Implementing Oracle Database Security Database security and the principle of least privilege 6 Introduction xxxv ID Name Chapter Work with standard database auditing 6 Database Maintenance Use and manage optimizer statistics 24 Use and manage Automatic Workload Repository AWR 24 Use advisory framework 24 Manage alerts and thresholds 24 Performance Management Use Automatic Memory Management 25 Use Memory Advisors 25 Troubleshoot invalid and unusable objects 25 Backup and Recovery .
