Home

Which of the following aggregate functions does not ignore nulls in its results?.

A. COUNT .

B. COUNT (*)

C. MAX

D. MIN

You can do it
  1. Manager salary details are hidden from the employee .This is
  2. For correct behaviour during recovery, undo and redo operation must be
  3. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  4. The graphical representation of a query is .
  5. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  6. The keyword to eliminate duplicate rows from the query result in SQL is
  7. _____ First proposed the process of normalization.
  8. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  9. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  10. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  11. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  12. Processed data is called _____
  13. In b-tree the number of keys in each node is than the number of its children.
  14. Which of the following relational algebraic operations is not from set theory?
  15. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  16. Which of the following ensures the atomicity of the transaction?
  17. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  18. The values of the attribute describes a particular
  19. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  20. Wait-for graph is used for
  21. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  22. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  23. The _____ category includes storage media that can be operated on directly by the computers central…
  24. approach reduces time and effort required for design and lesser risk in database management.
  25. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  26. Shadow paging has
  27. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  28. Which of the following addressing modes permits relocation without any change over in the code?
  29. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  30. Which of the following is not a consequence of concurrent operations?