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. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  2. Data items grouped together for storage purposes are called a
  3. Relational Algebra does not have
  4. In b-tree the number of keys in each node is than the number of its children.
  5. operator is used to compare a value to a list of literals values that have been specified.
  6. Relationships among relationships can be represented in an-E-R model using
  7. _____clause is an additional filter that is applied to the result.
  8. ______contains information that defines valid values that are stored in a column or data type.
  9. The one guideline to be followed while designing the database is
  10. Shadow paging has
  11. DBMS is a collection of _____ that enables user to create and maintain a database.
  12. Change Staff table by removing default of Assistant for position column
  13. In SQL the word natural can be used with
  14. Which is the best file organization when data is frequently added or deleted from a file?
  15. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  16. The full form of GUI is _________
  17. For using a specific database command is used.
  18. Which of the following is not a property of transactions?
  19. Isolation of the transactions is ensured by
  20. In 2NF
  21. If the closure of an attribute set is the entire relation then the attribute set is a
  22. In a relational schema, each tuple is divided into fields called
  23. Which of the following addressing modes permits relocation without any change over in the code?
  24. Which of the following is not a characteristic of a relational database model?
  25. A logical schema
  26. As per equivalence rules for query transformation, selection operation distributes over
  27. Precedence graphs help to find a
  28. The default level of consistency in SQL is
  29. The drawback of shadow paging technique are
  30. If an entity can belong to only one lower level entity then the constraint is