1. Home
  2. Oracle
  3. 1Z0-082 Exam Syllabus

Oracle 1Z0-082 Exam Syllabus

Start Free 1Z0-082 Exam Practice After Reviewing the Topics

Before starting your 1Z0-082 exam preparation, it is recommended to review the complete Oracle Database Administration I exam syllabus and carefully go through the exam objectives listed below. Once you understand the exam structure and objectives, you should practice using our free 1Z0-082 questions. We also provide premium 1Z0-082 practice test, fully updated according to the latest exam objectives, to help you accurately assess your preparedness for the actual exam.

Oracle
Vendor
1Z0-082
Exam Code
142
Total Questions
23
Total Exam Domains

START FREE 1Z0-082 EXAM PRACTICE

NO SIGNUP REQUIRED  •  100% FREE TO START

1Z0-082 EXAM QUESTIONS

Oracle 1Z0-082 Exam Objectives

Section 1: Understanding Oracle Database Architecture - Oracle Database: Administration Workshop
Weight:
-
  •     Understanding Oracle Database Instance Configurations
  •     Understanding Oracle Database Memory and Process Structures
  •     Understanding Logical and Physical Database Structures
  •     Understanding Oracle Database Server Architecture
Section 2: Managing Database Instances - Oracle Database: Administration Workshop
Weight:
-
  •     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
Section 3: Managing Users, Roles and Privileges - Oracle Database: Administration Workshop
Weight:
-
  •     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
Section 4: Managing Storage - Oracle Database: Administration Workshop
Weight:
-
  •     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
Section 5: Moving Data - Oracle Database: Administration Workshop
Weight:
-
  •     Using External Tables
  •     Using Oracle Data Pump
  •     Using SQL*Loader
Section 6: Accessing an Oracle Database with Oracle supplied Tools - Oracle Database: Administration Workshop
Weight:
-
  •     Using the Database Configuration Assistant (DBCA)
  •     Using Oracle Enterprise Manager Cloud Control
  •     Using racle enterprise Manager Database Express
  •     Using SQL Developer
  •     Using SQL Plus
Section 7: Configuring Oracle Net Services - Oracle Database: Administration Workshop
Weight:
-
  •     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
Section 8: Managing Tablespaces and Datafiles - Oracle Database: Administration Workshop
Weight:
-
  •     Viewing Tablespace Information
  •     Creating, Altering and Dropping Tablespaces
  •     Managing Table Data Storage
  •     Implementing Oracle Managed Files
  •     Moving and Renaming Online Data Files
Section 9: Managing Undo - Oracle Database: Administration Workshop
Weight:
-
  •     Understanding Transactions and Undo Data
  •     Storing Undo Information
  •     Configuring Undo Rentention
  •     Comparing Undo Data and Redo Data
  •     Understanding Temporary Undo
Section 10: Restricting and Sorting Data - Oracle Database: Introduction to SQL
Weight:
-
  •     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
Section 11: Using Conversion Functions and Conditional Expressions - Oracle Database: Introduction to SQL
Weight:
-
  •     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
Section 12: Displaying Data from Multiple Tables Using Joins - Oracle Database: Introduction to SQL
Weight:
-
  •     Using Self-joins
  •     Using Various Types of Joins
  •     Using Non equijoins
  •     Using OUTER joins

 
Section 13: Using SET Operators - Oracle Database: Introduction to SQL
Weight:
-
  •     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
Section 14: Understanding Data Definition Language - Oracle Database: Introduction to SQL
Weight:
-
  •     Using Data Definition Language
Section 15: Managing Views - Oracle Database: Introduction to SQL
Weight:
-
  •     Managing Views
Section 16: Managing Data in Different Time Zones - Oracle Database: Introduction to SQL
Weight:
-
  •     Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
  •     Working with INTERVAL data types
Section 17: Retrieving Data using the SQL SELECT Statement - Oracle Database: Introduction to SQL
Weight:
-
  •     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

 
Section 18: Using Single-Row Functions to Customize Output - Oracle Database: Introduction to SQL
Weight:
-
  •     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
Section 19: Reporting Aggregated Data Using Group Functions - Oracle Database: Introduction to SQL
Weight:
-
  •     Restricting Group Results
  •     Creating Groups of Data
  •     Using Group Functions
Section 20: Using Subqueries to Solve Queries - Oracle Database: Introduction to SQL
Weight:
-
  •     Using Single Row Subqueries
  •     Using Multiple Row Subqueries

 
Section 21: Managing Tables using DML statements - Oracle Database: Introduction to SQL
Weight:
-
  •     Managing Database Transactions
  •     Using Data Manipulation Language
  •     Controlling transactions
Section 22: Managing Sequences, Synonyms, Indexes - Oracle Database: Introduction to SQL
Weight:
-
  •     Managing Indexes
  •     Managing Synonyms
  •     Managing Sequences
Section 23: Managing Schema Objects - Oracle Database: Introduction to SQL
Weight:
-
  •     Creating and using temporary tables
  •     Managing constraints
Info
https://education.oracle.com/oracle-database-administration-i/pexam_1Z0-082