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 |
How to insert multiple rows with one insert statement in oracle?
What is instant client oracle?
What are cursor?where are they used?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
How to bring a tablespace online?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
how to unbreak sequence numbers during intereptions
does the query needs a hint to access a materialized view?
What is truncate oracle?
What is difference between a formal and an actual parameter?
Explain the characteristics of oracle dba?