Overview/Description
To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.
Target Audience
Database Administrators, Database Designers, Developer
Support Engineers, and Technical Administrators.
Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)
Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
recognize the steps for creating, defining, and naming a table, and for specifying data types for its columns.
recognize the steps for using constraints to prevent invalid data entry into tables.
recognize the steps for altering or dropping a table.
identify the steps for creating and manipulating views to view or hide a table's data.
recognize the steps for using sequences to create integers, using indexes to improve the performance of queries, and using synonyms to give a table an alternative name.
create a new table and create and use a sequence, index, and synonym.