Oracle 12cR2 DBA Exam Prep - Unisoft India
Exam Details
| Exam Title: |
Oracle Database 12cR2 Administration |
| Exam Number: |
1Z0-072 |
| Exam Price: |
₹10,475.00 More on exam pricing
|
| Format: |
Multiple Choice
|
| Duration: |
90 Minutes |
| Number of Questions: |
70 |
| Passing Score: |
60% |
| Validated Against: |
Course Content / Exam(s)
- 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
- Working with Initialization Parameters
- Starting Up Oracle Databases
- Shutting Down Oracle Databases
- Querying Dynamic Performance Views
- Creating Users
- Granting Privileges
- Creating and Granting Roles
- Revoking Privileges and Roles
- Creating and Assigning Profiles
- Authenticating Users
- Assigning Quotas to Users
- Oracle Net Services
- How Listeners Work
- Configuring Listeners for Dynamic Service Registration
- Configuring Local Naming for Connections
- Testing Oracle Net Connectivity with tnsping
- 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
- Types of Segments
- Allocating Extents
- Understanding Deferred Segment Creation
- Monitoring Tablespace Space Usage
- Reclaiming Space by Shrinking Segments
- Undo Data: Overview
- Configuring Undo Retention
- Guaranteeing Undo Retention
- Changing an Undo Tablespace to a Fixed Size
- Viewing Undo Information
- Viewing Undo Activity
- 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
- Loading Methods
- SQL*Loader Express Mode
- DBA Responsibities
- Categories of Failure
- Understanding Instance Recovery
- Understanding Types of Backups
- Comparing Complete and Incomplete Recovery
- Oracle Data Protection Solutions
- Flashback Technology
- Performance Management Activities
- Performance Planning Considerations
- Database Maintenance
- Managing Memory Components
- Choosing and using Appropriate Character Sets
- Using DBCA to Create and delete Databases and templates and for other tasks
- Database Cloud Service Offerings
- DBCS Architecture
- Features and Tooling
- Managing Network Access to DBCS
- Backup and Recovery tools and concepts
- Upgrading by Using the Database Upgrade Assistant (DBUA)
- Manually Upgrading to Oracle Database 12c
© 2024 Unisoft Technologies - Nagpur | Developed By In House Team