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 is the best file organization when data is frequently added or deleted from a file?
  2. The part of a database management system which ensures that the data remains in a consistent state is
  3. Relations produced from an E-R model will always be
  4. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  5. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  6. The rule that a value of a foreign key must appear as a value of some specific table is called a
  7. Data items grouped together for storage purposes are called a
  8. If a transaction T has obtained an exclusive lock on item Q, then T can
  9. Which one is correct statement?Logical data independence provides following without changing application…
  10. ____specifies a search condition for a group or an aggregate.
  11. Which of the following addressing modes permits relocation without any change over in the code?
  12. operator is used to compare a value to a list of literals values that have been specified.
  13. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  14. The keyword to eliminate duplicate rows from the query result in SQL is
  15. In multiple granularity of locks SIX lock is compatible with
  16. An advantage of the database management approach is
  17. Which of the following is not a property of transactions?
  18. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  19. DBMS is a collection of _____ that enables user to create and maintain a database.
  20. The one guideline to be followed while designing the database is
  21. Relational Algebra does not have
  22. Maximum height of a B+ tree of order m with n key values is
  23. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  24. A relational database developer refers to a record as
  25. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  26. ______is a preferred method for enforcing data integrity
  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. _____ database is used to provide statistical information or summaries of values based on various criteria.
  29. Isolation of the transactions is ensured by
  30. Which normal form is considered adequate for normal relational database design?