Sequences-data control, Database Management System

Sequences

Sequences:

  • Automatically produce unique numbers
  • Are sharable
  • Are typically used to make a primary key value
  • Replace application code
  • Speed up the efficiency of accessing series Values when cached in memory.

 

Posted Date: 3/11/2013 1:27:43 AM | Location : United States







Related Discussions:- Sequences-data control, Assignment Help, Ask Question on Sequences-data control, Get Answer, Expert's Help, Sequences-data control Discussions

Write discussion on Sequences-data control
Your posts are moderated
Related Questions
Reflects organisational structure: Many organizations are distributed over various locations. If an organisation has many offices in dissimilar cities, databases used in such an ap

What is meant by functional dependencies? Consider a relation schema R and α C R and β C R. The functional dependency α ->β  holds on relational schema R if in any legal relati

Making Common Behaviour Abstract Let us define abstraction "Abstraction means to focus on the necessary, inherent aspects of an entity and ignoring its accidental features". O

Explain the Concept of Two-phase Locking It concerns the positions of locking and unlocking operations in each transaction.  In this protocol every transaction issue lock and u

(a)    Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b)   Based on the above object database, write the following queries i

Control as Concurrent Tasks The expression control as simultaneous task means applying control for those events of object which can happen simultaneously. An object can be imp

how oracle can be used

What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys

Explain the disadvantages of using DBMS There could be a few disadvantages of using DBMS. As DBMS requires computers, we have to invest a good amount in acquiring the hardwa

Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.