Exam Number: 1Z0-450
Exam Title: Oracle Application Express (APEX) 4 - Developing Web Applications
Associated Certification Paths
Oracle 1Z0-450 Certification Details:
Oracle 1Z0-450 Certification Topics:
Introducing Oracle Application Express |
- Identify the components of Oracle Application Express
- Create a workspace and a Workspace administrator user
|
Interacting with the Database by Using SQL Workshop |
- Use Object Browser to browse, create, and modify objects in the schema
- Use Query Builder to create, run, and save SQL queries
|
Creating Reports |
- Describe report types
- Create interactive reports
- Manipulate your interactive report
- Customize your interactive report
- Generate reports by using wizards
|
Identify the types of forms |
- Create a form on a table with a report
- Create a tabular form
- Create a Master-Detail form
- Edit your form
|
Working with Pages and Regions |
- View page definition
- Edit page attributes
- Create a new region
- View region attributes
|
Adding Items and Buttons |
- Create items
- Edit item attributes
- Create buttons
- Edit button attributes
|
Understanding Session State and Debugging |
- Explain how Oracle Application Express implements the session state
- Set a session state value
- Clear the session state
- Review the session state
|
Including Page Processing |
- Explain the difference between page rendering and page processing
- Create computations for your application
- Validate input data
- Process data
- Create application branching
|
Adding Shared Components That Aid Navigation |
- Include the following shared components in your application:
- Parent and standard tabs
- Navigation bars
- Lists
- Breadcrumbs
|
Adding Other Shared Components |
- Include the following shared components in your application:
- Create charts using a wizard
- Create a calendar
- Create and Use a Dynamic Action
- Import and Use a Plugin
|
Working with Themes and Templates |
- Describe themes
- Switch to a different theme
- Describe templates
- View existing templates
- Create and edit a template
|
Administering Oracle Application Express Workspaces |
- Create a developer and a workspace administrator user
- Request a schema or a storage
|
Implementing Security |
- Differentiate between authentication and authorization
- Provide an authentication scheme for your application
- Create an authorization scheme using Access Control
- Enable and configure Session State Protection
|
Deploying Your Application |
- Define the supporting objects for your application
- Export your application
- Import your application
- Install the supporting objects
|
Using Utilities |
- Generate data definition language (DDL) statements
|
Using Application and Page Utilities |
- Use the Advisor to verify your application
- Manage defaults using the Attribute Dictionary
|
Building a Websheet Application |
- Create a Websheet Application
- Add a Page to a Websheet Application
- Add and manipulate a Data Grid and Report
- Add Sections to a Page
- Share Websheets using an Access Control List
|
Managing and Maintaining the Application Development Process |
- Track Features, Milestones, Bugs and To Dos
- Manage Feedback
|
Oracle 1Z0-450 - Oracle Application Express (APEX) 4 - Developing Web Applications Exam Preparation: