What is a Schema ?
Answers were Sorted based on User's Feedback
Answer / abc
schema is the overall logical design of the database
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / s. senthil kumar
A schema is collection of database objects of a User.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / gmv lakshmi
A Schema is a collection of logical structures of data, or
schema objects. A schema is owned by the database user and
has the same name as that of user. Each user owns a single
schema. Schema objects include following type of objects
clusters, database links, functions, indexes, packages,
procedures, sequences, synonyms, tables, database triggers,
views.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santhi
Schema is a collection of database objects of a user
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sawant
The set of objects owned by user account is called the schema.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / eshwari
Schema is nothing but the user.
the objects which are created by a user are called schema
objects means views,indexes,clusters,synonyms.
Is This Answer Correct ? | 0 Yes | 0 No |
what are pseudocolumns?
Is oracle an open source?
what is analyze command ? what kind of statistics does it generate?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What are various constraints used in SQL?
What is the difference between $oracle_base and $oracle_home?
What is a public synonym?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How many data types are supported?
What do you mean by redo log file mirroring?