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 Log Based Recovery Method?
The system log that is generally written on stable storage consists of 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 known as the DBMS journal. In case of system crash the log is processed from the starting to the point where system crashes. Every transaction, those have been recorded their-of-transaction marker, will be committed if not rolled back. The simplicity and very easy to use the main benefits of this method.
The drawback are:
(A) Inefficient for the application, which have large volume of information,
(b) In case of system crash along with loss of volatile information, the log information collected in buffers will as well be lost and transaction that had been completed for some period prior to the system crash might be missing their relevant end-of-transaction markers in the log; if such transactions are rolled back then similarly to be partially undone.
What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers
Name the metrics for selecting top algorithm There are a number of metrics for selecting top algorithm: i) Computational complexity: Computational complexity refers to eff
Database Manager It is the interface among low-level data, queries and application programs. Databases typically need a large amount of storage space. It is kept on disks, as
What are the different approaches for database design? There are two basic approaches for database design which are as follows: Attribute driven: It compiles a list of att
What is Data Storage? The storage structures and access methods used by database system are specified by a set of explanation in a special type of DDL called data storage-defin
Single-Valued Dependencies A database is a collection of related information and it is therefore inevitable that some items of information in the database would depend on some
How can you Start MySQL Server? To start the mysql program type it is name in the command- line prompt. After starting mysql program just display A welcome letter using the
Define an abstraction by which relationships are treated as higher level entities Ans: Aggregation. It is an abstraction by which relationships are treated as higher level
Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode
In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.
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