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
Accessing information about permissions to all users- Object level permissions: With the use of data dictionary you can see the permissions to user. Let us get the table name fro

Log based recovery: Let us first describe the term transaction log in the context of DBMS. A transaction log is a record in DBMS that remains track of all the transactions of a dat


What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N

Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial

Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink

Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

Describe integrity constraints? Integrity Constraints - A database is just as excellent as the information stored in it, and a DBMS must therefore help avoid the entry of inc