The Oracle Environment Oracle is a modular system that consists of the Oracle database and several functional programs. Oracle's tools do four major things of work. 1. Database Management. 2. Data access and Manipulation. 3. Programming 4. Connectivity.
Database Management Tools
This (is usually known as RDBMS by oracle) includes the core programs for Oracle's database management system, the Oracle database with its associated tables and views, which are stores information related to every fact of the database system.User name, user access rights, table attribute, storage information and auditing data for disaster recovery are stored in the data dictionary.
The Database Administrator
The person responsible for a Database is called the DatabaseAdministrator(DBA).The DBA has a special set of previleges and has complete over the database.Any system with more than one user should have a DBA.The function of DBA include. Creating primary database storage structures. Modifying the structure of the database. Backing up and restoring the database.
Monitoring database performance and efficiency. Transfering data between database and external files. Manipulating the phisical location of the database.
THE END USER End user have less complex but equally important tasks.They must be able to · Query the database. · Generate printed output. · Share data with or secure data from others. · Use non-export methods to update the database. · Define applications from a user point of view.
Get Database Expert
Ask Questions
FURTHER HELP
Get Online Help
project and programming help
Computer Programming Service, Web Site Design,Homework Help,Custome Website Design, Website Design And Development
to give you
Programming
and
Web Designing services .
Please Bookmark It
Programming Services, Web Design Development
We have partnered with LivePersonPlease Bookmark It
|
|
|
Do not copy your homework/project assignment from internet
You will get caught most of the time, Why not get help from subject experts for free?
As you may be aware of the fact that
if you just copy your homework or project assignment from
websites like yahoo answers/sourceforge.net ,etc and submit it to your professor - There are
more than 50% chances that you will get caught and get a zero for your assignment.
Why do you want to risk getting a bad grade? either try to code it yourself, and ask for help at 
or else you can contact a freelancer for helping you doing your project assignment or homework.
He can also make you understand the solution throughly. Try any of the above expert. If you are not finding an expert on your topic, just use the question box, some expert will definitely respond to you.
2 comments:
can u pls help me i created a table space but not sure if i did it right.
Tablespaces
Create two tablespaces as indicated below (xx = your initials). Each tablespace should have a datafile 5M in size (not larger, so that we don’t use up the disk space unnecessarily). Each datafile should be created in the c:\app\oracle\oradata\dbadb\assign3 folder.
Table 1 Tablespaces
Tablespace Extent management Segment management
xx_TBS1 Automatic Automatic
xx_TBS2 Uniform 1M Manual
Determine the default values for each of the tablespaces for the following parameters by querying the appropriate data dictionary views:
Table 2 Default tablespace parameters
xx_TBS1
Value Explanation
Initial extent size
Next extent size
Minimum extents
Maximum extents
xx_TBS2
Value Explanation
Initial extent size
Next extent size
Minimum extents
Maximum extents
Tables
Suppose you want to create a table, STUDENT, with the following columns:
Stud_id CHAR(11)
Stud_fname VARCHAR(50)
Stud_lname VARCHAR(50)
Stud_State CHAR(2)
Stud_Country VARCHAR(50)
and with the following storage parameters:
PCTFREE 15
Initial extent size 200K
Next extent size 100K
Minimum extents 2
Maximum extents 200
Create tables like the STUDENT table (named STUDENT1, STUDENT2) in the two tablespaces.
Complete the Actual and Explanation columns in the following table.
Table 3
STUDENT1 in xx_TBS1
Specified Actual Explanation
PCTFREE 15
Initial extent size 200K
Next extent size 100K
Minimum extents 2
Maximum extents 200
STUDENT2 in xx_TBS2
Specified Actual Explanation
PCTFREE 15
Initial extent size 200K
Next extent size 100K
Minimum extents 2
Maximum extents 200
Q1: Which of the Actual values did you find most surprising? What were you expecting? Why do you think Oracle chose to handle this situation as it did?
This post includes information related to Oracle. It covers topics like tools used for Oracle. I find the post quite informative and useful. The given post explains the basics of Oracle very well. Thanks for the post. Keep it up.
Post a Comment