Oracle 1Z0-072 Preparation

Exam Name: Oracle Database 12cR2 Administration

87 Total Questions
Oct 16, 2019 updated
  • Exam Code: 1Z0-072
  • Certification Provider: Oracle

Purchase Individually

Practice Test
87 Total Question Oct 16, 2019 Updated
Questions & Answers (PDF)
87 Total Question Oct 16, 2019 Updated
Oracle Database 12cR2 Administration Exam Details
Related Certification(s) Oracle Database Certification


Free 3 month
Product Updates

100% Money Back

100% Real


Oracle 1Z0-072 Exam Major Topics

  • Exploring Oracle Database Architecture/ Introducing Oracle Database/ Relational Database Models
  • Oracle SQL and PL/SQL/ Connecting to Oracle Databases/ Oracle Database Tools/ Oracle-Supplied User Accounts
  • Querying the Oracle Data Dictionary/ Configuring the Oracle Network Environment/ Oracle Net Services/ How Listeners Work
  • Configuring Listeners for Dynamic Service Registration/ Configuring Local Naming for Connections/ Testing Oracle Net Connectivity with tnsping
  • Creating and Managing Tablespaces/ Creating Tablespaces in SQL*Plus/ Altering and Dropping Tablespaces in SQL*Plus
  • Viewing Tablespace Information in SQL*Plus/ Implementing Oracle Managed Files/ Moving or Renaming Online Data Files in SQL*Plus
  • Managing UNDO Data/ Undo Data: Overview/ Configuring Undo Retention/ Guaranteeing Undo Retention/ Changing an Undo Tablespace to a Fixed Size
  • Viewing Undo Information/ Viewing Undo Activity/ Backup and Recovery Concepts/ DBA Responsibities/ Categories of Failure/ Tuning SQL
  • Understanding Instance Recovery/ Understanding Types of Backups/ Comparing Complete and Incomplete Recovery/ Oracle Data Protection Solutions
  • Flashback Technology/ SQL Tuning Process/ Managing DBCS Database Deployments/ Managing Network Access to DBCS/ Creating an Oracle Database by Using DBCA
  • Choosing and using Appropriate Character Sets / Using DBCA to Create and delete Databases and templates and for other tasks/ Managing Database Instances
  • Working with Initialization Parameters/ Starting Up Oracle Databases/ Shutting Down Oracle Databases/ Querying Dynamic Performance Views/ Administering User Security
  • Granting Privileges/ Creating and Granting Roles/ Revoking Privileges and Roles/ Creating and Assigning Profiles/ Authenticating Users/ Assigning Quotas to Users
  • Managing Storage Space/ Types of Segments/ Allocating Extents/ Understanding Deferred Segment Creation/ Monitoring Tablespace Space Usage/ Reclaiming Space by Shrinking Segments
  • Moving Data: General Architecture/ Oracle Data Pump: Overview/ Oracle Data Pump: Benefits/ Data Pump Export and Import Clients/ Data Pump Utility: Interfaces and Modes
  • SQL*Loader Overview/ SQL*Loader Express Mode/ Monitoring and Tuning Database Performance/ Performance Management Activities/ Performance Planning Considerations
  • Managing Memory Components/ Introduction to Oracle Database Cloud Service/ Database Cloud Service Offerings/ DBCS Architecture/ Backing Up and Restoring DBCS Database Deployments
  • Backup and Recovery tools and concepts/ Upgrading to Oracle Database 12c/ Upgrading by Using the Database Upgrade Assistant (DBUA)/ Manually Upgrading to Oracle Database 12c

Latest Preparation Material by ExamsTrainer

Corporate / Trainer License Program