Define instance and schema, Database Management System

Define instance and schema? 

Instance:  Collection of  data  kept in the  data  base  at  a  particular  moment  is  known as an Instance of the database. 

Schema: The overall design of the data base is known as the data base schema.  

 

Posted Date: 7/27/2013 6:35:40 AM | Location : United States







Related Discussions:- Define instance and schema, Assignment Help, Ask Question on Define instance and schema, Get Answer, Expert's Help, Define instance and schema Discussions

Write discussion on Define instance and schema
Your posts are moderated
Related Questions
Define granularity, hierarchy of granularity of locks & multiple granularity locking. Explain the modified two phase locking along with multiple granularity locking. Ans: The s

What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

employee(empid,empname,dept,telno,mobno, add,sssno,tinno,WEdates,WEcomp,WEadd,WEpos,WEres) this is a employee record which is need to be normalize.the WE means work experience

what is database management system? & why it is required?

Define Catalog and meta data ? A catalog is a compilation of records elaborating the contents of a particular collection or group of collections. Metadata (Meta data, or someti

a)  Suppose we updated the catalog tables in real time, that is, after every update, insert, or delete SQL statement were executed-rather than only running RUNSTATS once every few

Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,....  FROM TABLE WHERE );

Where does view definition stored? A view definition is permanently stored as part of the database.

What are the Constituents of File? Also elaborates all the possible file operations? A file is organised logically as sequence of record. These records are mapped onto disk blo

Control as a State Machine Engine First let us define the state machine: "the state machine is a machine which is an object but not an application object. It is a part of lang