What is database schema?

Answers were Sorted based on User's Feedback



What is database schema?..

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.

Is This Answer Correct ?    10 Yes 2 No

What is database schema?..

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.

Is This Answer Correct ?    6 Yes 1 No

What is database schema?..

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

Is This Answer Correct ?    6 Yes 2 No

What is database schema?..

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

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle AllOther Interview Questions

When a user process fails, what background process cleans up after it?

1 Answers  


what are the API of GL,PO,AP

1 Answers  


What is database schema?

4 Answers   Infosys,


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1 Answers  


what is sql*loader parameters and where we will use it.

1 Answers   Accenture,


key flexfield structure

1 Answers   Infosys,


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

1 Answers  


Give two examples of referential integrity constraints.

1 Answers  


How to find locks exists in a table or not?

1 Answers   HCL,


as a technical developer in oracle applications which type errors feced in your experience sofar

1 Answers   HCL,


8. Supporting AP, AR and GL?

1 Answers   Oracle,


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

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)