Tópicos do Exame 1Z0-43
Using Globalization Support Objectives |
|
| [ ] | Customize language-dependent behavior for the database and individual sessions |
| [ ] | Specify different linguistic sorts for queries |
| [ ] | Use datatime datatypes |
| [ ] | Query data using case insensitive and accent insensitive searches |
| [ ] | Obtain Globalization support configuration information |
Configuring Recovery Manager |
|
| [ ] | Configure database parameters that affect RMAN operations |
| [ ] | Change RMAN default settings with CONFIGURE |
| [ ] | Manage RMAN's persistent settings |
| [ ] | Start RMAN utility and allocate channels |
Recovering from User Errors |
|
| [ ] | Recover a dropped table using Flashback technology |
| [ ] | Perform Flashback table operation |
| [ ] | Manage the recycle bin |
| [ ] | Recover from user errors using Flashback versions query |
| [ ] | Perform transaction level recovery using Flashback Transaction query |
Dealing with Database Corruption |
|
| [ ] | Define block corruption and list its causes and symptoms |
| [ ] | Detect
database corruptions using the following utilities: ANALYZE DBVERIFY |
| [ ] | Detect database corruptions using the dbms_repair package |
| [ ] | Implement the DB_BLOCK_CHECKING parameter to detect corruptions |
| [ ] | Repair corruptions using RMAN |
Automatic Database Management |
|
| [ ] | Use the Database Advisors to gather information about your database |
| [ ] | Use the SQL Tuning Advisor to improve database performance |
| [ ] | Use automatic undo retention tuning |
Using Recovery Managerv |
|
| [ ] | Use the RMAN BACKUP command to create backup sets and image copies |
| [ ] | Enable block change tracking |
| [ ] | Manage the backups and image copies taken with RMAN with the LIST and REPORT commands |
Recovering from Non-Critical Losses |
|
| [ ] | Recover temporary tablespaces |
| [ ] | Recover a redo log group member |
| [ ] | Recover index tablespaces |
| [ ] | Recover read-only tablespaces |
| [ ] | Recreate the password file |
Monitoring and Managing Storage |
|
| [ ] | Tune redo writing and archiving operations |
| [ ] | Issue statements that can be suspended upon encountering space condition errors |
| [ ] | Reduce space-related error conditions by proactively managing tablespace usage |
| [ ] | Reclaim wasted space from tables and indexes using the segment shrink functionality |
| [ ] | Estimate the size of new table and indexes |
| [ ] | Use different storage options to improve the performance of queries |
| [ ] | Rebuild indexes online |
Automatic Storage Management |
|
| [ ] | Set up initialization parameter files for ASM and database instances |
| [ ] | Execute SQL commands with ASM file names |
| [ ] | Start up and shut down ASM instances |
| [ ] | Administer ASM disk groups |
| [ ] | Use RMAN to migrate your database to ASM |
Monitoring and Managing Memory |
|
| [ ] | Implement Automatic Shared Memory Management |
| [ ] | Manually configure SGA parameters for various memory components in the SGA |
| [ ] | Use Automatic PGA Memory Management |
Database Recovery |
|
| [ ] | Recover the control file |
| [ ] | Explain reasons for incomplete recovery |
| [ ] | Perform incomplete recovery using EM |
| [ ] | Perform incomplete recovery using RMAN |
| [ ] | Perform incomplete recovery using SQL |
| [ ] | Perform database recovery following a RESETLOGS operation |
Flashback Database |
|
| [ ] | Determine which flashback technology to use for each recovery situation |
| [ ] | Configure and use Flashback Database |
| [ ] | Monitor the Flashback Database |
| [ ] | Use the Enterprise Manager Recovery Wizard to flashback database |
| [ ] | Manage (or maintain) the Flash Recovery Area |
Managing Resources |
|
| [ ] | Configure the Resource Manager |
| [ ] | Assign users to Resource Manager groups |
| [ ] | Create resource plans within groups |
| [ ] | Specify directives for allocating resources to consumer groups |
Automating Tasks with the Scheduler |
|
| [ ] | Simplify management tasks by using the Scheduler |
| [ ] | Create a job, program, schedule, and window |
| [ ] | Reuse Scheduler components for similar tasks |
| [ ] | View information about job executions and job instances |
