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.

Correct Answer : B.


Download Objective type questions of DBMS PDF

Get all objective type questions of DBMS MCQ

Also checkout these categories

Building Construction MCQ Mechanical Engineering MCQ Selenium automation MCQ Respiratory System MCQ General knowledge MCQ Current Affairs May 2017 MCQ Time and Distance MCQ Animal Kingdom MCQ Chemical Kinetics MCQ Algae MCQ Thermodynamics MCQ Direct TAX MCQ

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

Submit
Load More..
You can do it
  1. Which of the following is not a property of transactions?
  2. Which of the following aggregate functions does not ignore nulls in its results?.
  3. Processed data is called _____
  4. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  5. Checkpoints are a part of
  6. A top-to-bottom relationship among the items in a database is established by a
  7. An advantage of the database management approach is
  8. DROP is a statement in SQL.
  9. ………………… approach reduces time and effort required for design…
  10. In SQL the word natural can be used with
  11. Data items grouped together for storage purposes are called a
  12. Which of the following is not a consequence of non-normalized database?
  13. Which of the following is true for network structure?
  14. Immediate database modification technique uses
  15. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  16. Which of the following is not a consequence of concurrent operations?
  17. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  18. ____ table store information about database or about the system.
  19. The graphical representation of a query is .
  20. The rule that a value of a foreign key must appear as a value of some specific table is called a
  21. The collection of information stored in a database at a particular moment is called as ......
  22. E-R Modeling is achieved by using ____ diagrams
  23. For using a specific database …………… command is used.
  24. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  25. The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all…
  26. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  27. The values of the attribute describes a particular
  28. According to the levels of abstraction, the schema at the intermediate level is called
  29. A relational database developer refers to a record as
  30. Which of the following is not a recovery technique?