RelationalDBDesign RelationalDBDesign

DB Creation   «Prev  Next»
Lesson 13

Oracle Server Manager Conclusion

This module demonstrated that the Server Manager is a command-line utility used to manage Oracle databases.
In addition, Server Manager's functionality is being merged into SQL*Plus, and that SQL*Plus now supercedes Server Manager as the command-line interface to Oracle.
Some of the simpler Server Manager commands have been experimented with, and by now you are comfortable with starting Server Manager and connecting to a database.
You should also be comfortable entering and executing commands. You should know how to recover when you mistakenly enter an invalid command.

Oracle Server Glossary

This module introduced you to the following terms:
  1. GUI: Graphic User Interface
  2. environment variable: An environment variable is a dynamic-named value that can affect the way running processes will behave on a computer.
  3. internal
  4. X-Windows: The X Window System (X11, or simply X) is a windowing system for bitmap displays, common on Unix-like operating systems.
  5. data dictionary:The data dictionary is the foundation of the database, and it is where the RDBMS finds which tables are in a database, which columns are in the tables, which columns are primary or foreign keys, and what type of data to expect in those columns.
  6. headers
  7. package:A stored sub-program that combines PL/SQL procedures and functions into a single unit.