Home

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

A. left outer join

B. right outer join

C. full outer join

D. inner join

You can do it
  1. A logical schema
  2. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  3. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  4. Maximum height of a B+ tree of order m with n key values is
  5. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  6. A _____ is a logical unit of database processing that includes one or more data access operations that…
  7. A data type or format is specified for each _________
  8. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  9. Relational Algebra does not have
  10. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  11. A top-to-bottom relationship among the items in a database is established by a
  12. The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify…
  13. Which of the following is a reason to model data?
  14. For correct behaviour during recovery, undo and redo operation must be
  15. _____ First proposed the process of normalization.
  16. Cascading rollback is avoided in all protocol except
  17. DROP is a statement in SQL.
  18. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…
  19. ____ table store information about database or about the system.
  20. In an ER model,_____ is described in the database by storing its data.
  21. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  22. HSAM stands for .
  23. In E-R Diagram total participation is represented by
  24. Which of the following is not a consequence of non-normalized database?
  25. Which of the following is not comparison operator?
  26. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  27. Tree structures are used to store data in
  28. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  29. The metadata is created by the
  30. SQL server stores index information in the _____system table