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. Which of the following statement on the view concept in SQL is invalid?
  2. Relations produced from an E-R model will always be
  3. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  4. The values of the attribute describes a particular
  5. Grant and revoke are _____ statements.
  6. Key to represent relationship between tables is called
  7. ______is a preferred method for enforcing data integrity
  8. Which of the following is not a consequence of concurrent operations?
  9. In E-R Diagram total participation is represented by
  10. _____ command can be used to modify a column in a table
  11. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  12. DBMS helps achieve
  13. Which of the following constitutes a basic set of operations for manipulating relational data?
  14. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  15. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  16. The drawback of shadow paging technique are
  17. Which of the following is not a recovery technique?
  18. The collection of information stored in a database at a particular moment is called as ......
  19. The cost of reading and writing temporary files while evaluating a query can be reduced by
  20. Dependency preservation is not guaranteed in
  21. _____ First proposed the process of normalization.
  22. The rule that a value of a foreign key must appear as a value of some specific table is called a
  23. operator is used to compare a value to a list of literals values that have been specified.
  24. As per equivalence rules for query transformation, selection operation distributes over
  25. HSAM stands for .
  26. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  27. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  28. Which one is correct statement?Logical data independence provides following without changing application…
  29. Checkpoints are a part of
  30. In a relational schema, each tuple is divided into fields called