OCA/OCP Oracle Database 11g All-in-One Exam Guide- P4

OCA /OCP Oracle Database 11g A ll-in-One Exam Guide- P4: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 xxiv Chapter 22 The Scheduler . 805 Exam Objectives . 805 The Scheduler Architecture . 806 Scheduler Objects . 807 Jobs . 807 Programs . 809 Schedules . 809 Job Classes . 810 Windows . 811 Privileges . 812 Creating and Scheduling Jobs . 813 A Self-Contained Job . 813 Using Programs and Schedules . 814 Event-Driven Jobs . 817 Job Chains . 819 Lightweight Jobs . 819 Using Classes Windows and the Resource Manager . 822 Using Job Classes . 823 Using Windows . 824 Two-Minute Drill . 826 Create a Job Program and Schedule . 826 Use a Time-Based or Event-Based Schedule for Executing Scheduler Jobs . 826 Create Lightweight Jobs . 826 Use Job Chains to Perform a Series of Related Tasks . 826 Create Windows and Job Classes . 827 Use Advanced Scheduler Concepts to Prioritize Jobs . 827 Self Test . 827 Self Test Answers . 829 Chapter 23 Moving and Reorganizing Data . 831 Exam Objectives . 831 SQL Loader . 832 External Tables . 834 Directories . 835 Using External Tables . 835 Data Pump . 838 Data Pump Architecture . 839 Directories and File Locations . 840 Direct Path or External Table Path . 840 Using Data Pump Export and Import . 841 Capabilities . 841 Using Data Pump with the Command-Line Utilities . 842 Using Data Pump with Database Control . 843 Tablespace Export and Import . 845 Resumable Space Allocation . 850 Contents xxv Segment Reorganization . 852 Row Chaining and Migration . 853 Segment Shrink . 855 Two-Minute Drill . 859 Describe and Use Methods to Move Data Directory Objects SQL Loader External Tables . 859 Explain the General Architecture of Oracle Data Pump . 860 Use Data Pump Export and Import to Move Data Between Oracle Databases . 860 Describe the Concepts of Transportable Tablespaces and Databases . 860 Manage Resumable Space Allocation . 860 Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality . 861 Self Test . 861 Self Test Answers . 863 Chapter 24 The AWR and the Alert .