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

You can do it
  1. What are the desirable properties of a decomposition
  2. Tree structures are used to store data in
  3. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  4. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  5. The normalization was first proposed by .
  6. The cost of reading and writing temporary files while evaluating a query can be reduced by
  7. In E-R Diagram total participation is represented by
  8. Cascading rollback is avoided in all protocol except
  9. In SQL the word natural can be used with
  10. The middleware databases in which the business rules act are applicable to _______ tier architectures
  11. Key to represent relationship between tables is called
  12. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  13. DBMS is a collection of _____ that enables user to create and maintain a database.
  14. A relational database developer refers to a record as
  15. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  16. operator is used to compare a value to a list of literals values that have been specified.
  17. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  18. SQL server stores index information in the _____system table
  19. The rule that a value of a foreign key must appear as a value of some specific table is called a
  20. A _____ is used to define overall design of the database
  21. Maximum height of a B+ tree of order m with n key values is
  22. Which of the following is true for network structure?
  23. The data models defined by ANSI/SPARC architecture are
  24. Which one is correct statement?Logical data independence provides following without changing application…
  25. The drawback of shadow paging technique are
  26. Relational Algebra is
  27. Which of the following relational algebraic operations is not from set theory?
  28. Which of the following aggregate functions does not ignore nulls in its results?.
  29. Shadow paging has
  30. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are