Oracle 1Z0-052

Free Questions in OTE format

About Oracle 1Z0-052 dump

Exploring the Oracle Database Architecture

• Explain the Memory Structures
  
• Describe the Process Structures
  
• Overview of Storage Structures
  

Preparing the Database Environment

• Identify the tools for Administering an Oracle Database
  
• Plan an Oracle Database installation
  
• Install the Oracle software by using Oracle Universal Installer (OUI)
  

Creating an Oracle Database

• Create a database by using the Database Configuration Assistant (DBCA)
  

Managing the Oracle Instance

• Setting database initialization parameters
  
• Describe the stages of database startup and shutdown
  
• Using alert log and trace files
  
• Using data dictionary and dynamic performance views
  

Configuring the Oracle Network Environment

• Configure and Manage the Oracle Network
  
• Using the Oracle Shared Server architecture
  

Managing Database Storage Structures

• Overview of tablespace and datafiles
  
• Create and manage tablespaces
  
• Space management in tablespaces
  

Administering User Security

• Create and manage database user accounts
  
• Grant and revoke privileges
  
• Create and manage roles
  
• Create and manage profiles
  

Managing Data and Concurrency

• Monitor and resolve locking conflicts
  

Managing Undo Data

• Overview of Undo
  
• Transactions and undo data
  
• Managing undo
  

Implementing Oracle Database Security

• Database Security and Principle of Least Privilege
  
• Work with Standard Database Auditing
  

Database Maintenance

• Use and manage optimizer statistics
  
• Use and manage Automatic Workload Repository (AWR)
  
• Use advisory framework
  
• Manage Alerts and Thresholds
  

Performance Management

• Use Automatic Memory Management
  
• Use Memory Advisors
  
• Troubleshoot invalid and unusable objects
  

Intelligent Infrastructure Enhancements

• Use the Enterprise Manager Support Workbench
  
• Managing Patches
  

Backup and Recovery Concepts

• Identify the types of failure that can occur in an Oracle database
  
• Describe ways to tune instance recovery
  
• Identify the importance of checkpoints, redo log files, and archived log files
  
• Overview of flash recovery area
  
• Configure ARCHIVELOG mode
  

Performing Database Backups

• Create consistent database backups
  
• Back up your database without shutting it down
  
• Create incremental backups
  
• Automate database backups
  
• Manage backups, view backup reports and monitor the flash recovery area
  

Performing Database Recovery

• Overview of Data Recovery Advisor
  
• Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
  

Moving Data

• Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
  
• Explain the general architecture of Oracle Data Pump
  
• Use Data Pump Export and Import to move data between Oracle databases