What is the difference between an Oracle Schema and an
Oracle Instance?
- 3 Answers
- 8292 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vishal
for simplicity, Instance is the name of the Database.
Schema is the owner of your objects(tables, indexes, views,
synonyms,etc).
In you example, you have a Database Instance named
CONTRACT.
In your Contract database, you have 2 Schemas named LEGAL &
RI
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / saiprasannach89
A user in oracle database is called as schema.Objects created by user is called schema objects.
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / udayah shankar dokku
oracle schema: generally it is static,having tablr
name,column name & associated datatypes
oracle instance : generelly it is dynamic,at ay instance of
time the collection of all records is called oracle instance
| Is This Answer Correct ? | 2 Yes | 0 No |
Is insert autocommit in oracle?
What is cursor
What is the use of aggregate functions in oracle?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
Explain a synonym?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
How would you begin to troubleshoot an ORA-3113 error?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
Can anyone give me information about oracle certification
Explain user account with reference to oracle.
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Oracle General 
