MCQs – SQL Join and SQL View

MCQ – Multiple choice questions on SQL join and SQL view with answers and explanation. These SQL join and view mcq are asked in Software jobs written interviews.


Q) The SQL join which does Cartesian product is called?
  1. Left Join
  2. Left Outer Join
  3. Right Outer Join
  4. Cross Join

Answer: 4


 
Q) Which SQL Join is used for joining the table itself?
  1. Left Join
  2. Self-Join
  3. Natural join
  4. Left Join

Answer: 2


 
Q) Advantages of View are
  1. Security
  2. Query re-usability
  3. Abstraction – hiding data
  4. All

Answer: 4


Q) SQL Views are also known as
  1. Complex tables
  2. Simple tables
  3. Virtual tables
  4. Actual Tables

Answer: 3


Related Posts