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!
Explain the ACID properties of a transaction
Ans: ACID properties are a significant concept for databases. The ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity: Atomicity means either all operations of transaction are reflected properly in the database or none are.
Consistency: Consistency means execution of a transaction in isolation (that is with no other transaction executing concurrently) preserves the consistency of the database
Isolation: Although multiple transactions may execute concurrently the system assures that for each pair of transaction Ti and Tj, it appears to Ti that either Tj that either Tj finished execution previous to Ti started or Tj started execution after Ti finished. So each transaction is unaware of other transactions executing simultaneously in the system.
Durability: later than a transaction completes successfully, the changes it has made to the database persist, even if there are system failures.
Foreign Keys and NULL Let us take the relation: DEPT DEPT ID DNAME BUDGET D1 M
Describe multi key files
I have to create a database about anything of my choice. It has to contain 4 queries, and 4 forms. It can be anything as simple as a shoe inventory with numbers - is this a service
Describe the algorithm for updating indices for a single level index when a record is (i) Inserted (ii) deleted What will be the modification if there are multilevel in
What is the disadvantage of a call by reference? During a call by reference damage or loss of data is not restricted to the subroutine, but will instantly lead to alters to th
Improved performance: As the data is located near the site of its demand, and given the inherent parallelism because of multiple copies, speed of database access may be good for di
Need a sample of a clinic database relationships
Name the various privileges in SQL? A) Delete B) Select C) Insert D) Update
What is a view? Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary. Ans: View is a virtual table that does not consist
Cardinality shows the number of instances of an entity associated with another entity participating in a relationship. Depend on the cardinality binary relationship can be further
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd