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.
database help
What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency
Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.
Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of
Self-Join: In a self join a table is joined with itself. Let consider the following sample partial data of EMP table EMPNO ENAME MGRID
Package classes and associations into models Programs are made of separate physical units which could be edited, imported, complied or otherwise manipulated. The careful part
Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu
ADVANCE OBJECT DESIGN Introduction Analysis is the initial step of the OMT methodology. It is apprehensive with devising a precise, concise, correct and understandable mo
What are the drawbacks of File Oriented System in details?
Describe Parameteric end users? Parametric end users might be given update access, but are commonly not permitted to change the structure of data.
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