Home

Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are

A. m+n and 0

B. m+n and |m-n|

C. mn and 0

D. mn and m+n

You can do it
  1. Which of the following ensures the atomicity of the transaction?
  2. Which of the following concurrency control schemes is not based on the serializability property?
  3. In a relational schema, each tuple is divided into fields called
  4. In b-tree the number of keys in each node is than the number of its children.
  5. In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect…
  6. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  7. Which two files are used during operation of the DBMS?
  8. The drawback of shadow paging technique are
  9. ____specifies a search condition for a group or an aggregate.
  10. The collection of information stored in a database at a particular moment is called as ......
  11. Relations produced from an E-R model will always be
  12. _____clause is an additional filter that is applied to the result.
  13. It is an abstraction through which relationships are treated as higher level entities
  14. ______ keyword is used to find the number of values in a column.
  15. Tree structures are used to store data in
  16. _____ First proposed the process of normalization.
  17. Which of the following constitutes a basic set of operations for manipulating relational data?
  18. In SQL the word natural can be used with
  19. What is data integrity?
  20. E-R Modeling is achieved by using ____ diagrams
  21. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  22. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  23. _____ database is used to provide statistical information or summaries of values based on various criteria.
  24. Which normal form is considered adequate for normal relational database design?
  25. In an E-R diagram double lines indicate
  26. For correct behaviour during recovery, undo and redo operation must be
  27. If the closure of an attribute set is the entire relation then the attribute set is a
  28. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  29. Change Staff table by removing default of Assistant for position column
  30. A ______ module is typically designed so that it will run on a user workstation or personal computer.