Home

_____clause is an additional filter that is applied to the result.

A. Select

B. Order by

C. Group-by

D. Having

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

You can do it
  1. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  2. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  3. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  4. Relationships among relationships can be represented in an-E-R model using
  5. Which one is true statement :
  6. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  7. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  8. Which of the following is not a logical database structure?
  9. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  10. Which one is correct statement?Logical data independence provides following without changing application…
  11. Tree structures are used to store data in
  12. Which is the best file organization when data is frequently added or deleted from a file?
  13. Which of the following addressing modes permits relocation without any change over in the code?
  14. Which of the following aggregate functions does not ignore nulls in its results?.
  15. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  16. Shadow paging has
  17. ………………… approach reduces time and effort required for design…
  18. Union operator is a :
  19. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  20. When an E-R diagram is mapped to tables, the representation is redundant for
  21. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  22. operator is used to compare a value to a list of literals values that have been specified.
  23. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  24. The transactions like adding an employee, enrolling a student in a course are examples of _______
  25. The data models defined by ANSI/SPARC architecture are
  26. The _______ is a set of programs to use and / or modify this data.
  27. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  28. As per equivalence rules for query transformation, selection operation distributes over
  29. DBMS is a collection of _____ that enables user to create and maintain a database.
  30. The relational model is based on the concept that data is organized and stored in two-dimensional tables…