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!
ALTER TABLE Command: This command is used for variation of existing structure of the table in the given situation:
Syntax
ALTER TABLE
You require to put many constraints like that the database integrity is not compromised.
It is mandatory that for every table in the LDB hierarchy there should exist one GET statement in the report. False. It is not essential.
Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF. Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relati
Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1
Compare the two log-based recovery schemes in terms of ease of implementation and overhead cost. Ans: There are two types of log based recovery techniques: deferred update
What are attributes? Give examples. An entity is shown by a set of attributes. Attributes are descriptive properties possessed by every member of an entity set. Example: pos
Define Deadlock recovery measures To recover from deadlock, the cycle in the wait-for-graph should be broken. The common technique of doing this is to rollbac
Which is another name for weak entity? Child is another name of weak entity.
What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans
explain cascading rollback
The primary key is selected from the
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