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!
What is the meaning of Recovery?
In deferred update methods, if a transaction fails before arriving its commit point, it will not have altered the database in any way, so UNDO is not required. Deferred update can lead to a recovery algorithm termed as NO-UNDO/REDO. This approach, while used with certain concurrency control methods, is designed never to need transaction rollback, and recovery simply contain redoing the operations of transactions committed after the last checkpoint from the log. In immediate update method, if a transaction fails after recording a few changes in the database but before reaching its commit point, the effect of its operations on the database should be undone; that is, the transaction should be rolled back. This technique needs both operations and is utilized most often in practice. Hence, it is as well known as UNDO/REDO.
real life situations where database management system are most suitable
What is key ? Key - A single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances (rows) of the set (table) is
(a) Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b) Based on the above object database, write the following queries i
Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.
What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.
What are the different integrity constraints in RDBMS? The various integrity constraints in RDBMS are as: Primary Key: primary key is a grouping of one or more attributes
PHYSICAL DBMS ARCHITECTURE The physical architecture defines the software components used to process and enter data, and how these software components are related and interc
Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328
Define Thomas write rule Thomas' write rule: The Thomas' write rule is a modification of timestamp-ordering protocol for concurrency control. Assume that transaction T i issue
What is object containment? References among objects can be used to model dissimilar real-world concepts.
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