|
Click
here for important notes
|
More Resources by
Google: |
|
|
|
|
Case Study for
Hands-On Oracle Installation
The Case Study for “Hands-On
Oracle Installation”
consists of more than 30 basic questions that we believe you must know.
In this Case Study, we look at certain elementary questions, which will
test your basic fundamental understanding of the Oracle Installation.
These questions and their answers in the “Hands-On Training” enhance
your skills in using Oracle.
Introduction
1(Important notes to remember)
Q:
What is an Oracle
Server?
Q:
What is an Oracle
Database?
Q:
Describe a physical
database structure.
Q:
Describe a logical
database structure.
Q:
What is an Oracle
Instance?
Q:
Describe the Oracle
System Global Area.
Q:
Describe
the Oracle Background Processes Server.
Q:
What are the Oracle
users?
Q:
What is a listener?
Q:
What
is TNSNAMES.ORA?
Q:
What
is SQLNET.ORA?
Basic
Introduction
Q:
Describe an element,
field, item and column.
Q:
Describe a record or row.
Q:
Describe a table.
Q:
What is a datatype?
Q:
What is a primary key?
Q:
What is a foreign key?
Q:
What is a logical data model?
Q:
What are the back-end and front end tools?
Q:
Describe a DBA's job.
Q:
Describe a Developer's job.
Installation
and de-installation
Q:
How can you create a Net8
service name?
Q:
How can you start an
Oracle Listener?
Q:
How can you start an
Oracle Database?
Q:
How can you test an
Oracle service name?
Q:
How can you change a
LOCAL string in the registry?
Q:
How can you shutdown an
Oracle Database?
Q:
How can you un-install?
Q:
How can you remove an
Oracle entry from the window registry?
iSelfSchooling: Build
your schema to work on your Hands-On
In order to follow and practice examples of this tutorial, you need to create a user named iself with all its necessary tables.
There is a script named "create_tables.sql" at your CD located in the "iscdxx\iss" sub-directory.
You can find the script in all of your CDs on the readme first
sub-menu.
This Hands-On shows you how you can run the script to create a user named "iself" with password "schooling" and all its tables.
|