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 is Oracle databse structure? Oracle database structure: The relational model has three main aspects: Structures: Structures are well-defined objects which store th

Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

CREATE YOUR DATABASE TABLES Your database project must have a minimum of four tables. Include the SQL scripts used to create the tables in your documentation. Explain the tables

The Incident table, with an auto-incrementing incident number, etc, looks like: incident_num reporter date time incide

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i


Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Benefits of using heuristics

#question.explain diversity and magnitude of organic compounds and general properties?

Java program for horrizontal fragmentation in distributed database