What is schema?

Answer Posted / peter

Schema is a collection of database objects. A schema is
owned by a database user and has the same name as that
user. Schema objects are logical structures created by
users to contain, or reference, their data. Schema objects
include structures like tables, views, and indexes.

Is This Answer Correct ?    14 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I manually uninstall oracle client?

511


what is the dual table in oracle?

547


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1497


Why we use bulk collect in oracle?

528


what are the default admin accounts in Oracle 10g ?

501






Can you create a synonym without having a table?

543


Can objects of the same schema reside in different tablespace?

579


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1517


What is difference between truncate and delete?

551


What is the use of oracle?

541


What to do if the startbd.bat failed to start the xe instance?

603


What is tns entry?

615


What is a cursor in oracle?

639


What is a sub query? What are its various types?

575


What is where clause in oracle?

524