Home

______ keyword is used to find the number of values in a column.

A. TOTAL

B. ADD

C. COUNT

D. SUM

You can do it
  1. In an E-R diagram double lines indicate
  2. The normalization was first proposed by .
  3. The values of the attribute describes a particular
  4. DBMS helps achieve
  5. operator is used to compare a value to a list of literals values that have been specified.
  6. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  7. Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum…
  8. _____ database is used to provide statistical information or summaries of values based on various criteria.
  9. Maximum height of a B+ tree of order m with n key values is
  10. Which of the following is not a consequence of concurrent operations?
  11. Dependency preservation is not guaranteed in
  12. DROP is a statement in SQL.
  13. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  14. A transaction is in state after the final statement has been executed.
  15. If an entity can belong to only one lower level entity then the constraint is
  16. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  17. Which of the following ensures the atomicity of the transaction?
  18. A _____ is used to define overall design of the database
  19. The one guideline to be followed while designing the database is
  20. Which is the best file organization when data is frequently added or deleted from a file?
  21. For correct behaviour during recovery, undo and redo operation must be
  22. ______ keyword is used to find the number of values in a column.
  23. A _____ is a logical unit of database processing that includes one or more data access operations that…
  24. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  25. The graphical representation of a query is .
  26. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  27. In b-tree the number of keys in each node is than the number of its children.
  28. In E-R Diagram total participation is represented by
  29. Which one is true statement :
  30. The _____ category includes storage media that can be operated on directly by the computers central…