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 is index in Oracle?
Why do we use coalesce function in oracle?
What is oracle and what are its different editions?
What privilege is needed for a user to insert rows to tables in another schema?
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What are the different types of record groups in oracle? Explain each of them
Explain oracle’s system global area (sga).
What is difference between a formal and an actual parameter?
What suggestions do you have to reduce the network traffic?
What exactly do quotation marks around the table name do?
i want department wise maxmum salary and empolyee name
Which Oracle App Is Most Popular One ?