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 DDL? Make a list of commands with short description used in DDL Ans: Data Definition Language that is abbreviated as DDL is a computer language for defining data struct
Describe the primary key functions? Primary Key : The primary key is an attribute or a set of attributes in which uniquely identify a specific example of an entity. Every entit
The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined
Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro
Describe the different RAID levels. Discuss the choices of the different RAID levels for different applications. Ans: There are several combinations of these approa
please describe the data base management with the easy example &give the application?
Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t
1. Staff (staffID --> availabilityID) 2. Services (servicesID --> itemBasedID --> timedBasedID) 3. TimedBased (timedbasedID--> priceid) 4. Clients (clientId, serviceId-->
The database application project (DAP) for this assignment consists of the creation of a fully functional Microsoft Access database application for a real client. I recommend you s
Explain DML with some examples? DML - Data Manipulation Language: statements used for managing data within schema objects. Some examples: • SELECT - retrieve data from the a da
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