Home

The common column is eliminated in

A. theta join

B. outer join

C. natural join

D. composed join

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

You can do it
  1. Which of the following is a reason to model data?
  2. In multiple granularity of locks SIX lock is compatible with
  3. The data in the database at a particular moment of time is called the _______
  4. The data models defined by ANSI/SPARC architecture are
  5. Which of the following ensures the atomicity of the transaction?
  6. _____ command can be used to modify a column in a table
  7. Relational Algebra does not have
  8. If a transaction T has obtained an exclusive lock on item Q, then T can
  9. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  10. The normal form that is not necessarily dependency preserving is
  11. Which of the following is true for network structure?
  12. If both the functional dependencies : XY and YX hold for two attributes X and Y then the relationship…
  13. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  14. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  15. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  16. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  17. The metadata is created by the
  18. Key to represent relationship between tables is called
  19. HSAM stands for ……….
  20. For correct behaviour during recovery, undo and redo operation must be
  21. Which normal form is considered adequate for normal relational database design?
  22. The collection of information stored in a database at a particular moment is called as ......
  23. Precedence graphs help to find a
  24. E-R Modeling is achieved by using ____ diagrams
  25. What are the desirable properties of a decomposition
  26. If an entity can belong to only one lower level entity then the constraint is
  27. In 2NF
  28. Which two files are used during operation of the DBMS?
  29. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  30. ____ table store information about database or about the system.