gaps in sequence values can happen when-sequences, Database Management System

Gaps in sequence values can happen when:

-     A rollback happens that is when a statement changes are not accepted.

-     When the system crashes

-     When a sequence is used in another table.

 

Posted Date: 3/11/2013 2:14:51 AM | Location : United States







Related Discussions:- gaps in sequence values can happen when-sequences, Assignment Help, Ask Question on gaps in sequence values can happen when-sequences, Get Answer, Expert's Help, gaps in sequence values can happen when-sequences Discussions

Write discussion on gaps in sequence values can happen when-sequences
Your posts are moderated
Related Questions
What are wait-for-graphs?Give the algorithm to construct a wait-for-graph from a given schedule of transactions? How can deadlocks be detected from wait-for-graphs?   Ans:  The

What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

What are the types of reference?explain it with suitable examples? Object oriented language given the ability to refer the object attribute of the type can be referred to the s

Problem: a) Briefly describe what you understand by Client-Server environment b) The File Server is a simple form of Client-Server. Describe the principles of the File Serve

Group By clauses  • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used

Need For Distributed Database Systems A distributed database is a set of database kept on multiple computers that appears to applications as a one database. As a result, an app

Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

Demonstrate the UML model Using UML, it is possible to generate code in any of the programming language from UML model (called forward engineering) and rebuild a model from an

Database Administrator One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having li

Hi I have got an assignment for making an er diagram for market management software can any budy help me?