Answer Posted / neeraj sharma
A database schema is described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables.
Schemas are generally stored in a data dictionary. Although a schema is defined in text database language, the term is often used to refer to a graphical depiction of the database structure
Levels of database schema
1. Conceptual schema, a map of concepts and their relationships
2. Logical schema, a map of entities and their attributes and relations
3. Physical schema, a particular implementation of a logical schema
4. Schema object, Oracle database object
5. Schema is the over all structure of the database
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
please send me oracle pl/sql exp resume. and also faqs...
Could you please let me know the interfaces in OM / FA??
What is the difference between oracle media recovery and crash recovery?
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
default triggers available for reports
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
What is the importance of batch source set up in ar? : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
what is the link between suppliers and banks in ap module in oracle apps? And also query?
which one is currently in used software cmpanies.
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
how to replace not in with not exist?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Explain the use of table functions.
