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.
Can we delete data element, which is being used by table fields. No we cant delete data element.
What do you mean by an execution plan? Why is it used? How will you view it? a.) An execution plan can be known as a road map which textually or graphically illustrates the dat
Types Of Indexes One of the words used during the file organisation is the term index. In this part, let us describe this term in more detail. We find the index of keywords
diagrams and meaning
Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.
Discuss deferred update technique of recovery. What are the advantages? Ans: The deferred update methods do not physically update the database on disk till after a transact
What is disadvantage of multiple inheritances? There is potential ambiguity if the similar variable or method can be inherited from more than one superclass.eg: student class m
Forward Recovery (Redo): In this system the committed changes made by a transaction are reapplied to a previous copy of the database. In simpler
What are the two statements regarding transaction? The two statements regarding transaction of the form are:- A) Begin transaction B) End transaction
What is a view in SQL? When can views be updated? A view is a virtual table which consists of columns from one or more tables. Through it is same to a table; it is stored in
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