Đang chuẩn bị liên kết để tải về tài liệu:
OCA/OCP Oracle Database 11g All-in-One Exam Guide- P5

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

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 052.3 Creating an Oracle Database 052.3.1 Create a database by using the Database Configuration Assistant DBCA 2 052.4 Managing the Oracle Instance 052.4.1 Setting database initialization parameters 3 052.4.2 Describe the stages of database startup and shutdown 3 052.4.3 Using alert log and trace files 3 052.4.4 Using data dictionary and dynamic performance views 3 052.5 Configuring the Oracle Network Environment 052.5.1 Configure and manage the Oracle network 4 052.5.2 Using the Oracle Shared Server architecture 4 052.6 Managing Database Storage Structures 052.6.1 Overview of tablespace and datafiles 5 052.6.2 Create and manage tablespaces 5 052.6.3 Space management in tablespaces 5 052.7 Administering User Security 052.7.1 Create and manage database user accounts 6 052.7.2 Grant and revoke privileges 6 052.7.3 Create and manage roles 6 052.7.4 Create and manage profiles 6 052.8 Managing Schema Objects 052.8.1 Create and modify tables 7 052.8.2 Manage constraints 7 052.8.3 Create indexes 7 052.8.4 Create and use temporary tables 7 052.9 Managing Data and Concurrency 052.9.1 Manage data using DML 8 052.9.2 Identify and administer PL SQL objects 8 052.9.3 Monitor and resolve locking conflicts 8 052.10 Managing Undo Data 052.10.1 Overview of undo 8 052.10.2 Transactions and undo data 8 052.10.3 Managing undo 8 052.11 Implementing Oracle Database Security 052.11.1 Database security and the principle of least privilege 6 Introduction xxxv ID Name Chapter 052.11.2 Work with standard database auditing 6 052.12 Database Maintenance 052.12.1 Use and manage optimizer statistics 24 052.12.2 Use and manage Automatic Workload Repository AWR 24 052.12.3 Use advisory framework 24 052.12.4 Manage alerts and thresholds 24 052.13 Performance Management 052.13.1 Use Automatic Memory Management 25 052.13.2 Use Memory Advisors 25 052.13.3 Troubleshoot invalid and unusable objects 25 052.14 Backup and Recovery .