Home

In SQL the statement select * from R, S is equivalent to

A. Select * from R natural join S.

B. Select * from R cross join S.

C. Select * from R union join S.

D. Select * from R inner join S.

You can do it
  1. The part of a database management system which ensures that the data remains in a consistent state is
  2. E-R Modeling is achieved by using ____ diagrams
  3. An advantage of the database management approach is
  4. In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
  5. Which one is correct statement?Logical data independence provides following without changing application…
  6. In SQL, testing whether a subquery is empty is done using
  7. For correct behaviour during recovery, undo and redo operation must be
  8. The data in the database at a particular moment of time is called the _______
  9. A transaction is in state after the final statement has been executed.
  10. Which of the following is not comparison operator?
  11. A logical schema
  12. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  13. Which of the following is not a recovery technique?
  14. approach reduces time and effort required for design and lesser risk in database management.
  15. _____is a full form of SQL.
  16. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  17. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  18. Which of the following is not a consequence of concurrent operations?
  19. In b-tree the number of keys in each node is than the number of its children.
  20. If a transaction T has obtained an exclusive lock on item Q, then T can
  21. Relationships among relationships can be represented in an-E-R model using
  22. In SQL the statement select * from R, S is equivalent to
  23. As per equivalence rules for query transformation, selection operation distributes over
  24. The concept of mapping of ______ entity types is the concept in which the for each strong entity type…
  25. The collection of information stored in a database at a particular moment is called as ......
  26. Which of the following relational algebraic operations is not from set theory?
  27. DBMS helps achieve
  28. ____specifies a search condition for a group or an aggregate.
  29. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  30. The data models defined by ANSI/SPARC architecture are