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


Please Help Members By Posting Answers For Below Questions

How many types of cluster table in Oracle?

785


How to build data dictionary view an new database?

780


How to use "in" parameter properly?

811


What are the logical operations?

878


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1475


How to convert dates to characters in oracle?

769


what are steps for interface? where is exchange rate defined in which table?

1724


How to execute a stored program unit?

788


what is IDE,DMV in sql server?

2482


How do I find the database name in oracle?

768


What is an oracle?

752


What is difference between truncate and delete?

734


What are the execution control statements?

819


How to call a stored function with parameters?

741


How to list all indexes in your schema?

786