1z0-082 Oracle Database Administration I Exam

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

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

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

Answer: B

 

Click here to view complete Q&A of 1z0-082 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle Database 19c 1z0-082 Certification, Oracle Database 19c 1z0-082 Training at certkingdom.com