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!
Define check point and its impact on data base recovery.
Ans: There could be hundreds of transactions handled per minute, in a large on-line database system. The log for this kind of database consists of a very large volume of information. A scheme called checkpoint is utilized to limit the volume of log information that has to be handled and processed in the event of a system failure including the loss of volatile information. The checkpoint scheme is an extra component of the logging scheme. A checkpoint operation carried out periodically, copies log information onto stable storage. For all transactions active at checkpoint, their identifiers and their database modification actions that at that time are reflected just only in the database buffers, will be propagated to the suitable storage.
Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among
What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.
Improved Reliability: In a centralised DBMS, a server failure stops the operations of the DBMS. Though, a failure at single site of a DDBMS, or a failure of a communication link cr
Special comparison operator used in where Clause a. between. ...and...It gives range among two values (inclusive) Example: SELECT ENAME, SAL FROM EMP WHERE SAL BETWE
Need 2 projects completed in 3NF format.
What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data
How external/conceptual mapping and conceptual /internal mapping is performed
er diagtram for icici
Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External
In a job interview with a branch manager of a bank that operates in multiple Canadian provinces and the Yukon, you learn that all of the information is captured in real time in a s
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