Oracle Database Administration IPractice Test

Starting Up Oracle Database Instances

Shutting Down Oracle Database Instances

Using Data Dictionary Views

Using Dynamic Performance Views

Using the Automatic Diagnostic Repository (ADR)

Using the Alert Log and Trace Files

Managing Initialization Parameter Files

Managing Oracle Database Users, Privileges, and Roles

Assigning Quotas to Users

Applying the Principal of Least Privilege

Creating and Assigning Profiles

Administering User Authentication Methods

Understanding Block Space Management

Managing Different Types of Segments

Deploying Oracle Database Space Management Features

Using Space-Saving Features

Using Table and Row Compression

Shrinking Segments

Managing Resumable Space Allocation

Deferring Segment Creation

Viewing Tablespace Information

Creating, Altering and Dropping Tablespaces

Managing Table Data Storage

Implementing Oracle Managed Files

Moving and Renaming Online Data Files

Understanding Transactions and Undo Data

Storing Undo Information

Configuring Undo Retention

Comparing Undo Data and Redo Data

Understanding Temporary Undo

Using SQL*Loader

Using Oracle Data Pump

Using External Tables

Using Database Configuration Assistant (DBCA)

Using Oracle Enterprise Manager

Using SQL Developer

Using SQL*Plus

Using Oracle Net Services Administration Tools

Configuring the Oracle Net Listener

Connecting to an Oracle Database Instance

Comparing Dedicated and Shared Server Configurations

Configuring Communication Between Database Instances

Administering Naming Methods

• Using the SQL SELECT statement
• Using column aliases
• Using the DESCRIBE command
• Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• Using arithmetic expressions and NULL values in the SELECT statement

• Limiting rows returned in a SQL statement
• Applying rules of precedence for operators in an expression
• Using substitution variables
• Using the DEFINE and VERIFY commands

• Manipulating strings with character functions in SQL SELECT and WHERE clauses
• Manipulating numbers with the ROUND, TRUNC and MOD functions
• Performing arithmetic with date data
• Manipulating dates with the date function

• Understanding implicit and explicit data type conversion
• Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Applying the NVL, NULLIF, and COALESCE functions to data
• Nesting multiple functions

• Using group functions
• Creating groups of data
• Restricting group results

• Using various types of joins
• Using self-joins
• Using non-equijoins
• Using OUTER joins

• Using single-row subqueries
• Using multiple-row subqueries

• Matching the SELECT statements
• Using the UNION and UNION ALL operators
• Using the INTERSECT operator
• Using the MINUS operator
• Using the ORDER BY clause in set operations

• Using Data Manipulation Language
• Managing database transactions
• Controlling transactions

Using Data Definition Language

• Managing constraints
• Creating and using temporary tables

Managing views

• Managing sequences
• Managing synonyms
• Managing indexes

• Working with CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
• Working with INTERVAL data types