What is the difference between an Oracle Schema and an
Oracle Instance?
Answer Posted / 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 |
Post New Answer View All Answers
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is a static data dictionary in oracle?
What is a system tablespace?
Point the difference between translate and replace?
State any two functions of oracle?
What operating systems are supported by oracle database 10g xe?
What are the limitations of check constraint?
Difference between pre-select and pre-query
What is a user account in oracle?
What is a dead lock in oracle?
How remove data files before opening a database?
What is a sub query? Describe its types?
how do u setup a replication site?
What are operators in oracle?