
Certificazione Oracle Database Administration OCP I
PANORAMICA

Esame Oracle 1Z0-082;
Le certificazioni Oracle sono le più richieste dal Mondo IT nell’ambito Database. In generale questa certificazione risulta essere tra le prime 5 più ricercate dal mondo del Lavoro IT e costituisce senza nessun dubbio un elemento accreditante per ogni professionista che voglia operare nel campo dei DBA ad ogni livello. L’ottenimento di una Oracle Database Administration I attraverso l’Esame 1Z0-082 costituisce il primo step per ottenere La Certificazione Oracle Database Administration 2019 Certified Professional Certification OCP. L’ottenimento di tale certificazione permette di convalidare le competenze relative ad tutte le attività fondamentali per un Oracle DBA: installazione, configurazione, gestione dei processi e delle memorie in ottica performance ed availability 24/7, gestione accurata dei datafile che compongono il database, gestione della sicurezza e del backup e recovery dei dati, alta disponibilità e zero data-loss.
Certificazione Oracle Database Administration I
Parte della Certificazione Oracle Database Administration 2019 Certified Professional certification OCP
Esame Oracle 1Z0-082;

CORSI PROPEDEUTICI
Affrontare un esame di certificazione richiede una preparazione specifica.
Per questa certificazione consigliamo:
SVOLGIMENTO E DURATA
Esame 1Z0-082 Oracle durata 150 minuti 90 quesiti;
Negli esami sono presenti quesiti formulati in lingua inglese in forme differenti: Risposta Multipla; completamento di testo, collegamenti concettuali Drag and Drop; vere e proprie simulazioni laboratoriali.
PREREQUISITI
Nessun prerequisito.
ARGOMENTI D’ESAME
Esame Oracle 1Z0-082 – Parte SQL
- Retrieving Data using the SQL SELECT
- Statement
- Column aliases
- Use of the DESCRIBE command
- Capabilities of the SELECT statement
- Use of concatenation operator, literal character
- strings, alternative quote operator, and the DISTINCT
- keyword
- Arithmetic expressions and NULL values in the
- SELECT statement
- Restricting and Sorting Data
- Rules of precedence for operators in an expression
- Limiting the Rows
- Substitution Variables
- Using the DEFINE and VERIFY command
- Using Single-Row Functions to Customize
- Output
- Manipulate strings with character function in the
- SELECT and WHERE clauses
- Perform arithmetic with date data
- Manipulate numbers with the ROUND, TRUNC and
- MOD functions
- Manipulate dates with the date functions
- Using Conversion Functions and Conditional
- Expressions
- Apply the NVL, NULLIF, and COALESCE functions to
- data
- Describe implicit and explicit data type conversion
- Use the TO_CHAR, TO_NUMBER, and TO_DATE
- conversion functions
- Nest multiple functions
- Reporting Aggregated Data Using Group
- Functions
- Restricting Group Results
- Creating Groups of Data
- Group Functions
- Displaying Data from Multiple Tables Using
- Joins
- Self-join
- Types of Joins
- Non equijoins
- OUTER join
- Using Subqueries to Solve Queries
- Single Row Subqueries
- Multiple Row Subqueries
- Using SET Operators
- Matching the SELECT statements
- Using ORDER BY clause in set operations
- INTERSECT operator
- MINUS operator
- UNION and UNION ALL operator
- Managing Tables using DML statements
- Database Transactions
- Data Manipulation Language
- Control transactions
- Introduction to Data Definition Language
- Data Definition Language
- Creating Sequences, Synonyms, Indexes
- Overview of indexes
- Overview of synonyms
- Overview of sequences
- Creating Views
- Overview of views
- Managing Schema Objects
- Creating and using temporary tables
- Managing constraints
- Managing Data in Different Time Zones
- Working with CURRENT_DATE,
- CURRENT_TIMESTAMP and LOCALTIMESTAMP
- Working with INTERVAL data types
Esame Oracle 1Z0-082 – Parte Amministrazione
- Oracle Database Architecture
- Oracle Database Instance Configurations
- Oracle Database Memory and Process Structures
- Logical and Physical Database Structures
- Oracle Database Server Architecture
- Access an Oracle Database with Oracle supplied
- Tools
- Database Configuration Assistant (DBCA)
- Oracle Enterprise Manager Cloud Control
- Oracle enterprise Manager Database Express
- SQL Developer
- SQL Plus
- Managing Database Instances
- Starting Up Oracle Database Instances
- Data Dictionary Views
- Shutting Down Oracle Database Instances
- Dynamic Performance Views
- Automatic Diagnostic Repository (ADR)
- Alert Log and Trace Files
- Initialization Parameter Files
- Oracle Net Services
- Oracle Net Services Administration Tools
- Configuring Communication Between Database
- Instances
- Oracle Net Listener Overview
- Connecting to an Oracle Database Instance
- Comparing Dedicated and Shared Server
- Configurations
- Naming Methods
- Managing Users, Roles and Privileges
- Assigning Quotas to Users
- Applying the Principal of Least Privilege
- Creating and Assigning Profiles
- User Authentication
- Managing Oracle Database Users, Privileges, and Roles
- Managing Tablespaces and Datafiles
- Viewing Tablespace Information
- Creating, Altering and Dropping Tablespaces
- Table Data Storage
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files
- Managing Storage
- Resumable Space Allocation
- Shrinkable Segments
- Deferred Segment Creation
- Space-Saving Features
- Oracle Database Space Management Features
- Types of Segments
- Table and Row Compression
- Block Space Management
- Managing Undo
- Transactions and Undo Data
- Storing Undo Information
- Configuring Undo Rentention
- Comparing Undo Data and Redo Data
- Temporary Undo
- Moving Data
- External Tables
- Oracle Data Pump
- SQL*Loader
- Monitoring and Tuning Database Performance
- Managing Memory Components
- Automatic Workload Repository (AWR)
- Advisory Framework
- Monitoring Wait Events, Sessions, and Services
- Managing Metric Thresholds and Alerts
- Performance Tuning Methodology
- Performance Planning Considerations
- Automatic Database Diagnostic Monitor (ADDM)
- SQL Statement tuning
- Oracle Optimizer
- SQL Tuning Advisor
- Optimizer Statistics
- SQL Access Advisor
- SQL Tuning Process