Home

As per equivalence rules for query transformation, selection operation distributes over

A. Union.

B. Set difference.

C. Intersection.

D. All of the above.

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

You can do it
  1. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  2. _____clause is an additional filter that is applied to the result.
  3. If both the functional dependencies : XY and YX hold for two attributes X and Y then the relationship…
  4. The common column is eliminated in
  5. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  6. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  7. What is a disjoint less constraint?
  8. In SQL the statement select * from R, S is equivalent to
  9. An advantage of the database management approach is
  10. Which of the following is not a logical database structure?
  11. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  12. Which of the following is not a property of transactions?
  13. ………………… approach reduces time and effort required for design…
  14. The statement that is executed automatically by the system as a side effect of the modification of the…
  15. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  16. It is an abstraction through which relationships are treated as higher level entities
  17. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  18. If a transaction T has obtained an exclusive lock on item Q, then T can
  19. _______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal…
  20. Data items grouped together for storage purposes are called a
  21. A _____ is used to define overall design of the database
  22. DROP is a statement in SQL.
  23. Checkpoints are a part of
  24. Shadow paging has
  25. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  26. In multiple granularity of locks SIX lock is compatible with
  27. Relations produced from an E-R model will always be
  28. ______ keyword is used to find the number of values in a column.
  29. In 2NF
  30. The full form of GUI is _________