Home

The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

A. View

B. Order by

C. Group by

D. Having

You can do it
  1. Relations produced from an E-R model will always be
  2. The clause alter table in SQL can be used to
  3. When an E-R diagram is mapped to tables, the representation is redundant for
  4. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  5. The common column is eliminated in
  6. If the closure of an attribute set is the entire relation then the attribute set is a
  7. According to the levels of abstraction, the schema at the intermediate level is called
  8. Relationships among relationships can be represented in an-E-R model using
  9. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  10. approach reduces time and effort required for design and lesser risk in database management.
  11. Which of the following is not a property of transactions?
  12. Grant and revoke are _____ statements.
  13. In SQL the word natural can be used with
  14. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  15. The graphical representation of a query is .
  16. DBMS is a collection of _____ that enables user to create and maintain a database.
  17. Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for…
  18. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  19. An advantage of the database management approach is
  20. In a relational schema, each tuple is divided into fields called
  21. ____specifies a search condition for a group or an aggregate.
  22. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  23. Tree structures are used to store data in
  24. The data models defined by ANSI/SPARC architecture are
  25. A _____ is used to define overall design of the database
  26. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  27. _____clause is an additional filter that is applied to the result.
  28. Processed data is called _____
  29. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  30. Which of the following relational algebraic operations is not from set theory?