Home

The part of a database management system which ensures that the data remains in a consistent state is

A. authorization and integrity manager

B. buffer manager

C. transaction manager

D. file manager

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. Grant and revoke are _____ statements.
  2. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  3. The default level of consistency in SQL is
  4. The _______ is a set of programs to use and / or modify this data.
  5. HSAM stands for ……….
  6. Which of the following is a reason to model data?
  7. The part of a database management system which ensures that the data remains in a consistent state is
  8. What are the desirable properties of a decomposition
  9. ______contains information that defines valid values that are stored in a column or data type.
  10. The normal form that is not necessarily dependency preserving is
  11. The data models defined by ANSI/SPARC architecture are
  12. Protection of data from unauthorized Disclosure results in loss of _______
  13. The _____ category includes storage media that can be operated on directly by the computers central…
  14. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  15. Which is the best file organization when data is frequently added or deleted from a file?
  16. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  17. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  18. When an E-R diagram is mapped to tables, the representation is redundant for
  19. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  20. Which of the following is not a recovery technique?
  21. The statement that is executed automatically by the system as a side effect of the modification of the…
  22. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  23. Which of the following concurrency control schemes is not based on the serializability property?
  24. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  25. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  26. Relations produced from an E-R model will always be
  27. According to the levels of abstraction, the schema at the intermediate level is called
  28. If the closure of an attribute set is the entire relation then the attribute set is a
  29. In multiple granularity of locks SIX lock is compatible with
  30. Shadow paging has