What is schema?
Answers were Sorted based on User's Feedback
Answer / salim
schema is collection of objects
(table,view,procedure,function.....)
| Is This Answer Correct ? | 148 Yes | 19 No |
Answer / smnad
Every design that we made in the data base is called as
schema .like table , namefeild , columns and all the feild
that will be generated by the user is called as schema.
| Is This Answer Correct ? | 59 Yes | 17 No |
Answer / yagnya
SCHEMA IS THE DESCRIPTION OF OBJECT,AND SCHEAM CAN BE
REPRESENTED BY SCHEAMA DIAGRAM.
| Is This Answer Correct ? | 50 Yes | 28 No |
Answer / k
Schema is simply an user to the database wherein the user
can create its own objects in the database.
| Is This Answer Correct ? | 39 Yes | 22 No |
Answer / subash
With respect to Active directory:
Schema defines the objects and attributes which can be
created with in the active directory.
| Is This Answer Correct ? | 23 Yes | 9 No |
Answer / ashutosh
Schema is a collection of user defined objects such as
(table,view,procudure,etc..)
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / 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 |
Answer / sandesha
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.
=============================
2nd:schema is collection of objects
(table,view,procedure,function.....)
| Is This Answer Correct ? | 11 Yes | 3 No |
What is a deadlock in SQL? How can you prevent it?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
How to build data dictionary view an new database?
State and explain about oracle instance?
How remove data files before opening a database?
How to get a list of all user accounts in the database?
when do u go for hash partitioning?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is meant by raw datatype?
Write a simple Store procedure and pass parameter to it ?
How to change system global area (sga) in oracle?
What is an Integrity Constrains ?