Creating And Using Temporary Tables/ Understanding Oracle Database Architecture
Configuring Oracle Net Services/ Comparing Dedicated And Shared Server Configurations
Using Conversion Functions And Conditional Expressions/ Comparing Undo Data And Redo Data
Using Oracle Net Services Administration Tools/ Administering User Authentication Methods
Reporting Aggregated Data Using Group Functions/ Connecting To An Oracle Database Instance
Using Arithmetic Expressions And NULL Values In The SELECT Statement/ Understanding Transactions And Undo Data
Using Concatenation Operator, Literal Character Strings, Alternative Quote Operator, And The DISTINCT Keyword
Using The ORDER BY Clause In Set Operations/ Retrieving Data Using The SQL SELECT Statement
Managing Tables Using DML Statements/ Using The TO_CHAR, TO_NUMBER, And TO_DATE Conversion Functions
Creating And Assigning Profiles/ Configuring The Oracle Net Listener/ Shutting Down Oracle Database Instances
Using The Automatic Diagnostic Repository (ADR)/ Deploying Oracle Database Space Management Features
Using The Database Configuration Assistant (DBCA)/ Accessing An Oracle Database With Oracle Supplied Tools
Creating, Altering And Dropping Tablespaces/ Displaying Data From Multiple Tables Using Joins
Manipulating Strings With Character Functions In SQL SELECT And WHERE Clauses/ Using Racle Enterprise Manager Database Express
Applying Rules Of Precedence For Operators In An Expression/ Manipulating Dates With The Date Function
Understanding Data Definition Language/ Managing Data In Different Time Zones/ Understanding Block Space Management
Using Single-Row Functions To Customize Output/ Limiting Rows Returned In A SQL Statement