Home

The drawback of shadow paging technique are

A. Commit overhead

B. Data fragmentation

C. Garbage collection

D. All of these

You can do it
  1. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  2. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  3. As per equivalence rules for query transformation, selection operation distributes over
  4. Which of the following concurrency control schemes is not based on the serializability property?
  5. Protection of data from unauthorized Disclosure results in loss of _______
  6. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  7. _____ command can be used to modify a column in a table
  8. The statement that is executed automatically by the system as a side effect of the modification of the…
  9. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  10. ______contains information that defines valid values that are stored in a column or data type.
  11. Which of the following is not a recovery technique?
  12. The _______ is a set of programs to use and / or modify this data.
  13. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  14. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  15. Tree structures are used to store data in
  16. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  17. An advantage of views is
  18. _____ database is used to provide statistical information or summaries of values based on various criteria.
  19. In SQL the word natural can be used with
  20. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  21. Dependency preservation is not guaranteed in
  22. _____clause is an additional filter that is applied to the result.
  23. Which of the following is not a consequence of non-normalized database?
  24. Which one is true statement :
  25. In SQL, testing whether a subquery is empty is done using
  26. In multiple granularity of locks SIX lock is compatible with
  27. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  28. In b-tree the number of keys in each node is than the number of its children.
  29. Data independence means
  30. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…