Home

The keyword to eliminate duplicate rows from the query result in SQL is

A. DISTINCT

B. NO DUPLICATE

C. UNIQUE

D. None of the above

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

You can do it
  1. Which of the following is not a consequence of non-normalized database?
  2. Which of the following concurrency control schemes is not based on the serializability property?
  3. What is a disjoint less constraint?
  4. ______is a preferred method for enforcing data integrity
  5. Which of the following is a reason to model data?
  6. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  7. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  8. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  9. Which one is correct statement?Logical data independence provides following without changing application…
  10. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  11. Which of the following is not a consequence of concurrent operations?
  12. The default level of consistency in SQL is
  13. The drawback of shadow paging technique are
  14. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  15. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  16. ____ table store information about database or about the system.
  17. In b-tree the number of keys in each node is than the number of its children.
  18. Shadow paging has
  19. Which normal form is considered adequate for normal relational database design?
  20. The full form of GUI is _________
  21. Cascading rollback is avoided in all protocol except
  22. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  23. The normalization was first proposed by .
  24. A _____ is used to define overall design of the database
  25. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  26. An advantage of views is
  27. If an entity can belong to only one lower level entity then the constraint is
  28. The metadata is created by the
  29. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  30. In SQL, testing whether a subquery is empty is done using