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
Question: (a) What is ODBC and what is its function? (b) What is Web application server, and how does it work from a database perspective? (c) What does e-commerce mean

What is a records management consultation? Our organization is an authority for disseminating your specific requirements and giving you with a solution to effectively manage yo

1) 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 pict

What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers

Benefits: It limits data access. It makes difficult queries look easy. It permits data independence. It presents dissimilar views of the similar data.

write an SQL statement to create the database in MYSQL server

Security And Integrity After Reading the concepts of database recovery in the last section, let us now deal with a vital concept that helps in minimizing consistency errors in

In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic

Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.

What is the difference between a key and a superkey? Key - A key a single attribute or a combination of two or more attributes of an entity set which is used to identify one