Home

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

A. Select

B. Order by

C. Group-by

D. Having

You can do it
  1. As per equivalence rules for query transformation, selection operation distributes over
  2. Which normal form is considered adequate for normal relational database design?
  3. A transaction is in state after the final statement has been executed.
  4. If an entity can belong to only one lower level entity then the constraint is
  5. Which of the following aggregate functions does not ignore nulls in its results?.
  6. Which of the following constitutes a basic set of operations for manipulating relational data?
  7. Which two files are used during operation of the DBMS?
  8. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  9. Shadow paging has
  10. _____ command can be used to modify a column in a table
  11. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  12. The data in the database at a particular moment of time is called the _______
  13. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  14. Cascading rollback is avoided in all protocol except
  15. What is a disjoint less constraint?
  16. Isolation of the transactions is ensured by
  17. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  18. A top-to-bottom relationship among the items in a database is established by a
  19. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  20. The rule that a value of a foreign key must appear as a value of some specific table is called a
  21. Which of the following is a reason to model data?
  22. Which of the following is not a characteristic of a relational database model?
  23. Data independence means
  24. DROP is a statement in SQL.
  25. Manager salary details are hidden from the employee .This is
  26. In multiple granularity of locks SIX lock is compatible with
  27. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  28. The drawback of shadow paging technique are
  29. Dependency preservation is not guaranteed in
  30. Which of the following concurrency control schemes is not based on the serializability property?