PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2024 paper

Unit 2: Relational Query Languages

20242m

__________ operations do not preserve non-matched tuples.

  • (i) Inner join 
  • (ii) Left outer join 
  • (iii) Query 
  • (iv) Relational schema
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (i) Inner join

Explanation: Inner join returns only matched tuples from both relations where join condition holds, non-matched tuples are discarded. Left outer join preserves all tuples from left relation plus matched from right, filling NULL where no match. Right/Full outer join similarly preserve non-matched. Query and Relational schema are not join operations.

Similar questions

DATABASE MANAGEMENT SYSTEMWhich of the following is generally used for performing tasks like creating the structure of the relations or deleting relations? - (i) DML - (ii) Query - (iii) Relational schema - (iv) DDL20242mDATABASE MANAGEMENT SYSTEMWhich 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 join20212mDATABASE 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 SYSTEMExplain the following operations with the help of examples: - (i) Set of intersection operation (ii) Natural join operation (iii) Division operation20217m
PreviousWhich of the following is generally used for performing tasks like creating the structure of the relations or deleting relations? - (i) DML - (ii) Query - (iii) Relational schema - (iv) DDLNextWhat do you mean by one-to-many relationships? - (i) One class may have many teachers - (ii) One teacher can have many classes - (iii) Many classes may have many teachers - (iv) Many teachers may have many classes
Official AppAndroid App

PYQDeck for Android

Solve BEU previous-year exam papers anywhere, anytime. Fast search, offline paper viewing, and step-by-step solutions designed specifically for your phone.

Get on Google Play