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.
wrie a report on whether a BSc n information systems develops the skills required by employers in Database administration
Difference between SQL and SQL*Plus SQL SQL*Plus SQL is a language SQL *Plus is an environment It is bas
Explain the Exec statement in SQL Ans: Exec statement has the structure EXEC SQL END-EXEC Embeded SQl statements are of a form identical to non embedded SQL statem
Assume that you are responsible for selecting a new DBMS product for Sohar Hospital
Explain I command in QBE ? I : It is the command in QBE that is used to insert tuple (s) into the database
Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran
What is a state chart diagram? State diagrams (State Chart Diagram) explain all possible states that a particular object can get into, and how object's state changes as result
A set of possible data values is called? A set of possible data values is called as domain.
What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d
What are the drawbacks of shadow-paging technique? The drawbacks of shadow paging is:- a) Commit Overhead b) Data fragmentation c) Garbage collection
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