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 system log? What are the entries?
Ans: The system log that is generally written on stable storage contains the redundant data required to recover from volatile storage failures and as well from errors discovered by the transaction or the database system. System log is as well known as log and has sometimes been called the DBMS journal. It consists of the following entries (also known as log records):
a. [start_transaction, T]: Points out that transaction T has started execution.
b. [write_item, T, X, old_value, new_value]: Points out that transaction T has changed the value of database item X from old_value to new_value.
c. [read_item, T, X]: Points out that transaction T has read the value of database item X.
d. [commit, T]: Points out that transaction T has completed successfully, and affirms that its effect can be committed (recorded permanently) to the database.
e. [abort, T]: Points out that transaction T has been aborted.
Explain how the associations are implemented as classes. A general approach in this case is to transform an association class into a simple class linked to two original classes
Hardware failure : Hardware failures are the failures when some disk or hardware chip fails. This may result in loss of data. One such trouble can be that a disk gets damaged and
Define the terms i) Key attribute ii) Value set Key attribute: An entity type usually has an attribute whose values are exact from each individual entity in the collection. Su
What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel
What is Conceptual Schema? Conceptual Schema - Conceptual schema elaborates the structure of the overall database for a community of users. It hides the details of physical sto
Secondary Indexes Let consider the student database and its clustering index and primary (only one will be applicable at a time). Now consider the state when the database is to
Assume that you are responsible for selecting a new DBMS product for Sohar Hospital
What are the properties in a relation ? In a relation Ordering of rows is immaterial and No two rows are identical.
What is E-R model? This data model is based on real world that having of basic objects called entities and of relationship between these objects. Entities are explained in a da
Describe the objective of Structural Diagrams The main objective of structural diagram is to visualize, construct, specify and document static aspects of a system. Their eleme
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