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...
Setting_______ to 1 allows user to rotate a shape continuously by holding down the middle mouse button on a three-button mouse, dragging the mouse in the direction of the desired rotation and releasing the mouse button.
a) autospin_allowed. b) allow_autospin. c) autospin. d) None of the above.
Which of the following keys promotes a level, as when you have been entering bullets and want to start a new slide?
A. Tab B. Shift Tab C. Enter D. Ctrl Tab
Why will deadlock probably be a more critical problem in future operating systems than it is today?
What will be an ideal response?
A(n) ____ is a hardware or software device that restricts access between the computer network and the Internet, or between a computer and other computers, protecting the computer behind it.
A. safeguard B. encryptor C. firewall D. SFTP