Oracle Database Administration I(1Z0-082)

What skills will be measured in the Oracle Database Administration I(1Z0-082) certification exam?

The skills that the exam will test you on include:

Management of Database Instances: This includes starting Oracle Database Instances, using Trace Files and Alert Logs, using Data Dictionary and Dynamic Performance Views, using Automatic Diagnostic Repository(ADR), management of Initialization parameter files, and shutting down Oracle Database Instances.

Management of Roles, Users and Privileges: This includes creation and assignment of Profiles, and assigning quotas to users.

Understanding of Oracle Database Architecture: It includes understanding Oracle Database Instance Configurations, Physical and Logical Database Structures, Oracle Database Memory and Process Structures, and Oracle Database Server Architecture.

Accessing any Oracle Database using Oracle supplied tools: This includes using Oracle Enterprise Manager Cloud Control, Oracle Enterprise Manager Database Express, Database Configuration Assistant(DBCA), SQL Plus, and SQL Developer.

Configuration of Oracle Net Services: It includes connecting to Oracle Database Instances, using Oracle Net Services Administration tools, administering naming methods, configuring Oracle Net Listener, communication between Database Instances, and making comparisons between Shared and Dedicated Server Configurations.

Retrieving Data using SQL SELECT statement: This includes using SQL SELECT statements, column aliases, literal character strings, concatenation and alternative quote operator, DESCRIBE command, DISTINCT keyword, arithmetic expressions, and NULL values in the SELECT statement.

Moving Data: It includes making use of external tables, Oracle Data Pump, and SQL*Loader.

Sorting and Restricting data: This will include using Substitution variables, VERIFY and DEFINE commands, limiting rows returned in a SQL statement, and applying rules of precedence for operators in expressions.

Using single-row functions for the customization of output: It includes performing arithmetic with date data, and manipulating dates with date function, strings with character functions in SQL WHERE and SELECT clauses, and numbers with the MOD, TRUNC, and ROUND functions.

Using Conditional Expressions and Conversion Functions: It includes nesting of multiple functions, implicit and explicit data type conversion, using TO_NUMBER, TO_DATE, and TO_CHAR conversion functions, and applying NULLIF, COALESCE, and NVL functions to data.

Displaying data from multiple tables: This includes using different types of joins, Self-joins, non equijoins, and OUTER joins.

Using SET operator: This includes using the INTERSECT, MINUS, UNION and UNIONALL operators, ORDER BY clause in SET operations, and matching the SELECT statements.

Aggregated Data Reporting using Group functions: It involves creating groups of data, using group functions, and restricting group results.

Subquery usage to solve queries: It comprises using Single row and multi-row subqueries.

Managing undo: This includes understanding temporary Undo, Undo data and transactions, storing Undo information, configuring Undo retention, and comparing Redo and Undo data.

Management of storage: This comprises understanding Block Space Management, using Table and Row Compression, and Space-saving features, managing Resumable Space Allocation and various kinds of segments, shrinking segments, deferring segment creation, and deploying Oracle Database Space Management features.

Management of Datafiles and Tablespaces: It includes creating, viewing, dropping and altering Tablespaces and their information, implementing Oracle managed files, renaming and moving Online Data Files, and managing Table Data Storage.

Management of Synonyms, Sequences, and Indexes: It comprises the management of Indexes, Sequences, and Synonyms.

Management of Tables by making use of DML statements: This includes managing and controlling Database transactions, and using Data Manipulation Language(DML).

Management of data in various Time Zones: It includes working with LOCALTIMESTAMP, CURRENT_TIMESTAMP, CURRENT_DATE, and INTERVAL data types.

Management of Schema objects: This includes creation and usage of temporary tables and management of constraints.

Management of Views: This comprises the management of views.