Test Exam 1ZO-082 – Oracle Database Administration I

Descrição

Descrição:

Become an Oracle Database 19c Administrator I

Test Exam 1ZO-082 – Oracle Database Administration I

Oracle Database Administration 2019 Certified Professional

Certification Details

• Credential Awarded: Oracle Database Administration 2019 Certified Professional

• Exam Numbers: 1Z0-082

• Target Audience: Oracle Database Administrators

• Platform: Delivered via Pearson VUE

• Digital Badge: Oracle Certified Professional – 2019 Database Administrator

Understanding Oracle Database Architecture – Oracle Database: Administration Workshop

• Understanding Oracle Database Instance Configurations

• Understanding Oracle Database Memory and Process Structures

• Understanding Logical and Physical Database Structures

• Understanding Oracle Database Server Architecture

Managing Database Instances – Oracle Database: Administration Workshop

• Starting Up Oracle Database Instances

• Using Data Dictionary Views

• Shutting Down Oracle Database Instances

• Using Dynamic Performance Views

• Using the Automatic Diagnostic Repository (ADR)

• Using the Alert Log and Trace Files

• Managing Initialization Parameter Files

Managing Users, Roles and Privileges – Oracle Database: Administration Workshop

• Assigning Quotas to Users

• Applying the Principal of Least Privilege

• Creating and Assigning Profiles

• Administering User Authentication Methods

• Managing Oracle Database Users, Privileges, and Roles

Managing Storage – Oracle Database: Administration Workshop

• Managing Resumable Space Allocation

• Shrinking Segments

• Deferring Segment Creation

• Using Space-Saving Features

• Deploying Oracle Database Space Management Features

• Managing Different Types of Segments

• Using Table and Row Compression

• Understanding Block Space Management

Moving Data – Oracle Database: Administration Workshop

• Using External Tables

• Using Oracle Data Pump

• Using SQL*Loader

Accessing an Oracle Database with Oracle supplied Tools – Oracle Database: Administration Workshop

• Using the Database Configuration Assistant (DBCA)

• Using Oracle Enterprise Manager Cloud Control

• Using racle enterprise Manager Database Express

• Using SQL Developer

• Using SQL Plus

Configuring Oracle Net Services – Oracle Database: Administration Workshop

• Using Oracle Net Services Administration Tools

• Configuring Communication Between Database Instances

• Configuring the Oracle Net Listener

• Connecting to an Oracle Database Instance

• Comparing Dedicated and Shared Server Configurations

• Administering Naming Methods

Managing Tablespaces and Datafiles – Oracle Database: Administration Workshop

• Viewing Tablespace Information

• Creating, Altering and Dropping Tablespaces

• Managing Table Data Storage

• Implementing Oracle Managed Files

• Moving and Renaming Online Data Files

Managing Undo – Oracle Database: Administration Workshop

• Understanding Transactions and Undo Data

• Storing Undo Information

• Configuring Undo Rentention

• Comparing Undo Data and Redo Data

• Understanding Temporary Undo

Restricting and Sorting Data – Oracle Database: Introduction to SQL

• Applying Rules of precedence for operators in an expression

• Limiting Rows Returned in a SQL Statement

• Using Substitution Variables

• Using the DEFINE and VERIFY commands

Using Conversion Functions and Conditional Expressions – Oracle Database: Introduction to SQL

• Applying the NVL, NULLIF, and COALESCE functions to data

• Understanding implicit and explicit data type conversion

• Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

• Nesting multiple functions

Displaying Data from Multiple Tables Using Joins – Oracle Database: Introduction to SQL

• Using Self-joins

• Using Various Types of Joins

• Using Non equijoins

• Using OUTER joins

Using SET Operators – Oracle Database: Introduction to SQL

• Matching the SELECT statements

• Using the ORDER BY clause in set operations

• Using The INTERSECT operator

• Using The MINUS operator

• Using The UNION and UNION ALL operators

Understanding Data Definition Language – Oracle Database: Introduction to SQL

• Using Data Definition Language

Managing Views – Oracle Database: Introduction to SQL

• Managing Views

Managing Data in Different Time Zones – Oracle Database: Introduction to SQL

• Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP

• Working with INTERVAL data types

Retrieving Data using the SQL SELECT Statement – Oracle Database: Introduction to SQL

• Using Column aliases

• Using The DESCRIBE command

• Using The SQL SELECT statement

• Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

• Using Arithmetic expressions and NULL values in the SELECT statement

Using Single-Row Functions to Customize Output – Oracle Database: Introduction to SQL

• Manipulating strings with character functions in SQL SELECT and WHERE clauses

• Performing arithmetic with date data

• Manipulating numbers with the ROUND, TRUNC and MOD functions

• Manipulating dates with the date function

Reporting Aggregated Data Using Group Functions – Oracle Database: Introduction to SQL

• Restricting Group Results

• Creating Groups of Data

• Using Group Functions

Using Subqueries to Solve Queries – Oracle Database: Introduction to SQL

• Using Single Row Subqueries

• Using Multiple Row Subqueries

Managing Tables using DML statements – Oracle Database: Introduction to SQL

• Managing Database Transactions

• Using Data Manipulation Language

• Controlling transactions

Managing Sequences, Synonyms, Indexes – Oracle Database: Introduction to SQL

• Managing Indexes

• Managing Synonyms

• Managing Sequences

Managing Schema Objects – Oracle Database: Introduction to SQL

• Creating and using temporary tables

• Managing constraints