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
Copy Data from One Database to another Database Project Description: I am having two MySQL databases with same tables. I just need to copy one Data from one to another dat

What are the problems if one were not to normalize?  When do these problems surface?           Ans:  Database normalization, sometimes considered to as  canonical synthesis, is

Define Database layer? The database layer defines the data formats used in the database.

Project Description: My VBulletin forum was hacked, and soon after my server machine died. So, I'm now on a new machine, and I think that I've taken care of 99% of the hacking..

DISADVANTAGES OF RDBMS

Transactions And Concurrency Management  Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

State the data flow diagram of functional model Any action initiated by transition in the state diagram can be extended into an entire data flow diagram in functional model. Th

Control as State within Program 1.  The term control exactly means to check effect of input within a program. For illustration, in Figure, after the ATM card is inserted (a

Define entity integrity and referential integrity.  How does SQL allow specification of  these? Ans: Entity Integrity Rule- If the attribute A of relation R is a prime attribut

Consider the relations City (city_name, state) Hotel (name, address) City_hotel (hotel_name, city_name, owner) Answer the following queries in relational algebra (i) Find