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 the four Oracle system processes that must always be up and running for the database to be useable?
how to get count of tables in particular database in Oracle?
What is oracle server autotrace in oracle?
What is RULE-based approach to optimization ?
How will you write a query to get a 5th rank student from a table student_report?
How to call a stored function in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How can I combine multiple rows into a comma-delimited list in oracle?
how to find out largest value in a table
primary key is foreign key for the same table?
Is there an oracle sql query that aggregates multiple rows into one row?
What is difference between a formal and an actual parameter?