Name various tools provided by Oracle9i DBMS.
The Oracle9i database management system consists of various tools:
SQL*Plus
PL/SQL
Developer Suite
Enterprise Manager
Oracle Application Server (Oracle9iAS)
? SQL*Plus - The SQL*Plus environment is for writing command-line SQL
queries to work with database objects such as tables, views, synonyms, and
sequences.
? PL/SQL - PL/SQL is Oracle’s extension to SQL for creating procedural
code to manipulate data.
? Developer Suite - This tool is used for developing database applications
and includes:
? JDeveloper—a Java development tool.
? Designer—to model business processes and generate Enterprise
applications.
? Forms Developer—a developement tool for Internet and
client/server–based environment.
? Oracle Reports—a report generation tool.
? Enterprise Manager - A tool for managing users and databases. Enterprise
Manager uses the following tools:
? Storage Manager—to create and manage “tablespaces”.
? Instance Manager—to start, stop, or tune databases.
? Security Manager—to create and manage users, profiles, and
roles.
? Warehouse Manager—to manage data warehousing applications.
? XML Database Manager – to render traditional database data as
XML for e-business support.
? SQL Worksheet—to enter, edit, and execute SQL*Plus code or to
run client-side scripts.
? iSQL*Plus—a Web-based environment to execute SQL*Plus
code.
? Oracle Application Server (Oracle9iAS) - A tool for creating a web site
that allows users to access Oracle databases through web pages. It
includes:
? Web Server.
You might also like to view...
Each of the following statements is TRUE about working with multiple workbooks EXCEPT:
A) Working with multiple workbooks is very similar to working with multiple worksheets. B) Excel 2013 opens each workbook in the same window. C) Data can be referenced between workbooks using 3-D ranges and formulas, so when the source workbook is updated, the changes flow through to the summary workbook. D) Users can choose whether or not to link workbooks to make the updating automatic or not.
Importing brings data into the database from an external file.
Answer the following statement true (T) or false (F)