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 |
Please explain drop constraint oracle?
How to create tables for odbc connection testing?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
what is load balancing and what u have used to do this?(sql loader)
Why we use bulk collect in oracle?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
How does Oracle guarantee data integrity of data changes?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
What is Data Block ?
What is a cluster?
What is the best way to do multi-row insert in oracle?
What is forall Statement ?