Answer / jaya shanker prasad

The overall design of the database structure is called
database schema.for example the lecturer will go to the
class room only the part of the database schema that is
attendence register.

Answer / v p sharma

The term schema refers to the overall design of the data
base. it is a logical database description and is drawn as
a chart of the type of data that are used it gives the
name of the entity and relationship between them for eg an
information display system that gives info about arrival
and departure of train and aircraft at stations. the schema
will remain the same though the values diplayed in the
sysytem will change from time to time. the term subschema
refers to the same view but but for the data item types and
record types which are used ina particular application or
by particular user.

Answer / dbramesh

Schema is where all the user objects are logically grouped.
usage of Schema and user are interchangeble

Schema is an user
schema is for users


Cheers,
Ramesh

Answer / 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

What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers  

---

What is index? How many types of indexes?

2 Answers   HCL,

---

statement string in open is null or 0 length ORA-40735

1 Answers   RoboSoft, Unilog,

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  

---

please send me oracle pl/sql exp resume. and also faqs...

0 Answers  

---

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.

0 Answers   Wipro,

---

Name a tablespace automatically created when you create a database.

3 Answers   HCL,

---

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

0 Answers  

---

Could you please let me know the interfaces in OM / FA??

0 Answers   Oracle,

---

How to find locks exists in a table or not?

1 Answers   HCL,

---