Oracle OCP 19c DBA Course - 1Z0-082 | Unisoft India
Exam Details
| Exam Title: | Oracle Database 19c Administration I |
|---|---|
| Exam Number: | 1Z0-082 |
| Exam Price: | ₹20,379 + 18% GST More on exam pricing |
| Format: | Multiple Choice |
| Duration: | 150 Minutes |
|---|---|
| Number of Questions: | 90 |
| Passing Score: | 60% |
| Validated Against: |
Course Content / Exam(s)
- 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
- 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
- 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
- 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
- Restricting Group Results
- Creating Groups of Data
- Using Group Functions
- Using Self-joins
- Using Various Types of Joins
- Using Non equijoins
- Using OUTER joins
- Using Single Row Subqueries
- Using Multiple Row Subqueries
- 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
- Using Data Definition Language
- Managing Database Transactions
- Using Data Manipulation Language
- Controlling transactions
- Creating and using temporary tables
- Managing constraints
- Managing Indexes
- Managing Synonyms
- Managing Sequences
- Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
- Working with INTERVAL data types
- Understanding Oracle Database Instance Configurations
- Understanding Oracle Database Memory and Process Structures
- Understanding Logical and Physical Database Structures
- Understanding Oracle Database Server Architecture
- 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
- Using the Database Configuration Assistant (DBCA)
- Using Oracle Enterprise Manager Cloud Control
- Using racle enterprise Manager Database Express
- Using SQL Developer
- Using SQL Plus
- 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
- Viewing Tablespace Information
- Creating, Altering and Dropping Tablespaces
- Managing Table Data Storage
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files
- 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
- 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
- Understanding Transactions and Undo Data
- Storing Undo Information
- Configuring Undo Rentention
- Comparing Undo Data and Redo Data
- Understanding Temporary Undo
- Using External Tables
- Using Oracle Data Pump
- Using SQL*Loader
Examination Score Report
Testimonials
Apeksha Bawankar
My experience at Unisoft Technologies has been nothing short of amazing. The practical approach to learning here is truly commendable. If you’re looking to get trained in Oracle, Unisoft Technologies is the place to be. The faculty here is incredibly supportive, and their teaching methods are top-notch. The learning environment is excellent. For instance, Saurabh Sir taught us Oracle by comparing various versions of Oracle on different machines, providing clear and comprehensive knowledge. The faculty members are highly experienced and certified. They teach from their wealth of experience, which greatly enhances the learning process. The staff here, including Sushmita Ma’am and Nidhi Ma'am, are very supportive. Unisoft fosters a friendly environment where everyone strives to make you feel comfortable. The owner, Mrs. Pratigya Thakur, is an inspiring and helpful figure. She is a great personality in her own right, and there’s a lot to learn from her. She is always motivating others, which adds to the positive atmosphere. After completing my MCA, I was searching for Oracle certification and training. Unisoft proved to be the best place to get trained. I was under the guidance of Mr. Saurabh Joshi, who guided me exceptionally well and helped in solving my problems. Now, I am an OCA in Oracle 1Z0-071 with a score of 92%, all thanks to Saurabh Sir and my batch mates (Diksha, Deepraj, Swetank, Nidhi, Sayali, and Shiwani) who inspired me. It was an awesome experience learning by doing.
