Home

What are the desirable properties of a decomposition

A. Partition constraint.

B. Dependency preservation.

C. Redundancy.

D. Security.

You can do it
  1. ______contains information that defines valid values that are stored in a column or data type.
  2. In multiple granularity of locks SIX lock is compatible with
  3. Relations produced from an E-R model will always be
  4. The drawback of shadow paging technique are
  5. For using a specific database command is used.
  6. The values of the attribute describes a particular
  7. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  8. _____ command can be used to modify a column in a table
  9. Which of the following is not a recovery technique?
  10. The _____ category includes storage media that can be operated on directly by the computers central…
  11. Which of the following is not a consequence of concurrent operations?
  12. DROP is a statement in SQL.
  13. Which of the following is not a consequence of non-normalized database?
  14. Data items grouped together for storage purposes are called a
  15. Which of the following ensures the atomicity of the transaction?
  16. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  17. Maximum height of a B+ tree of order m with n key values is
  18. Cascading rollback is avoided in all protocol except
  19. In b-tree the number of keys in each node is than the number of its children.
  20. E-R Modeling is achieved by using ____ diagrams
  21. Which of the following is true for network structure?
  22. A top-to-bottom relationship among the items in a database is established by a
  23. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  24. A _____ is a logical unit of database processing that includes one or more data access operations that…
  25. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  26. A _____ is used to define overall design of the database
  27. Tree structures are used to store data in
  28. What are the desirable properties of a decomposition
  29. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  30. The rule that a value of a foreign key must appear as a value of some specific table is called a