Home

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

A. COUNT .

B. COUNT (*)

C. MAX

D. MIN

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

You can do it
  1. For correct behaviour during recovery, undo and redo operation must be
  2. What is data integrity?
  3. A _____ is used to define overall design of the database
  4. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  5. Which of the following aggregate functions does not ignore nulls in its results?.
  6. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  7. DBMS helps achieve
  8. The data in the database at a particular moment of time is called the _______
  9. The values of the attribute describes a particular
  10. Cascading rollback is avoided in all protocol except
  11. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  12. ______contains information that defines valid values that are stored in a column or data type.
  13. The rule that a value of a foreign key must appear as a value of some specific table is called a
  14. A data type or format is specified for each _________
  15. The _____ category includes storage media that can be operated on directly by the computers central…
  16. ………………… approach reduces time and effort required for design…
  17. SQL server stores index information in the _____system table
  18. If the closure of an attribute set is the entire relation then the attribute set is a
  19. Which one is correct statement?Logical data independence provides following without changing application…
  20. Processed data is called _____
  21. It is an abstraction through which relationships are treated as higher level entities
  22. Wait-for graph is used for
  23. The default level of consistency in SQL is
  24. The metadata is created by the
  25. A table can have only one
  26. In b-tree the number of keys in each node is than the number of its children.
  27. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  28. operator is used to compare a value to a list of literals values that have been specified.
  29. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  30. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…