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
Define Query Processing Query processing is the process of selecting the best plan or strategy to be employed in responding to a database request. The plan is then executed to

How can you terminate the MySQL Server? Typing the following in Command prompt will shut down the server completely as root user % mysqladmin -u root -p shutdown

Draw an ER diagram that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled

Explain algorithm of ER To Relational Mapping ? ER-to-Relational Mapping Algorithm: 1) Step 1: Mapping of regular entity types: For each strong entity type E, form a relatio

Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat

This project requires you to perform a systems analysis and then design a system solution using database software. Ace Auto Dealers specializes in selling new vehicles from Subaru.

What do you understand by ACID? - ACID (Atomicity Consistency Isolation Durability) is a quality sought after in a reliable database. Here's the relevance of each quality:

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

What is meant by buffer blocks and disk buffer   The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t