Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Give detail description on Transactions.
- Using transactions we can group all SQL commands into a single unit.
- Transaction begins with some task and finishes only when all tasks within it are over.
- Transaction gets over successfully only when all commands in it are successfully over. Even if one command fails, whole transaction fails.
- BEGIN TRANSACTION, ROLLBACK TRANSACTION, and COMMIT TRANSACTION statements are used to work with transactions.
- A group of tasks starts with begin statement.
- Just in case of any problem, rollback command is executed to abort transaction.
- If all tasks run successfully, all commands are executed through commit statement.
Discuss the term- Design Optimization We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementati
System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha
what are the limitations of dbms?
Which of the operations constitute a basic set of operations for manipulating relational data? Relational algebra operations constitute a basic set of operations for manipulati
What is an ERD?
What is Natural Language Interfaces? Natural Language Interfaces - These interfaces accept requests written within English or a few other language and attempt to "understand" t
What is the use of Union and intersection operation? Union: The result of this operation contains all tuples that are either in r1 or in r2 or in both r1 and r2.Duplicate tuple
Entity types that do not have any key attribute, and therefore cannot be identified independently, are known as weak entity types. A weak entity can be recognized uniquely only by
What is transaction? Transaction is a unit of program implementation that accesses and possibly updated several data items.
In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd