Lesson 2: Metadata and Framework Overview

Question 1

OUAF

Answer 1

Oracle Utilities Application Framework

Question 2

4 Tiers

Answer 2

Browser
Web Server
Application Server
Database Server

Question 3

Tier 1: Browser

Answer 3

XML injected/converted to HTML to present to UI

Question 4

Tier 2: Web Server

Answer 4

Authenticate to System
Monitor Active Connections

Question 5

Tier 3: Application Server

Answer 5

Configuration done for…
- Business Rules
- DB Access
- Scripting

Question 6

Tier 4: Database Server

Answer 6

• Contains all tables used
• No Business Rules

Question 7

Application Viewer

Answer 7

XML Processed data from Table/Field metadata to be a ‘DATA DICTIONARY’ which can be viewed in APPLICATION VIEWER

Question 8

Data Dictionary

Answer 8

It reflects what in your system

Question 9

Data Design Patterns

Answer 9

• No recurring groups
• Primary Keys & Foreign Keys
• Very little redundant data
• Language tables
• XML Extensions
• Maintenance Object Definition

Question 10

Y/N: Does Maintenance Object (MO) encapsulates business rules?

Answer 10

Y

Question 11

Y/N: Can user ADD & EDIT existing CORE BUSINESS RULES?

Answer 11

N. You can only ADD via extend of MO in Configuration Tools

Question 12

Y/N: Does Maintenance Object (MO) reflect what’s in your database?

Answer 12

Y

Question 13

What does MO use?

Answer 13

Fields

Question 14

What does BO use?

Answer 14

Elements

Question 15

Y/N: Does Business Object (BO) represents the SAME things as of MO?

Answer 15

N. BOs are designed to match Business

Question 16

Can BO violate MO business rules?

Answer 16

N

Question 17

Plug-in

Answer 17

It is the Metadata (aka. Plug-in) that controls many BPAs and BOs

Question 18

Base Plug-in vs. Create-Your-Own

Answer 18

Depending if Base Plug-in satisfies the business process, you can opt not to create-your-own

Question 19

What do you call ‘User-Defined Field’?

Answer 19

Characteristic

Question 20

4 Types of Characteristic Types

Answer 20

Predefined: valid values (discrete)
Adhoc: not defined values (non-discrete)
Foreign Key Reference: holds a foreign key
File Location: references URL or File Location

Question 21

What is ‘Owner Flag’?

Answer 21

References who own the metadata table

Question 22

Why you should NOT update/change data of row you do not own (Owner Flag)?

Answer 22

It will rollback changes on next update and ownership will be reapplied

Question 23

How secure is Tier 3: Application Server?

Answer 23

The Security Type is used to associate User Groups’ specific ‘valid’ actions

Question 24

Where are Batch Processes documented?

Answer 24

Application Viewer

Question 25

What are the ‘Batch Process’ attributes?

Answer 25

Restartable
Execute concurrently 24x7
Reproduce historical output

Question 26

What is an Audit Trail?

Answer 26

It tracks which has been modified by a user

Question 27

_________ can be supplied when you submit a batch process

Answer 27

Override Parameter

Question 28

What is the use of Conversion Tool

Answer 28

It populates production DB using legacy data from Staging DB