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.
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
What is a virtual table that draws its data from the result of an SQL SELECT statement? View is a virtual table that draws its data from the result of an SQL SELECT statement.
Explain the relevance of Data Dictionary in a Database System? Data dictionary is a database in its own right residing on the disk that consist of Meta data which is = Data abo
(a) Differentiate between information and data . (b) List and briefly explain five potential benefits of the database approach compared to conventional file systems. (c) Diff
Normalization :It is a process of examine the given relation schemas based on their primary key and Functional Dependencies (FDs) to achieve the properties Minimizing redun
List the Armstrong's axioms for functional dependencies. What do you understand by soundness and completeness of these axioms? Ans: The Armstrong's axioms are: F1:
How Relational Calculus is different from Relational Algebra? What do understand by TRC queries and DRC queries? Ans: Relational calculus contain two calculi, the tuple relati
Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t
Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca
a publishing company produce scientific books on various subjects. the books are written by authors who specialize in one particular subject. the company employs editors who, not n
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