RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Data Structures
«Prev
Next»
Performance Tuning
Data Blocks
Database Block Size
Optimizing Space Usage
Segment Header Internals
PCtfree Optimal Performance
PCtused Optimal Performance
Monitoring Tuning Indexes
Table High Water Marks
High Water Mark
Water Mark Active
DB Engine Conclusion
Data Structures
Object Oriented Database
Abstract Data Types
Data Dictionary
Oracle Data Dictionary
Sending DBA Alert Output
Partitioned Tuning
DBA Tab Partitions View
Partitioned Index Maintenance
Data Base Objects
DBA Partition Views
Index Techniques
Bitmap Indexes
Speeding Queries
DW Star Schema
Star Query Process
Star Transformation Queries
Requirements for Star Trans
Star Transformation Process
Using Concatenated Indexes
Function Based Indexes
Bitmapped Indexes
Oracle Database Tuning
Oracle Web Applications
Web Request Broker
Oracle Tuning - Glossary
Oracle Abstract Data Type - Exercise
Create an ADT - Exercise
Objective:
Create an abstract data type.
Scoring
You will receive 5 points for this exercise.
The exercise is auto-scored; when you have completed the exercise, click the
Submit
button to receive full credit.
Background/overview
You have been asked to assist in creating a new employee table for your company that consists of the following items:
salutation char(3), first_name char(40), mid_initial char(1), last_name char(40),
Instructions
In order to make the data type reusable in all Oracle tables, you have been asked to create an abstract data type called name_type that contains all of the name information. Provide the CREATE TYPE syntax and the corresponding CREATE TABLE syntax.
Submit