PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2021 paper

Unit 2: Relational Query Languages

20212m

Which join refers to join records from the right table that have no matching key in the left table and are included in the result set?

  • (i) Left outer join
    (i) Right outer join
    (iii) Full outer join
    (iv) Half outer join
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (ii) Right outer join (note option list typo duplicated (i))

Explanation: Right outer join preserves all tuples from right relation, left unmatched filled with NULL, e.g., A RIGHT JOIN B. Left outer join preserves left, Full preserves both. Half outer join is not standard term. The question wording matches right outer join definition.

Similar questions

DATABASE MANAGEMENT SYSTEM__________ operations do not preserve non-matched tuples. - (i) Inner join - (ii) Left outer join - (iii) Query - (iv) Relational schema20242mDATABASE MANAGEMENT SYSTEMWhich of the following operations is used if we are interested in only certain columns of a table? - (i) PROJECTION (ii) SELECTION (ii) UNION (iv) JOIN20212mDATABASE MANAGEMENT SYSTEMWhich of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause? - (i) With (ii) Check (iii) With check (iv) All of the above20212mDatabase Management SystemExplain the following operations with the help of examples: (i) Generalized projection (ii) Outer join (iii) Aggregate function20207m
PreviousThe Object Query Language is which of the following? - (i) Similar to SQL and uses a select-from-where structure (ii) Similar to SQL and uses a select-where structure (ii) Similar to SQL and uses a from-where structure (iv) Not similar to SQLNextList five responsibilities of the database manager. For each responsibility, explain the problem that would arise if the responsibility were not discharged.
Student FinanceWeb Platform

Pocketly — Personal Finance for Students

Keep your hostel and college expenses under control. Track accounts, log spending in seconds, and stay within your monthly budget.

Open Pocketly