Oracle Database Administration I | 1Z0-082 An Oracle Database Administration 2019 Certified Professional has proven
theoretical understanding of and the practical skills required to configure and
manage Oracle Databases up to and including Oracle 19c. Passing this 1st exam in
the 2 exam path proves your skills in SQL programming skills, database and
network administration.
Audience: Database Administrator
Exam Details
Exam Title: Oracle Database Administration I
Exam Number: 1Z0-082
Exam Price: $50
Format: Multiple Choice
Duration: 150 Minutes
Number of Questions: 90
Passing Score: 60%
Validated Against: Oracle Database Administration 2019 Certified Professional
Take Recommended Training Courses Complete one of the courses below to prepare for your exam (optional):
Oracle Database: Administration Workshop
Oracle Database: Introduction to SQL
Oracle Database Administration Learning Subscription
Unlimited Product Learning Subscription
Additional Preparation and Information A combination of Oracle training and hands-on experience (attained via labs
and/or field experience) provides the best preparation for passing the exam.
Oracle Database 2019 Certification Overview and Study Guide
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 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
Moving Data - Oracle Database: Administration Workshop Using External Tables
Using Oracle Data Pump
Using SQL*Loader
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 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
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
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
Managing Views - Oracle Database: Introduction to SQL
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
Reporting Aggregated Data Using Group Functions - Oracle Database:
Introduction to SQL
Restricting Group Results
Creating Groups of Data
Using Group Functions
Managing Tables using DML statements - Oracle Database: Introduction to SQL Managing Database Transactions
Using Data Manipulation Language
Controlling transactions
Managing Schema Objects - Oracle Database: Introduction to SQL Creating and using temporary tables
Managing constraints
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 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
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
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
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
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
Understanding Data Definition Language - Oracle Database: Introduction to SQL
Using Data Definition Language
Managing Data in Different Time Zones - Oracle Database: Introduction to SQL Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
Working with INTERVAL data types
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
Using Subqueries to Solve Queries - Oracle Database: Introduction to SQL Using Single Row Subqueries
Using Multiple Row Subqueries
QUESTION 2
Which statement is true about the INTERSECT operator used in compound queries?
A. Multiple INTERSECT operators are not possible in the same SQL statement
B. It processes NULLs in the selected columns
C. INTERSECT is of lower precedence than UNION or UNION ALL
D. It ignores NULLs
Answer: B
Section: (none)
Explanation
Explanation/Reference:
QUESTION 3
Which three statements are true about advanced connection options supported by Oracle Net for connection
to Oracle Database instances? (Choose three.)
A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
B. Source Routing requires the use of a name server
C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be
routed through a firewall
D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server
configuration
E. Load Balancing requires the use of a name server
F. Connect Time Failover requires the connect string to have two or more listener addresses configured
Answer: B,CF
QUESTION 4
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to
DD-MON-YYYY HH24:MI:SS? (Choose two.)
A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional
seconds
B. SYSDATE can be queried only from the DUAL table
C. CURRENT_DATE returns the current date and time as per the session time zone
D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the
database server
F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
Answer: B,C
QUESTION 5
A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?
A. in the undo tablespace
B. in the SYSAUX tablespace
C. in the SGA
D. in the PGA
E. in the temporary tablespace
Answer: A
QUESTION 6
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan remains unpaid
Which data type should you use?
A. INTERVAL YEAR TO MONTH
B. INTERVAL DAY TO SECOND
C. TIMESTAMP WITH LOCAL TIMEZONE
D. TIMESTAMP
E. TIMESTAMP WITH TIMEZONE
No comments:
Post a Comment