RelationalDBDesign 




Managing Tables   «Prev  Next»
Lesson 9

Managing tables and Schema Manager Conclusion

In this module, you learned to:
  1. Create a table
  2. Work with the basic Oracle datatypes
  3. Create a table using the Schema Manager
  4. Generate a list of the tables in your Oracle database
  5. Gather information about the columns in a table
  6. Modify a table by adding or modifying columns
  7. Delete a table

Glossary

In this module, you learned the following glossary terms:
  1. CASE: Computer Aided Software Design, a process where the implementation details of application systems are partially determined through computerized automation.
  2. Data Definition Language: The portion of the SQL language that is used to create and alter the structures that hold the data in the database.
  3. Data Dictionary: A group of tables and views that define the structures in a database.
  4. National Language Subset: A group of characters that are used to represent a specific national language or dialect.
  5. Oracle interMedia: An option for the Oracle database designed for handling specific types of large data (such as images or spatial data) and text.
  6. Schema: A structure in an Oracle database that contains database structures, typically owned by the schema owner.
The next module is about the various ways you can add constraints to tables and columns that limit the values of data that can be placed into the database.
Altering Dropping Tables - Quiz
Click the Quiz link below to answer a few questions about altering and dropping tables.
Altering Dropping Tables - Quiz