Home

The statement that is executed automatically by the system as a side effect of the modification of the database is

A. backup

B. assertion

C. recovery

D. trigger

You can do it
  1. Relational Algebra is
  2. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  3. Protection of data from unauthorized Disclosure results in loss of _______
  4. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  5. DROP is a statement in SQL.
  6. Manager salary details are hidden from the employee .This is
  7. _____clause is an additional filter that is applied to the result.
  8. Tree structures are used to store data in
  9. The values of the attribute describes a particular
  10. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  11. ______is a preferred method for enforcing data integrity
  12. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  13. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  14. Which one is true statement :
  15. Wait-for graph is used for
  16. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  17. The rule that a value of a foreign key must appear as a value of some specific table is called a
  18. It is an abstraction through which relationships are treated as higher level entities
  19. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  20. A transaction is in state after the final statement has been executed.
  21. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  22. Change Staff table by removing default of Assistant for position column
  23. In E-R Diagram total participation is represented by
  24. The _____ category includes storage media that can be operated on directly by the computers central…
  25. The common column is eliminated in
  26. Relations produced from an E-R model will always be
  27. Which of the following relational algebraic operations is not from set theory?
  28. The one guideline to be followed while designing the database is
  29. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  30. The clause alter table in SQL can be used to